param value in expression

[meri]

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

[MFGF]

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.