Forum Discussion
Solved
Dynamic Parameters with SAP BW BEX
Hi Team, I am using the SAP BW for connecting the data. I have 6 years of data . Initially i am pulling only 2 years of data into Power Bi desktop, so that i wont get any memory issues when i try...
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" }}},
