Formatting the color for a specific hierarchy in a cube

• nicklas.jonsson86

  SSC Veteran

  Points: 247

  More actions

  August 23, 2011 at 7:57 am

  #149576

  Hi,

  I want to change the color for values if they are negative, eg. < 500, but this should only be applied on all my month in my date hierarchy.

  The structure for hierarchy is [Year].[Month].[Day]

  If I use IIF-statement then all values in my cube < 500 will have red colors.

  IIF([[Measures].[CountOfRows] < 450,255,0)

  Anyone know how I could solve this issue?

• Kees Beimans

  SSC Eights!

  Points: 978

  More actions

  August 30, 2011 at 2:34 pm

  #1375240

  Hi,

  Extend your IIF statement. It looks like this, new code in BOLD and Italic

  FORE_COLOR =

  IIF ( ([Measures].[CountOfRows] < 450

  AND [DATE].[<Hierarchy_name>].CurrentMember.Level IS [DATE].[<Hierarchy_name>].MONTH[/i]

  , 255, 0 )

  Regards Kees