Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
willcall
Starting Member
2 Posts |
 Posted - 2009-10-02 : 02:54:55
|
| I have a cube that has about 9 months worth of data loaded. The cube is comprised of 10 monthly partitions. When I run SQL Profiler to trace SSAS and run a query to get the last 20 days, Profiler shows that only the partition(s) that hold the last 20 days are read to process the MDX query. However, when I change the MDX to query the last 30 days SQL Profiler shows that all the cube partitions are read and the query takes about 20 times longer to complete.Is there any way to force the query to read on the partitions that will satisfy the query instead of all of them?Thanks, BillBill |
|
|
|
|
|
Date dimension does not slice partition correctly