Report Portal

SSAS WHERE vs. Subselect Puzzle

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. Rephrased to Adventure Works, the query went something like this:

Read more...

 

Tags: mdx, subselect

 

2007-2015 VidasSoft Systems Inc.