Re: how to use partitions once created?
- From: "Rich" <Rich@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Jan 2006 13:19:02 -0800
Thank you for your reply to my question. May I ask, how do you specify a
slice ona partition? For example, my cube is called "Investments". One of
the partitions is called "Conneticut"
SELECT
{[Measures].[Amount],[Measures].[Sh Num]} ON COLUMNS,
{Crossjoin([Fund].[Fund Name].Members, [Account].[State Abbr].Members )}
ON ROWS
FROM [Investments]
--Where
This query yields something like (without any where clause):
Amount Sh Num
20th-Century Select CA $30,000.00 1,111.10
CT $38,000.00 1,421.62
FL
Acorn International CA
CT $245,841.30
FL
I tried adding something to the Where Clause
Where [Account].[State Abbr].CT
but got this error message "Unable to open cellset
Formula error - duplicate dimensions across (independent) axes - when
calculating a query axis"
Well, even though this is probably not a partition slice, how could I get
this slice to work?
Thanks,
Rich
"Akshai Mirchandani [MS]" wrote:
> 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: Akshai Mirchandani [MS]
- Re: how to use partitions once created?
- References:
- Re: how to use partitions once created?
- From: Akshai Mirchandani [MS]
- Re: how to use partitions once created?
- Prev by Date: Re: is this type of query possible in MDX???
- Next by Date: AS2005: How to Link a dimension against a linked cube?
- Previous by thread: Re: how to use partitions once created?
- Next by thread: Re: how to use partitions once created?
- Index(es):
Relevant Pages
|
