|Formatting Calculated Members|
|Written by Teo Lachev|
|Sunday, 15 July 2012 16:42|
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...