Formatting Calculated Members

Consider the following calculated member definition added to the script in an Analysis Services cube:

CREATE MEMBER CURRENTCUBE.[Measures].[Revenue TTM] AS ([Measures].[Revenue Amount USD], [Relative Date].[TTM]), FORMAT_STRING = "Currency", VISIBLE = 1;

When you browse the member in Excel, you'll find that the member is not formatted as currency.

Read more...