Home Ask Login Register

Developers Planet

Your answer is one click away!

Graesham Muchabaya February 2016

SSRS Parameter Mdx

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 ?

Answers


mxix February 2016

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 (...) "

Post Status

Asked in February 2016
Viewed 3,250 times
Voted 12
Answered 1 times

Search




Leave an answer


Quote of the day: live life