Forum Discussion

sinanalmac's avatar
sinanalmac
Resolver I
7 years ago

What if parameter on SSAS

Hi all,

I used "what if parameter" function in a power BI report to filter some measures and values. It perfectly works. But Report's data is so big. file size reached 700 MB.  It works so slow when we want to see the report.  

 

We decided to move the repot's data to the Analysis server to make a live connection. We made all structure except "what if parameter" filter in the analysis server.

 

Because there is no what if parameter" in the analysis server


Do you have any idea?   What can I use instead of "What if parameter" in analysis server?

I tried to make the same table structure in the analysis server. but it didn't work 

 Target_parameter table is  created by "what if parameter".

Target Paramater = GENERATESERIES(0, 115000, 100)
Target Paramater Value = SELECTEDVALUE('Target Paramater'[Target Paramater])

 

 target parameter_II table is created by me.  on analysis server 

Target_Parameter_II = SELECTCOLUMNS ( CALENDAR ( 1, 115 ), "target_parameter_II", INT ( [Date]*100) )
target_parameter_value_II = IF (HASONEVALUE(Target_Parameter_II[target_parameter_II])=TRUE(),MAx(Target_Parameter_II[target_parameter_II]),0)





I'm sending my file  If you want to look at it 

https://www.dropbox.com/sh/w4fuymtxiktwlpi/AACRx-JwF2QlVAocqj066qVZa?dl=0

best regards

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi sinanalmac 

    Do you connect to SSAS Multidimensional Cube or SSAS Tabular data?

     

    Best Regards
    Maggie

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly