COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: meri on 05 Oct 2010 07:00:11 AM

Title: param value in expression
Post by: meri on 05 Oct 2010 07:00:11 AM
Hi all,

I have a value parameter of type integer. Now, I want to use that parameter in expression on my time dimension. Something like this... CUBE.TIME.YEAR = ?year?

How do I write such query? I need somekind of cast?

Thnx
Title: Re: param value in expression
Post by: MFGF on 05 Oct 2010 09:20:29 AM
You could try adding a Query Calculation with syntax such as:

filter([Your Year Level from the cube],[Long Name attribute from the Year level] = ?year?)

MF.