10-04-2022 06:43 PM - last edited on 05-24-2023 11:49 AM by JackLacava
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
Solved! Go to Solution.
10-06-2022 06:26 AM
You can set the Row Header size to 0 to hide them, then manage the actual columns as you see fit.
10-05-2022 05:36 AM
Hi Greg,
could you post a screenshot of what you have, to clarify the issue...?
10-05-2022 08:35 AM
here is a better screenshot.
10-06-2022 06:26 AM
You can set the Row Header size to 0 to hide them, then manage the actual columns as you see fit.
10-05-2022 08:01 AM
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 |
10-27-2022 04:20 PM
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.