I have create a calculatet member "Active Product" with

[Products].CurrentMember.Properties("Inactive")

Is there a solution in the CubeEditor in the Properties
pane for the property ForeColor, if the
[Measure].[Active Product]
has the value = 'Y' then 'Green' or value = 'N' Then 'Red'?

For numeric measures I can set the ForeColor with e.g.
IIF([Measures].[DB1 +/- Vorperiode] < 0 , 255,0)
but I don't know what's the syntacs for character-measures.

Many thanks for a solution.

Use the VBA StrComp function. Here's an example:

WITH MEMBER measures.Foo as '"Y"', fore_color = 'Iif(StrComp(Measures.Foo,
"y")=0, 255, 0)'
select {measures.Foo} on 0
from sales
cell properties value, Formatted_value, fore_color

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Reinfried Englmair" <reinfried.englmair (AT) c-bergmann (DOT) at> wrote

Thank You very much. It's perfect.Thank's once more.