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

Conditional statement with dimensional model source

Started by HERRERA, 30 Mar 2009 10:23:00 AM

Previous topic - Next topic

HERRERA

Hi !

Can i use Case statement at dimensional cube data source ? Im trying use this :

Case
When [fieldX] > 0
Then [fieldX]
Else [fieldY]
End

The expression its correct, dont have error, but when run the report, the following message appears :

The item '___ns_0' is not accessible.

I would like to know if you can use this type of expression in cubes.

hugs,
Herrera