MDX and DAX topics

Saturday, October 22, 2011

Three Strategies of Evaluating the MDX Aggregate Function

›
In the past two months, the Analysis Services development team was preoccupied with wrapping up SQL Server Denali development. I was racing ...
2 comments:
Wednesday, August 17, 2011

Interaction between MDX Subselect and Calculation

›
As Mosha Pasumansky has described in his blog AS2008MDX: subselects and CREATE SUBCUBE in non-visual mode , an MDX subselect performs two f...
20 comments:
Monday, June 27, 2011

Under the Covers: MDX IF Statement

›
It is a well-known best practice in the MDX community to avoid run-time checks by choosing SCOPE over IIF function, and for the same reason,...
1 comment:
Tuesday, May 31, 2011

Performance Considerations for Recursive Calculations in MDX (Part 2)

›
Last time I discussed MDX engine limitations in dealing with recursive calculations. Today I want to describe two more situations where use...
Wednesday, April 27, 2011

Performance Considerations for Recursive Calculations in MDX

›
The other day, while investigating a customer performance problem, Chris Webb came up with a sequence of very simple and targeted MDX queri...
9 comments:
‹
›
Home
View web version

About Me

Jeffrey Wang
View my complete profile
Powered by Blogger.