Member name and description in different columns

GregHertling
New Contributor III

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 in on two columns after the names which looks odd.

thanks,

Greg

1 ACCEPTED SOLUTION

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

JackLacava_1-1665051944287.png

 

View solution in original post

5 REPLIES 5

JackLacava
Community Manager
Community Manager

Hi Greg,

could you post a screenshot of what you have, to clarify the issue...?

here is a better screenshot.

GregHertling_0-1664973343399.png

 

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

JackLacava_1-1665051944287.png

 

GregHertling
New Contributor III

Sure, here you go.  Using UD8 in columns I can get Entity and Accounts description, but Entity doesn't show up next to Entity member.

    2022M9
EntityAccountEntity DescriptionAccount Description 
1650140200Entity 1 DescriptionAccount 1 Description-2692368.71
1650140800Entity 1 DescriptionAccount 2 Description4619250
1650150130Entity 1 DescriptionAccount 3 Description29.68
1650160010Entity 1 DescriptionAccount 4 Description2712403.86
1650160025Entity 1 DescriptionAccount 5 Description-22598833.59
1650150460Entity 1 DescriptionAccount 6 Description18775425.09

RamuV
New Contributor III

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.

 


RV