Skip to main content
G
GregHertling
Newcomer
October 4, 2022
Solved

Member name and description in different columns

  • October 4, 2022
  • 3 replies
  • 0 views

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

Best answer by JackLacava

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

 

3 replies

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
October 5, 2022

Hi Greg,

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

G
GregHertlingAuthor
Newcomer
October 5, 2022

here is a better screenshot.

GregHertling_0-1664973343399.png

 

J
OneStream Employee
JackLacavaOneStream EmployeeAnswer
OneStream Employee
October 6, 2022

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

 

G
GregHertlingAuthor
Newcomer
October 5, 2022

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
R
RamuV
Member
October 27, 2022

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.

 

Terms & ConditionsAccessibility statement