Re: How do you limit aggregation to a specific dimension level
- From: "Jéjé" <willgart@xxxxxxxxxxxxxxxxx>
- Date: Tue, 17 Jan 2006 00:25:05 -0500
this option is available on the cube only.
after you have added the dimension in the cube, look at the property of the
dimension
you'll found aggregation informations.
but what you want is to display only the day level.
so you have to hide year and month levels in your cube.
(visible = false)
<anasttin@xxxxxxxxxx> wrote in message
news:1137450655.230042.225450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi Dave,
>
> Really appreciate your help but I couldn't find "Aggregation Usage"
> property anywhere. Do you mean "Custom Rollup"?
>
> A couple of other complexities I may not have mentioned too.. The time
> dimension is a shared dimension and I also have other dimensions that I
> only want to show the data of when a single day is viewed and blanks
> otherwise.
>
> Am I asking for the impossible?
>
> Also, what do you mean by "see BOL"?
>
> Thanks again.
>
>
> Dave Wickert [MSFT] wrote:
>> AS2K: set the Aggregation Usage property on the dimension to be "custom"
>> and
>> then you can go into level-by-level and enable/disable. Or you could set
>> top-only / bottom-only. See BOL. The only issue that you may run into is
>> that because of the 1/3 rule, the aggregation design wizard won't
>> consider
>> all possible aggregates -- only those it considers useful. See the
>> write-up
>> in the beginning sections of the AS Performance Guide on this matter.
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx
>>
>> Or is this AS2K5, in which case, the answers and procedures are very
>> different because AS2K5 is an attribute-based system; not a
>> hierarchy-based
>> system like AS2K.
>>
>> Hope that helps.
>> --
>> Dave Wickert [MSFT]
>> dwickert@xxxxxxxxxxxxxxxxxxxx
>> Program Manager
>> BI Systems Team
>> SQL BI Product Unit (Analysis Services)
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> <anasttin@xxxxxxxxxx> wrote in message
>> news:1137389225.266475.220950@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > Hi all,
>> >
>> > I've created a data cube in Microsoft Analysis Services with a time
>> > dimension so you can select the year, month and day of data to view.
>> >
>> > My problem is that I only want the aggregate data to be visible at day
>> > level.
>> >
>> > Just to clarrify, I am holding the stock on hand values by day in a
>> > cube. Adding this up over more than one day yields incorrect figures
>> > because it's adding up how many lollipops I had yesterday with how many
>> > lollipops I have on hand today.
>> >
>> > What do I do so that it only shows you totals when you drill down to
>> > 'day' view?
>> >
>> > Any help would be much appreciated.
>> >
>> > Thanks guys.
>> >
>> > Tony
>> >
>
.
- References:
- How do you limit aggregation to a specific dimension level
- From: anasttin
- Re: How do you limit aggregation to a specific dimension level
- From: Dave Wickert [MSFT]
- Re: How do you limit aggregation to a specific dimension level
- From: anasttin
- How do you limit aggregation to a specific dimension level
- Prev by Date: Re: AS2000: calculated distinct count measure performance...
- Next by Date: Re: YTD Values
- Previous by thread: Re: How do you limit aggregation to a specific dimension level
- Next by thread: Re: By Account Aggregation Function
- Index(es):
Relevant Pages
|
