Forum Discussion

ncbshiva's avatar
ncbshiva
Advocate V
7 years ago
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...
Need Help
  • ncbshiva's avatar
    ncbshiva
    7 years ago

    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" }}},

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

this is what i wanted to change. I am new to PowerBI.