Conditional Formatting in Saiku

gistfile1.txt

In the mondrian schema xml:
-----------------------------------------------------------------------------------------------------------

   <CalculatedMember
       name="Profit"
       dimension="Measures">
     <Formula>[Measures].[Store Sales] - [Measures].[Store Cost]</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" expression="Iif(([Measures].[Store Sales] - [Measures].[Store Cost]) &lt; 10000, '|(#,##0.00 &#8364;)|style=red', '|#,##0.00 &#8364;|style=green')"/>
<CalculatedMemberProperty name="MEMBER_ORDINAL" value="4"/>
   </CalculatedMember>

MDX Example:
-----------------------------------------------------------------------------------------------------------
WITH MEMBER Measures.ProfitFormatted as Measures.Profit, FORMAT_STRING = IIf(Measures.Profit > 2000, "|### €|style='lightgreen'|link='http://www\.analytical-labs\.com?profit\=" || Cast(Product.CurrentMember.Name as STRING) || "'|","|(### €)|style='red'|")
SELECT
NON EMPTY CrossJoin({[Gender].[All Gender].Children}, {[Measures].[ProfitFormatted]}) ON COLUMNS,
NON EMPTY {Hierarchize({[Product].[Product Category].Members})} ON ROWS
FROM [Sales]