Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to give range for a variable value with SAP BW as a source

Hi All I have a requirement where I am using BW as a source . I would like to enter a range in the variable value . Can you pls let me know how we can enter range in the variables. Thanks Poojith...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Please find the attached screenshot,

For Fund/Sponsored Program variable, I would like to give values as a range like 52500100000 to 600000000000 rather than individual values.

Is there a way to do that?

 

vhms31's avatar
vhms31
New Member
6 years ago

Hi Anonymous , have you tried to:

  1. create Parameters in PowerQuery/ PowerBI (e.g. ValueStart, ValueEnd)
  2. create a List in PowerQuery from ValueStart to ValueEnd (Tip: {ValueStart .. ValueEnd} )
  3. use this List as Parameter in your SAP Query. In PowerQuery there should be a step that calls the function "Cube.Transform". There you can switch the entered value with your List