Revelator80
Technical User
Hi,
I am building a report off a powercube and need to group data in a crosstab to identify whether something has been mapped or not. Unmapped items are assigned an 'Unregistered' Id so I have tried to create a data item that uses an IF statement for:
if([CPD_Cube].[All Suppliers].[All Suppliers].[Supplier Name]='Unregistered') then ('Unmapped') else ('Mapped')
I have tried various iterations and either get no data, no distinction (i.e. it all just gets lumped under 'Data Item 3' or this error message:
Unable to support query items from the same dimension on different report dimensions: dimension="[MEASURES]"; edge="axis(0)"; edge="axis(2)".
I'm new to all this so any help anybody can give would be greatly appreciated.
Cheers
I am building a report off a powercube and need to group data in a crosstab to identify whether something has been mapped or not. Unmapped items are assigned an 'Unregistered' Id so I have tried to create a data item that uses an IF statement for:
if([CPD_Cube].[All Suppliers].[All Suppliers].[Supplier Name]='Unregistered') then ('Unmapped') else ('Mapped')
I have tried various iterations and either get no data, no distinction (i.e. it all just gets lumped under 'Data Item 3' or this error message:
Unable to support query items from the same dimension on different report dimensions: dimension="[MEASURES]"; edge="axis(0)"; edge="axis(2)".
I'm new to all this so any help anybody can give would be greatly appreciated.
Cheers