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



        • 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