1 Reply Latest reply on Aug 6, 2013 2:55 AM by Peter Thomsen

    accessing cube dimension in calculated field

    Syed Shah

      Hi,

       

      I am trying to create a calculated field where we need to make a condition on a dimension. Howeer, I cannot access the dimensions in the calculated field window. We are using Microsoft analysis cubes in our reports. Can someone please give a suggestion on how can we access the dimension in the calculated field. I know it is easy when we are using relational data

       

      Regards

      Arif

        • 1. Re: accessing cube dimension in calculated field
          Peter Thomsen

          Hi Arif

           

          Cubes are a totally different beast in this context.

           

          The short answer is, that you can't in a calculated field....

           

          However, if you know a little MDX (the query language of cubes) you can create your own calculated members. The syntax of the calculated member will be something like ([Dimension Name].[Attribute Name].[Member Name], [Measures],[Measure Name]) or as an real example: ([Customer].[Customer Name].[Inspari], [Measures],[Sales])

           

          This will give you the value of Sales for the customer named Inspari

           

          Hope it help

           

          Cheers

          //Peter