If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

If statement with powercube data source

Started by Revelator80, 29 Mar 2011 06:46:17 AM

Previous topic - Next topic

Revelator80

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