Re: how to use partitions once created?
- From: "Akshai Mirchandani [MS]" <akshaim@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Jan 2006 09:07:34 -0800
Partitions are physical objects -- they allow better management of the data
in a cube and in some ways improve performance. But you don't (and can't)
query them directly -- the cube is the object that you care about.
The "better management and performance" include:
- creating rolling partitions so that old partitions don't need to be
re-processed and new data can be incrementally added into the "current"
partition
- specifying slices on partitions so that partitions outside the slice in
the query don't need to scanned
- etc.
Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Rich" <Rich@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D8600CDE-4B62-4D37-BCA8-8C733EC5340A@xxxxxxxxxxxxxxxx
> Hello,
>
> I have a data warehouse/datamart database (please correct me what the
> correct name is for the database containing the cubes) containing 2 cubes
> called "Dividends" and "Investments". I created 3 partitions in the
> "Investments" cube. I understand that partitions are a way to group data
> in
> a cube that is getting large. My question is how is a partition used once
> created (and processed and so forth)? the "Investments" cube has 2
> partitions "Conneticut", "Vermont".
>
> I opened up the MDX application and can only see the 2 cubes in this
> database for querying. Is it possible to query either of the partitions
> "Conneticut" or "Vermont"?
>
> Any explanations appreciated on the usage/purpose of cube partitions.
>
> Thanks,
> Rich
>
>
.
- Follow-Ups:
- Re: how to use partitions once created?
- From: Rich
- Re: how to use partitions once created?
- Prev by Date: problem with periodstodate()
- Next by Date: Re: No Access after creating Subcube, reprocessing and dropping Subcub
- Previous by thread: problem with periodstodate()
- Next by thread: Re: how to use partitions once created?
- Index(es):
Relevant Pages
|
Loading
