conditional columns hide/show with OLAP Cube source, C8.2 report std

[sem123]

Hi, I am facing one problem hiding & dipalying 2 columns based on Value from user prompt selection.

I have gone thru few samples on the forum & tried accordingly. But i have OLAP cube source and facing problem with it..

To describe my case :
I have list reports contains many columns..

1) I have value prompt on prompt page (including other prompts as well)
For this : User select Single value, from List values of members
2) I have added all calculated columns in list..
3) I tried creating variable & then mapping as style variable on that Column & box property None.. But it doesn’t work..

Now I need to show & hide..

I require, if User select value ‘A’ (member from list)
then show column 1 and 2 ( which is Value(tuple…)Measure columns)

Same way, if user select ‘B’ then show column 3 & 4

My problem is what should I write in Expression Editor:

I tried:
case when ParamDisplayValue('PLow_Scenario')contains 'ACT'
then 'A'

When ParamDisplayValue('PLow_Scenario')contains 'PROMPT'
Then 'P'

End

OR

Case when
ParamValue('PLow_Scenario') = [MixPub (PROD>SDS)].[Scenarios].[Scenarios]->:[DO].[Scenarios].[STAR]

Then ‘A’

Else ‘P’

End

But it’s not working..

Can anybody guide me on this.. where I am doing wrong..

Thanks in advance..

S

 

[sem123]

Hello.. at last i figure out myself..it's ok now..