comparing tuple value in case gives parsing error

[cognos05]

Hi All,

I am using the below statement in my case condition.

tuple(item([Last6Months],0),currentMember([Sales].[Shipped Customer].[Customer]),[Qty])
this statement when executed separately displays the correct value.

when used like

case when (tuple(item([Last6Months],0),currentMember([Sales].[Shipped Customer].[Customer]),[Qty])<>0)
Then (1)
Else (0)
End

gives me parsing error .

Thanks,
Nithya

[bdbits]

I think you need a value() function, something like:

case when (value(tuple(item([Last6Months],0),currentMember([Sales].[Shipped Customer].[Customer]),[Qty]))<>0)
Then (1)
Else (0)
End

[cognos05]

Hi,

Getting the below error when used value

Error : Getting Invalid coercion from measure to Hierarchy