2 Replies Latest reply on Oct 4, 2016 1:03 PM by Sean Mullane

    Changing Dimensions using Parameters - MDX

    Yilin Xie

      hi,

       

      the datasource i am woking on is a powerpivot datasource. I would like to create a workbook that allows the user to select different dimensions to explore the different "cuts" of the data.

      my attempt to achieve this is to use Parameters.

       

      below is a simplified version of my approach:

       

      step 1: create Parameter titled "Testing"

      Create a listed parameter with "Age Grp"

       

      Step 2: create calculated member titled "Select Dim"

      Case [Measures].[Parameter_Testing]

      When "Age Grp" Then [Table].[Age Grp]

      End

       

      *Note:

      I manage to obtain the Parameter's name through opening the twb file using notepad.

      [Table].[Age Grp] is the dimension in my datasource I wish to use

       

      Step 3: pull "Select Dim" to columns and "Sum population" to "Text" Marks

       

      Result:

      Null for the chart's column and the value is the total sum of population

       

      I think there is some error in my MDX query. Hope to get some pointers on how I can do this correctly.

       

      Thanks!!