Hello,
I have a cube with three partitions. Each partition holds data for the years 2005,2006 and 2007 respectively. In our web application we are creating OWC Pivot Table and putting "date dimension" in the filter area automatically. Altough only "2007-01-01" is included in filter, when we trace the query from profiler we saw that all partitions are read. Is there anyone encountered the same thing?
By the way, storage modes for all partitions are MOLAP.
Nilgun Celikok
Hi Nilgun,
First of all, have you set the Slice property on your partitions? Although in general AS is able to detect what data is in each partition, read the following article for details on when it will and won't work:
http://blogs.msdn.com/sqlcat/archive/2007/03/05/ssas-partition-slicing.aspx
In your case it sounds like it will be quite straightforward to set the slice, and this will also detect whether your partitions hold the data you think they hold (which could be another reason why you're seeing AS scan all partitions).
If you have set the slice, however, you could be running into an issue I've seen before and which I think is fixed in the latest cumulative hotfix build for SP2:
http://support.microsoft.com/kb/936305
Look for the brief description under issue 50000890.
HTH,
Chris
No comments:
Post a Comment