Formatting currency values in MDX
Let’s start with simple example. We have simple Sales measure and query for it with SELECT Measures.Sales on COLUMNS FROM Sales If this query is executed in MDX Query pane of SQL Workbench or in MDX Sample it will display the following result: $266,000.
Both of these tools, as well as most of the well-behaving AS client tools are displaying is FORMATTED_VALUE cell property of the cell. We know from OLEDB for OLAP and XMLA specifications, that FORMATTED_VALUE is derived from two other cell properties – VALUE and FORMAT_STRING by using OLE Automation VarFormat function.
Tags: mdx