Hi guys,
 Any one here can solve the following issue ;

I have a cube in SSAS with sales measure, Sales Measure which is a fact table has Sales Amount, Tax, Order Quantity etc. Now,my question is, how do I get the sales amount column appear color appear red or green depending on the sales amount eg. <5000 ..

I also have a calculated member Average sales , which i computed as Measures.SalesAmount/Measures.OrderQuantity and there I tried the following conditions but, I get the Average Sales column colored and nothing in the sales amount column..I want to get the sales amount color change depending on the conditions.

I have attached jpeg file for reference. 

Thanks for your help.


IFF([Measures].[Sales Amount]>50,255,65280)

To do this you will create a SCOPE statement. You do this on the calculation tab of the by selecting a Script Command and using the following MDX.

SCOPE ([Measures].allmembers);
FORE_COLOR(THIS) = IIF([Measures].currentmember <0 ,'255','0');
END SCOPE

 Hi Sajhamitra,

I am a beginner with MDX.
That was a quick reply.Thanks for the help,but the code isnt working. keep getting error message AS follows,
The syntax for SCOPE is incorrect