0 Replies Latest reply: Apr 20, 2016 1:50 PM by Domingo Barros RSS

    How can I choose the level from wich the data will be extracted when connected to my essbase data source?

    Domingo Barros

      Hi, I have the following dimensions:

      Market

           -East(+)

                -Market1(+)

                -Market2(+)

           -South(+)

                -Market3(+)

           -Center(+)

                ....

           -West(+)

                ...

       

      Messure

           -Profit

       

      I want to calculate the standart deviation of the profit but only want the consolidated values from East, South, Center, West; I dont want to use every market value.

       

      I don`t want to use the aggr function beacause in the futer I want to do the same analisis with some metrics that comes from a complex calculation from the cube.

       

      Thanks!