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.
Hi Greg,
could you post a screenshot of what you have, to clarify the issue...?
here is a better screenshot.
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.
