posted on Saturday, July 28, 2007 5:03 PM
by
marcorusso
Red color for negative numbers in Analysis Services 2005
Sometimes there is a simple way to solve an issue. For example, if you want to color all measures (including calculated measures) in red when the value is negative, you can simply write:
SCOPE( Measures.AllMembers );
FORE_COLOR(THIS) = IIF( Measures.CurrentMember < 0, 255, 0); // 255 = RED
END SCOPE;
MDX Script is so better than classical properties for each measure in these cases...
Cross-posted from SQLBlog! -
http://www.sqlblog.com