Hi:

I have a cube with multiple partitions. Can I get topn count amoung multiple
partitions (say: partition 2, 3 and 7) in one shot using MDX?

Thanks for your help.

can we query selected partitions of a cube. For example, if a cube has 10
partitions, can I make a single query for partition 2,4,6 and 8?

Thanks for your thoughts

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Could you elaborate more on why you would want to do this?


Thanks,

Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote

You can get totals for any combinations of months - no need for the client
to know or care about the partitions. In MDX you create a calculated member
that aggregates the set of these months. The MDX would look something like:

WITH MEMBER Time.SomeMonths as 'Aggregate(Time.January, Time.June,
Time.October)'
SELECT {Time.SomeMonths} on 0,
<whatever your interested in> on 1
FROM <somecube>

-Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote

Hi:

I store 12 months of sales on 12 partitions. I like to be able to get totals
from any combinations of months, not only total from 12 month.

May be I should use a virtual cube contains 12 cubes in this case?

Thanks


Sean Boon [MS] <seanboon (AT) online (DOT) microsoft.com> wrote