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

    disaggregate cube measure

    Syed Shah

      Hi All,

       

      I have using a live connection to olap cube. I have sale and profit measure and I want to do a scatter plot of sales against profit. However, I am getting only one point in the scatter plot because the data is being aggregated. Can someone please guide me how to disaggregate the measures so that I can get proper scatter graph

       

      Syed

        • 1. Re: disaggregate cube measure
          Peter Thomsen

          Hi Syed

           

          Little late for an answer so i'm adding it for future reference :-)

           

          Add the dimension the you want to disaggregate on the the level of detail. Say you have turnover and profit on your axis then add customer name/number to the level of detail to disaggregate on this field or product name/number to disaggregate on product.

           

          Hope it help

           

          //Peter