COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: HERRERA on 30 Mar 2009 10:23:00 AM

Title: Conditional statement with dimensional model source
Post by: HERRERA on 30 Mar 2009 10:23:00 AM
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