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
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.