Leverage a CV Rule or parameter to choose row primary dimension
We are looking to have a cube view that uses a parameter or CV Extender to possibly control the primary dimension selection. This is used in a dashboard to show metadata selections with the dimension in the rows and ud8 dynamic formulas across the columns. Looking to see if anyone has any ideas on doing the dimension selection dynamically to use one CV only for display
Hi Mike,
You want to dynamically select rows in a Cube View based on a prompt, where the prompt allows users to choose a dimension.
For example:
If the user selects the Account dimension, the Cube View displays the Account members in rows and their respective member properties in columns. The same logic applies to other dimensions.Implementation Steps (One Way to Achieve it)
Step 1: Create Foundation Cube Views
Create RowSet Cube Views for each dimension you want to support (including 8 User Defined dimensions):
- CV_RowAccount
- CV_RowEntity
- CV_RowFlow
- CV_RowScenario
- CV_RowUD1 to CV_RowUD8
Create a ColumnSet Cube View that displays the member property information:
- CV_ColumnMemberProperty
Step 2: Create a Delimited Parameter
Create a delimited parameter called PromptDimension to store the names of the RowSet Cube Views and provide a user-friendly description.
- Delimited Values
CV_RowAccount,CV_RowEntity,CV_RowFlow,CV_RowScenario,CV_RowUD1,CV_RowUD2,CV_RowUD3,CV_RowUD4,CV_RowUD5,CV_RowUD6,CV_RowUD7,CV_RowUD8 - Delimited Descriptions
Account, Entity, Flow, Scenario, UD1, UD2, UD3, UD4, UD5, UD6, UD7, UD8
Step 3: Create the Master Cube View
Create a Master Cube View that uses row and column sharing:
- Shared Column View: CV_ColumnMemberProperty
- Shared Row View (Dynamic): |!PromptDimension!|
This setup will allow the Master Cube View to dynamically change based on the selected dimension from the prompt.
Step 4: Execution
When users run the Master Cube View, they will be prompted to select a dimension.
Based on their selection, the corresponding RowSet Cube View will be attached dynamically, and the column view will display member properties.
Optional Enhancement: Guided Reporting
Use Guided Reporting to enhance the user experience and get the look of the dashboard.
