Calculated Key Figure in SAC

[Vasu_Sac]

HI

I am looking Grand Total for kF Sales Forecast including dimension MatLine = “M1” value only.

For that I created calculated KF: Z_T_SALES_FORECAST_M1 and its working as expected (Keeping M1 values and other values are making zeros.

Next, I created another calculated KF Z_T_SALES_FORECAST_M1_FX and trying to be using Grand total of first KF but its not giving any values.

Not sure why its not summarizing the values based on first cal KF values.

KF1:  Z_T_SALES_FORECAST_M1:

IF( [d/MatLine]="M1" ,[Sales_Forecast]  ,0 )

KF2:  Z_T_SALES_FORECAST_M1_FX:

GRANDTOTAL([Z_T_SALES_FORECAST_M1])

Regards,

Vasu

Hi @N1kh1l 

My Model is planning with new KF model without Account dimension. I didn't see Restricted Measure option to create at Model level or Story level. Don't know why it is not appearing for my case. is some thing missing my end. Attached Restricted Measure. Png

Advance thanks for your inputs.

[N1kh1l · Accepted solution]

@Vasu_Sac 

I am looking Grand Total for kF Sales Forecast including dimension MatLine = “M1” value only.

For that I created calculated KF: Z_T_SALES_FORECAST_M1 : Change this to Restricted Measure on Material Line with value M1, something like below

Then your Grand Total will work

Hope this helps !!

Br.

Nikhil

[Vasu_Sac · Accepted solution]

Hi @N1K1HL My Model is planning with new KF model without Account dimension. I didn't see Restricted Measure option to create at Model level or Story level. Don't know why it is not appearing for my case. is some thing missing my end. Attached Restricted Measure. Png

[N1kh1l · Accepted solution]

You will see it exactly in the stories under the Measure option. Your screenshot is of calculated dimension and not measure. The place where you created the calculated measure, it has a dropdown for restricted measure also.

[Vasu_Sac · Accepted solution]

Hi @N1kh1l Thanks for help. Yes, I saw Restricted Measure option and it is working. Before close the thread, one question. I have story filter Mat_Line and these selections can I pass as Input to Restricted measure instead of hardcode the values like "M1"?

[N1kh1l · Accepted solution]

Vasu, when you create restricted measure when selecting the values you have a dropdown of input control instead of values. If you have page filters you can replace it with this input control for material line but if you have story filter then you need to use scripting to read story filter and assign the same value to input control.