Forum Discussion

Irina's avatar
Irina
Contributor
1 year ago
Solved

Columns with Name and Description of Account members dimension in cube view

Dear all,

Could you please advise is it possible to show Account Name and Description in cube view in two separate columns instead of single column?

Cube View
Reports
  • MG's avatar
    MG
    1 year ago

    HI

    My column looks like this:

    For testing, I'm using a UD8 member (called DimName, better name needed :) ) to hold the Dynamic Calc and I need to use an annotation member in the view dim because we're trying to see text in this column. 

    For testing, my dynamic calc was simply: 

    Return api.POV.Account.Description

     

4 Replies

  • MG's avatar
    MG
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    You could use the header "column" to show the account name and use a dynamic calc  in the first Data column to show the Account description. 

    In the example above, you could format the description column to match the header column and set the Header to only show account names. 

  • Irina's avatar
    Irina
    Contributor
    1 year ago

    Dear MG,

    Is it possible to show how configure Member Filter in column with account description in your example?

     

  • MG's avatar
    MG
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    HI

    My column looks like this:

    For testing, I'm using a UD8 member (called DimName, better name needed :) ) to hold the Dynamic Calc and I need to use an annotation member in the view dim because we're trying to see text in this column. 

    For testing, my dynamic calc was simply: 

    Return api.POV.Account.Description

     

  • Irina's avatar
    Irina
    Contributor
    1 year ago

    Thanks a lot! It works! I used the following Member Filter Member UD8 UD8#AccountDesc:V#Annotation