Skip to main content
SSAS WHERE vs. Subselect Puzzle
Entry Date: Rate:
RSS Description:
I've been involved recently in a quest to optimize an SSAS 2008 long-running query that would return the 12-month history of a KPI. Since the KPI was displayed on a dashboard page alongside other KPIs and charts, it was important to optimize the query as much possible.

Interesting real case study, comparing filtering on an MDX subselect (select from select) versus setting the filter in the where clausule.

One of the interesting conclusions of this test is that results may change depending on the cube size... more fun to our MDX fine tunning job.