0 Replies Latest reply on Aug 3, 2018 5:01 AM by RIcky Hames

    Cube Data - How to create a parameter control that brings back desired year?

    RIcky Hames

      Hi Tableau Community,

       

      I am hoping for some support on an issue I have come across, for the first time I am using multidimensional data in a cube (Microsoft Analysis Services)

       

      The issue:

      I have multidimensional cube where I would like the user to be able to select using parameter controls which year of data (this example net sales) they would like to view

       

      The issue being is that because data in multidimensional, I can't bring the dimension into the calculated field like I have previously using relational data.

       

      I have done some research and they suggested MDX calculated member but I have no knowledge of how to use this.

       

      I have updated some screen shots which hopefully will explain a little more of the issue I am facing:

       

      Screen shot 1. Dimensions - Cube - how to link to calculated field?

       

      Screen shot 2. Calculated Member created using MDX!  (Not sure whether this is correct or not!) - created in order to pull into calculated field

       

      Screen shot 3. Calculated field

       

      Screen shot 4. Parameter Control

       

      I am hoping someone is going to say I am nearly there so any advice would be massively appreciated

       

      My ultimate goal is to get a dynamic dashboard which allows the user to select two different years and have a calculated field which subtracts one another

       

      Thank you for reading and helping

       

      Ricky Hames