4 Replies Latest reply on Sep 14, 2016 11:19 PM by panjala Srinath

All Option In Parameter

Hi Team,

I have created parameter like below and written the calculation like below.

i am trying to define the Di-mention to display all measures. I need to add All option in the paratemeter, So that i can show all like NNN, LLL, RJJJ, RTTT.

Can any one help me on this..

if [Parameters].[Example]='NNN' THEN "NNN"

ELSEIF [Parameters].[Example]='LLL' THEN "LLL"

ELSEIF [Parameters].[Example]='RJJJ' THEN "RJJJ"

ELSEIF [Parameters].[Example]='RTTT' THEN "RTTT"

END

• 1. Re: All Option In Parameter

PFA work book for your reference.

• 2. Re: All Option In Parameter

We are sorry to inform that your framing of question is not helping us to understand the required result.

It will be great if you can clearly explain the expected out put and the logic that you want to implement.

Thanks & Regards

Srinath.Panjala

• 3. Re: All Option In Parameter

Sorry..

I have created parameter with 4 values.

in the below screen shot, i have selected 'NNN', so that only NNN is displaying in the view. But i need to show all values what at a time on the view. so that if we have all option in the parameter all values(LLL,RTTT,RJJJ) will show.

MY requirement is i need show all at once on the view ....

I hope i am clear now...

We can do this requirement by using measure Names and Measure values, but i need to show the % also on on the view.

so with this option i am trying...@

• 4. Re: All Option In Parameter

Before confirming that your requirement will not be possible with parameters i would like to provide you with few clarifications

In the calculation "Example" that you have written. A single if statement is executed which returns "String_that you specified_which is static across all the records".

Generally parameter calculations return the referenced-fields for the satisfied if logic.

your requirement may be not possible with this approach.

Thanks & regards

Srinath.Panjala