COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: wyconian on 28 May 2008 06:57:04 AM

Title: NVL function on tuples
Post by: wyconian on 28 May 2008 06:57:04 AM
Hi

I'm hvaing problems adding functions to tuple statements can you help?

What I'm tyring to do is say something like tuple([WTD], NVL([NET SALES],0)) but when I try to add any functions to the tuple statement the query goes completely to pot and can't find any of the items in the query.

Any ideas?

Thanks for the help again.
Title: Re: NVL function on tuples
Post by: rockytopmark on 28 May 2008 08:18:36 AM
Mixing relational functions with Dimensional will generally not workout as you intend.

Are you trying to force a ZERO where there is a NULL returned?  If so, there is no way to do that in a dimensional world, unless there is truly a tuple of those specific members. 

You might try using the member() function in some form here, to create the Tuple you need.  It would be nice to know if there really is a way.
Title: Re: NVL function on tuples
Post by: wyconian on 28 May 2008 08:53:47 AM
That's exactly what I was trying to do and you're right it doesn't work.  Oh hum...

Thanks for the response.