The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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
You can set the Row Header size to 0 to hide them, then manage the actual columns as you see fit.
5 Replies
- JackLacava
OneStream Employee
Hi Greg,
could you post a screenshot of what you have, to clarify the issue...?
here is a better screenshot.
- JackLacava
You can set the Row Header size to 0 to hide them, then manage the actual columns as you see fit.
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 Entity Account Entity Description Account Description 1650 140200 Entity 1 Description Account 1 Description -2692368.71 1650 140800 Entity 1 Description Account 2 Description 4619250 1650 150130 Entity 1 Description Account 3 Description 29.68 1650 160010 Entity 1 Description Account 4 Description 2712403.86 1650 160025 Entity 1 Description Account 5 Description -22598833.59 1650 150460 Entity 1 Description Account 6 Description 18775425.09 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.
