Skip to main content
Newcomer
Oct 4, 2022 10:43 PM UTC
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 in on two columns after the names which looks odd.

thanks,

Greg

Employee - Sage
Oct 6, 2022 10:26 AM UTC

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

 

5 replies

Employee - Sage
Oct 5, 2022 9:36 AM UTC

Hi Greg,

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

Newcomer
Oct 5, 2022 12:35 PM UTC

here is a better screenshot.

GregHertling_0-1664973343399.png

 

Employee - Sage
Oct 6, 2022 10:26 AM UTC

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

 

Newcomer
Oct 5, 2022 12:01 PM UTC

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
Member
Oct 27, 2022 8:20 PM UTC

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.