Forum Discussion

GregHertling's avatar
GregHertling
New Contributor III
3 years ago
Solved

Member name and description in different columns

Hi, is there a simple way to create a cube view with the member name and description in different columns?  Specifically, when there are nested members in the row.  I can pull in UD8, but they come i...
Cube View
  • JackLacava's avatar
    JackLacava
    3 years ago

    You can set the Row Header size to 0 to hide them, then manage the actual columns as you see fit.

     

RamuV's avatar
RamuV
New Contributor III
3 years ago

If my understanding of the requirement is correct, you want to display the Entity Name and Entity Description in separate columns in a single CubeView.

One way you can do it is by creating a simple flow member, call it Entity_Description, Make it DynCalc and you can use the annotation type like

 

Dim entityDesc As String = api.Pov.Entity.Description

Return entityDesc

 

Now you can use this as a column for your entity description as F#Entity_Description:V#Annotation

 

Similarly, you can use the logic for Accounts.

 

This worked for me.