SSRS Parameter Mdx

1
votes

Can you Create parameters in SSRS using MDX measures not dimension, to reword this question can you create a paramter using fact table measure

Explanation

i have 2 measures [Measures].[PTO Holiday Hours] and [Measures].[PTO Vacation] i need to have a drop down parameter of those 2 measures is it possible ? where if one measure paramter is selected it will display the users with [Measures].[PTO Vacation] or [Measures].[PTO Holiday Hours] based on selection ?

1
ssasmdx
Another possibility is retrieve both measures from SSAS then use an IIF expression in the SSRS textbox to decide which to display. – GregGalloway
Thanks @GregGalloway, sounds like another good solution. – Graesham Muchabaya

1 Answers

2
votes

Create a parameter, lets call it "myoptions" with those 2 options

+-------------------+--------------------------------+
|      Labels       |             Value              |
+-------------------+--------------------------------+
| PTO Holiday Hours | [Measures].[PTO Holiday Hours] |
| PTO Vacation      | [Measures].[PTO Vacation]      |
+-------------------+--------------------------------+

Create an expression for your query and either select one measure or another.

="WITH MEMBER X AS "+Parameters!myOptions.Value.ToString()+" SELECT {X} on 0, (...) on 1 FROM (...) "