Posted: 11/4/2011
I have been getting error for the below calculated measure.
CREATE MEMBER CREATECUBE.[Measures].WOP
AS
CASE
WHEN ([Month].[Year].members >= "2011")
then [Measures].[M1]
else [Measure].[M2]
end,
Visible=1;
Scenario - Wen the year is <=2011, measure1 should get displayed else measure2.
wen i hardcode the year ([Month].[Year].&[2011]), it works
Could anyone please help me on this or provide better solution?
Thanks in advance!!
Posted: 1/4/2012
Get this working? I think you could do this with an immediate IIF statement.
IIF([Month].[Year].members >= 2011,Measures.M1,Measures.M2)
Posted: 4 days ago
IIF([Month].[Year].currentmember.properties("key") <= 2011, [Measures].[M1], [Measures].[M2]),
visible = 1;
Please let me know if this works. Also, note that the key column of the [Year] level should be the year.
Thanks,
Anish