08-24-2023 03:24 AM
Is there any way to get the cube view profile and Group Name of the CubeView using Business Rules?
Thanks.
Solved! Go to Solution.
08-24-2023 03:49 PM
Here is some code where you can loop through the rows of the data table and get the information needed (will have to change the "BalanceSheetCurrentPeriod_WF" to your CV Name):
08-24-2023 02:57 PM
There is, but a Group can exist in multiple Profiles. What would you like to return in that case? A list of all profiles?
08-24-2023 03:05 PM
So we want to show the path of the Selected Cube View, like if I run a CubeView it should show the corresponding Group and Profile of that cubeview.
08-24-2023 03:10 PM
Understood. But what if the group exists in multiple profiles (such as the below)? What Profile should show?
08-24-2023 03:25 PM
Okay understood, so if a group exists in multiple profiles then list of all the profiles and the group name should be displayed.
If the group is only in one profile then the Group name and the profile name should be displayed.
08-24-2023 03:49 PM
Here is some code where you can loop through the rows of the data table and get the information needed (will have to change the "BalanceSheetCurrentPeriod_WF" to your CV Name):
08-25-2023 05:28 AM
Thanks, It Worked!!