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-09-02 : 10:38:48
|
| I have 8 month partitions in a measure group and when I query the cube to list the last 20 days only the needed partitions are read; however, if I increase the number of days to about 25, then all of the partitions are read. It does not matter if the number of last days span one or two months - the results is the same. This makes the MDX query run about 20 times slower.Is there anything that can be done to force the MDX to only read the needed partitions?Bill |
|
|
|
|
|
MDX Reading Multiple Partitions