| 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... |
Tags: mdx
