how to show / hide keyfigures

[dieterzenger]

Hi,

i need to show/ hide different key figures (measures) in my data source based on the selection in a list box. i checked the ipad example (template3) which contains an example on restriction on measures. in my case it does not work. How do i know the name of my key figures dimension .

in the Example its stated like this:

DS_1.setFilterExt("Keyfigures", LST_MEASURES.getSelectedValue());

--> the syntax checker is complaining about "Keyfigures" ? how do i find the name in the Query / DS i embedded.

Tahnk you

dieter

[Former Member · Accepted solution]

Dieter,

I've created an example with a radio button to select the display

"Previous year versus Current Year" or "Budget versus Current Year"

Here is the corresponding coding

if ( FILTER_KYF.getSelectedValue() == 'BUD' )

{ DS_ANALYSIS.setFilterExt("00O2TMB1V91PPLDL99A8E33VD","00O2TMB1V91PPLDLKBZGDK21L; 00O2TMB1V91PPLDLKBZGDK8D5; 00O2TMB1V91PPLDLKBZGDKL09"); 

}

else

{ DS_ANALYSIS.setFilterExt(

"00O2TMB1V91PPLDL99A8E33VD","00O2TMB1V91PPLDL99A8E3GIH; 00O2TMB1V91PPLDLKBZGDK21L; 00O2TMB1V91PPLDLKBZGDKEOP"); 

}

The technical names of the key figures are coming from the query designer (cfr tab page Extended on key figure level).

- 00O2TMB1V91PPLDL99A8E33VD         Key figures (Structure)

- 00O2TMB1V91PPLDL99A8E3GIH          Revenue previous year

- 00O2TMB1V91PPLDLKBZGDK21L        Revenue current year

- 00O2TMB1V91PPLDLKBZGDK8D5       Budget current year

- 00O2TMB1V91PPLDLKBZGDKL09        Variance current year / budget

- 00O2TMB1V91PPLDLKBZGDKEOP      Variance previous year / current year

Regards,

  Ann

[dieterzenger · Accepted solution]

Thank you Ann