Skip to main content
B
BenvanBergen
Contributor
November 14, 2023
Solved

Formatting of multiple Member Filters in CubeView

  • November 14, 2023
  • 1 reply
  • 0 views

Hello,

For purpose of grouping we have some accounts listed as member filter in a single row:

A#VOL_O_StockWIP:Name(Opening Stock Volume), A#VAL_O_StockWIP:Name(Opening Stock Value) etcetera

Some of these would need a different format to make it easer to recognize them, if I make a separate row the grouping on the primary filter will be gone.

Is there a code that can be used after a member filter to apply formatting?

A solution in either the cubeview, or Excel AddIn would be helpful.

Thanks in advance

Ben

Best answer by Manasa

Hi,

In the header/cell format section for that row, you can add one of the below conditions as per your requirement,

Based on Member Name:

Manasa_1-1699973874537.png

Based on Display Text:

Manasa_0-1699973711580.png

Note: make sure that the Level 1 Member filter dimension Type for that row is set to Account for the above conditions to work, if that's not the case, change the Row Expansion level accordingly. 

Thank you,

Manasa

 

1 reply

M
ManasaAnswer
Newcomer
November 14, 2023

Hi,

In the header/cell format section for that row, you can add one of the below conditions as per your requirement,

Based on Member Name:

Manasa_1-1699973874537.png

Based on Display Text:

Manasa_0-1699973711580.png

Note: make sure that the Level 1 Member filter dimension Type for that row is set to Account for the above conditions to work, if that's not the case, change the Row Expansion level accordingly. 

Thank you,

Manasa

 

    B
    BenvanBergenAuthor
    Contributor
    November 14, 2023

    Thanks Manasa, that is something I have seen before, but totally forgot about it. It's definitely working well.

     

    Appreciate the really quick reply!

      Terms & ConditionsAccessibility statement