COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: S_N_Solution on 19 Aug 2009 11:25:00 PM

Title: Creating the data item for members
Post by: S_N_Solution on 19 Aug 2009 11:25:00 PM
Hi All,

I have to create the data item for few members.My Source is cube .The hierachy will be like this

X Level
a  member
b  member
d  member
e  member
f  member
g  member

I want to create the data item like (if (X in (a,b,c) then ('New') else ('Old')
I am creating report in report studio.
Is it possible to create like this?

Thanks in advance...
Title: Re: Creating the data item for members
Post by: billylodz on 20 Aug 2009 02:08:30 AM
if(caption(