Leverage a CV Rule or parameter to choose row primary dimension

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.