Can someone please explain to me, or point me to documentation, how a
query scans partitions of a measure group? It seems to me that all
partitions are being scanned, not just the one that I would expect. I
would expect that if a measure group is partitioned by year and I am
querying on a single year then only one partition would be scanned,
however, this is not what I am seeing. I am seeing all yearly
partitions being scanned.

Thanks

in AS2005 the server is able to optimize the partition access by himself.
if you use ROLAP, you must specify what are the members associated to each
partition.
this is the theory point of view with AS2005 and I have not verified this
integrated optimization.

but to insure that your queries will access the right partition you have to
identify which members are associated to the partition.
for example, associate the 2004 partition to the 2004 year member, then any
query against the 2004 member will be redirected to the 2004 partition.


"BJ" <bjwalton (AT) gmail (DOT) com> wrote