Forum Discussion
Dynamic Parameters with SAP BW BEX
I was able to achieve this solution with help of some blogs.
Below is the example on how to pass the parameters in the SAP BW query.
First you need to define your parameter , in my case it was Fiscal Year
#"GetParameterValue" = "[" & (Fiscal_year) & "]",
Then you need to use the above parameter in the cubeApplyParameter query as shown below.
{Cube.ApplyParameter, "[0S_FYEAR]", {{"[0FISCYEAR]." & #"GetParameterValue", "[0FISCYEAR]." & #"GetParameterValue" }}},
Hi ,
You can create a parameter called Calday with some values which is required for you.
And replace the current value with Parameter that you have created.
#"GetParameterValue" = "[" & (Calday) & "]",
{Cube.ApplyParameter, "IP_CALDAY_FROM",& #"GetParameterValue"}
{Cube.ApplyParameter, "IP_CALDAY_TO",& #"GetParameterValue"}
Hi ,
we have implemented as you said but still, we are facing issues as shown in the below.
In My scenario, Caldayfrom and CaldayTo parameters are defined like this.
CalDayFrom : Type : Date
Suggested Value: Any value
Current value: 01-Aug-16
CalDayTo : Type : Date
Suggested Value: Any value
Current value: 30-Aug-16
In my SAP HANA spurce data is coming as follows
Thanks
Hi,
Change your parameters to the required format like 20160108. It should work
this is what i wanted to change. I am new to PowerBI.
How did you solved this issues? I have the same one