Chris hacks away at a slow performing MDX query... by creating a new fact table view.
The query now runs in, wait for it, in 7 seconds on a cold cache in SQLMS and if you look in Profiler you'll see that in fact the majority of that time is taken up by SQLMS rendering the resultset - it takes just over 2.5 seconds to actually run on the server.
Chris Webb's BI Blog: Using Non_Empty_Behavior With YTD calculations
No comments:
Post a Comment