Hi,
I have created a powercube over my data warehouse and what to show easily what status supplier details are, i.e. are they mapped or unmapped. Unmapped suppliers have an ID of 0 so I want to create a data item that just returns Mapped or Unmapped based on the ID (which is stored in the cube as the Category Code for the Supplier Name item).
I have tried the following:
if([CPD_Cube].[All Suppliers].[All Suppliers].[Supplier Name].[Supplier Name - Category Code] = 0) then ('Unmapped') else ('Mapped')
but when I try and pull in a spend measure (into a pie chart) I get the following error message:
Unable to support query items from the same dimension on different report dimensions: dimension="[MEASURES]"; edge="axis(0)"; edge="axis(2)".
To be honest, I haven't been on the Multi Dimenisonal Reporting course so I'm kind of blagging my way through this at the moment. Can anybody give any advice?
Cheers