Hi,
I am working with cube based report. In my cube One_ID is the dimension(values are1,2,3,4,5 ..to 20)
I have to get a calculation based One_ID. So I am doing like this
total(if( [REGION11].[ONE_ID].[ONE_ID].[ONE_ID1].[ONE_ID - Long Name]=16) then([Total Cost]) else (0))
I am getting below error:
Invalid to compare values with different dataTypes.
Please any one can help me??
Hi,
Seems very odd syntax for an OLAP-type package.
Have you tried
tuple([member with ID of 16 from the package tree],[Total Cost])
MF.
try using 16 as '16' (in single quotes)