This executes in 2 seconds on a cold cache on my laptop, compared to 52 seconds for the equivalent query which evaluates the TopPercent for every single cell, so it's definitely a big improvement
Source: Advanced Ranking and Dynamically-Generated Named Sets in MDX - FindTech Blogs
No comments:
Post a Comment