Conditional Logic over TM1 Cube

[jv_oz]

Hello,

We have a TM1 cube with a measure that calculates as a 1 when a condition is true and a 2 when it is false. The rule for this calculates across all levels of all dimensions. We then want to use that in a BI report. We can display the 1 or 2 successfully and have built a Variable over the column to conditionally format it with green (1) or red (2).

What we really want is to display a "Yes" for the 1 and a "No" for the 2. 

Can someone please advise what we need to do to achieve this?

Thanks

John

[jv_oz]

I worked it out with a little help from a friend.

The steps are:
1. Highlight column heading
2. Choose "crosstab member fact cells"
3. General properties, define conents, yes
4. Unlock the report
5. Add text item to cell and OK without entering any text
6. Change Source Type to "report expression"
7. Enter a CASE statement with the logic to display the text[/li][/list]