Display Conditional dimensions

[#1]

I have a table and set of pivot dimensions in some list boxes (See attached) .

I have given the condition:

GetSelectedCount (C_dimension) > 0 OR GetSelectedCount(S_dimension) > 0  OR GetSelectedCount(M_dimension) > 0 OR GetSelectedCount(P_dimension) > 0

for the table in calculation condition field in the 'General' tab of table properties. And with a condition like

=SubStringCount('|' & Concat(distinct C_dimension, '|') & '|', '|Customer|')

for every dimension in the 'enable conditional' option.

All the columns are getting displayed in the table when I did not select any pivot dimension from the list box. (Attached scenario displays all the dimensions from 1st ,2nd 4th list boxes even when they are not selected. For this scenario I want to display 'Material' and corresponding expressions 'Total Sales E' , 'Total Sales Y' only. It should not display un-selected dimensions from other list boxes ).

I read the dimensions from the following script.

CustomerDimensions:

LOAD * INLINE [C_dimension

Customer

Business Area

Country

Profit Center

Region

];

SalesDocDimensions:

LOAD * INLINE [S_dimension

Sales Office

Sales Order

Currency

Sales Order Item

];

MaterialDimensions:

LOAD * INLINE [M_dimension

Material

MaterialDescription

MUG Header

Material Category

MUG

NKE

];

PeriodicalDimensions:

LOAD * INLINE [P_dimension

Week

Year

Month

];

I want the table not to display columns which i don't select. Should show some message if i don't select any dimension at all.

TIA,

James

[LCardonne]

Hi,

I'm doing the very same thing and it works fine when I'am in the dev mode.

But it does not work any more when I deploy the document on the server! 😞

Would you have any idea why?

I actually have the same issue with another method also using "enable conditional" for dimension: I use a variable v_ShowHide that is switched from 0 to 1 by a button and the enabling condition is "v_ShowHide =1". I have also tried "$(v_ShowHide) =1", "=if(v_ShowHide =1, 1, 0)", "=if($(v_ShowHide)=1, 1, 0)"... All work on my PC in dev app but not on the server!

Cheers,

Lilian