Use Case: Dynamically Compare Dimension Members Using Constant Selection
Welcome everybody to the third use case for using constant selection. If you have never heard of a constant selection and would like to understand the basics first check out our introductory blog.
In this example we will set up a comparison between one region, that can be chosen by the end user, and the other regions available in the model. Which region is compared to the rest can be decided through an input control. Here is what we are starting with, the Gross Margin per region.
In this case we will create a restricted measure based on Gross Margin and select the region as the restriction dimension. However, we will not select a fixed member but an input control. For the input control we select all members and the single selection. This way the end user will be able to choose only one region at a time in the input control. Additionally, you will do a constant selection of region. This is necessary to show the Gross margin for the specified region even if the chart has a drill-down by region.
The regional single select input control will be added to the page and the chart will now display the Gross Margin of the selected region for all regions. You can see the region MEE is selected in the input control on the left and that the Gross Margin fro MEE is shown in all regions:
This restricted, constant measure will allow us to dynamically show the difference in Gross Margin of the selected region to all others. For this we will add a variance. In the definition you will select the Gross margin as measure A and the newly created “Gross Margin Region Constant” as measure B. In the Variance details we will choose an integrated variance.
Below you can see what the variance looks like when APJ is selected…
…and what happens when you switch over to MEE.
To read about other use cases, check out the following blogs: