using colors in calculated member

Im using this query in MDX for a calculate measure开发者_如何学Go

topcount(nonempty([StatusPlanes].[Status].Status.members,[Measures].[Planes]),1)(0).member_caption

this will bring me this result

Dimension1 Measure Center 1 'Status 1' ---> i want this text blue Center 2 'Status 2' ---> i want this text in red Center 3 'Status 3' Center 4 'Status 2'

the thing I want to do is to add some color depending on the status... is this possible in mdx???

thank you in advance

Adriana

You can set the color with code similar to that in this blog post

The format of the color property is documented here

You can use CELL PROPERTIES.

The property you are looking for is FORE_COLOR

However, take into account that your front-end tool must support it (not all of them do)