October 2005 - Posts

• 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 Read More... Posted Thursday, October 13, 2005 10:53 PM by mosha | 1 Comments Filed under: mdx

• MDX functions in Analysis Services 2005

  When I discuss with people new features in Analysis Services 2005, I am often asked - "So, what are the new MDX functions you introduced". I always explain, that the changes to MDX in AS2005 are huge and dramatic, but they are not in the area Read More... Posted Tuesday, October 11, 2005 3:57 PM by mosha | 2 Comments Filed under: mdx