How to use multiple prompts for same dimension in Management Reporting

Requirement 

Like the Financial Reporting (FR), Management Report and Platform Reports do not support the multiple prompts selection for same dimension in grid. In a business scenario where we need to have multiple prompts for same dimension, it can be achieved using "Save selection" option. In below steps, we will discuss how can we use "save selection" option to meet the requirement of multiple prompts selection for same dimension.

For this demonstration, we will create the save selection for Period dimension.

1. Go to Grid -> open the window of Member Selection for Period dimension. click on "fx" and select the "View All Functions".

 

 2. Choose the Prompt and select the Prompt Label, Choice List and other options. Click on OK.

 3. As shown in below screen shot, click setting button and click on "Save Selection". 

 4. As shown in below screen, provide a name to save selection and click on OK.

 5. Click on OK. This save selection can be used in places within same grid.

 6. Go to another cell where we need to select prompt for period dimension again. As shown in below screen shot, from drop down select the "Save Selections".

 

 7. It will list down all the saved selections. choose the save selection for period which we created in above steps.

 

 This way, we can meet the requirement of multiple prompt for same dimension in a grid.

 

 Created by Mohit Jain and Megha Gupta