Dynamically Selecting Measure & Dimension values in the View.

 

Parameter: Parameters are variable, which are used to pass the values dynamically to the view.

 

An example of using Parameter is "Dynamically Selecting Measure & Dimension values in the View.

 

 

1) Create a Parameter for Dimension Selection purpose "Dimension Parameter", By using this Parameter, we can select the Dimension Value (Field) dynamically.
9.png
2) Create a Parameter for Measure Selection purpose "Measure Parameter", By using this Parameter, we can select the Measure Value (Field) dynamically.
10.png
3) Create a Calculated Field for Dimension Selection  using the syntax in the image.
1`4.png
4) Create another calculated field for Measure Selection like below image.
15.png
3) Place "Measure Selection", "Dimension Selection"  calculated fields, Right click on both Parameters & Click on "Show Parameter Control". (Note: We can  select Max 1 Value at a time from any parameter, It means Parameter limitation is Select Max 1 Value at a time.)
11.png
12.png

 


13.png

 

==============================
The following example explains when measures located on two databases.

 

Create a Parameter5.png
By using Parameter, create 2 Calculation for QS1, QS26.png
7.png
Then Place two measures on the Report like below image.Then you can define different marks for both measures.
121.png
When we select "QS1" from parameter,
122.png
When select "QS2",
1123.png
When Select "Both",
121.png