Pleease !!!!!! ssrs parameters filters with measures

• Lidou123

  Hall of Fame

  Points: 3186

  More actions

  March 11, 2015 at 11:37 am

  #316217

  Hi All,

  I need to create a basic mdx report that I want to modify the measures that I want to display;

  For that I created 3 parameter

  - the 1st parameter @Typeofmeasure lists the measures that I want to display. I have 2 values (Volume, Sales)

  I created these values in specifying these values in the parameters properties

  - The 2nd parameter @TypeOfAggregation lists the way that I want these measures to aggregate. I have 3 values ( Year To date, Month to date and Running 12 Month). I created these 3 values in specifying these values in the parameters properties too

  - The 3rd parameter @Measures lists the measures that I want to display in my report.

  So when user choose "Volume" in the 1rst parameter and "Year To date" for the 2nd parameter I want to have [Measures].[Volume YTD] in the 3rd parameter. Like a cascading parameter.

  Please do you know how I do that ???

  I know what to create a list of values with an SQL database but not with SSAS database . 🙁