Hide rows for specified slice.
Posted: Fri Dec 20, 2024 1:29 am
Hi.
I have the next cube view with dims Context: Period; Rows: A, B; Column: Rate; Zero supression enable. This is a test cube to demonstrate problem.
I want for slice [Period].[~AnyPeriod~] + [A].[A_C] show only [/B].[B_C] element (without B_N_*_*). In other cases, elements B_C, B_N_*_* must be displayed.
I tried:
1. Focus and hide B_N_1_1, B_N_1_2. But its hide for all A dim elements
2. Write Rule to set Zero for [Period].[~AnyPeriod~] + [A].[A_C] + [B_C].[B_N_1_1, B_N_1_2], but zero supression algorithm supress zeros on C-level ([A].[A_C]) depends for childrens elements values, not overrided value by rules.
3. Think about using MDX for B dim. Like GENERATE([A].MEMBERS, FILTER(B.MEMBERS, [Test].([Period].CURRENTMEMBER, [A].CURRENTMEMBER) > 0)), but Its doesnt work as I expected.
4. Use CellSecurity to set NONE for specified elements [B_N_*_*]. It didn't work. maybe because I have admin rights. Im not sure that its good way.
I would be grateful if you suggest a solution to this problem. Thanks.
I have the next cube view with dims Context: Period; Rows: A, B; Column: Rate; Zero supression enable. This is a test cube to demonstrate problem.
I want for slice [Period].[~AnyPeriod~] + [A].[A_C] show only [/B].[B_C] element (without B_N_*_*). In other cases, elements B_C, B_N_*_* must be displayed.
I tried:
1. Focus and hide B_N_1_1, B_N_1_2. But its hide for all A dim elements
2. Write Rule to set Zero for [Period].[~AnyPeriod~] + [A].[A_C] + [B_C].[B_N_1_1, B_N_1_2], but zero supression algorithm supress zeros on C-level ([A].[A_C]) depends for childrens elements values, not overrided value by rules.
3. Think about using MDX for B dim. Like GENERATE([A].MEMBERS, FILTER(B.MEMBERS, [Test].([Period].CURRENTMEMBER, [A].CURRENTMEMBER) > 0)), but Its doesnt work as I expected.
4. Use CellSecurity to set NONE for specified elements [B_N_*_*]. It didn't work. maybe because I have admin rights. Im not sure that its good way.
I would be grateful if you suggest a solution to this problem. Thanks.