Monthly Archives: March 2009

More about context sensitive formatting

In the last post I wrote about context sensitive formatting. The goal was to format values differently depending on their digits, so that for example. 532 formats to 532 but 143,134 formats to 143K. When you try the formatting from … Continue reading

Posted in Allgemein | Leave a comment

Context sensitive dynamic formatting for measures

It’s commonly known that you can provide a format string for measures like in the following example: with MEMBER [Measures].[Sales Amount Fmt] AS  [Measures].[Sales Amount], FORMAT_STRING = "$0,000", NON_EMPTY_BEHAVIOR = { [Measures].[Sales Amount] } select  [Measures].[Sales Amount Fmt] on 0, … Continue reading

Posted in Allgemein | Leave a comment