Report Portal

Optimizing Arbitrary Shaped Sets

I'm working on optimizing a fairly large cube (2.5 TB) with some 25 billion rows in the fact table. The customer was complaining about long-running queries. Most queries would specify a time range that was passed to the query filter. For example, if the user wants to see the aggregated data from May 25th 20:00 to June 2nd 19:00, the query WHERE clause would like this:

Read more...

Tags: mdx, performance

 

2007-2015 VidasSoft Systems Inc.