Re: dimensions and cube aggregs

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 14:44:22 -0500

You might consider looking at the Analysis Services Performance Guide.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx
It discusses all of your alternatives in a tremendous amount of detail and
with examples. 

-- 
Dave Wickert [MS]
dwickert@online.microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"PCH" <pch12@hotmail.com> wrote in message
news:eMVYp3K$DHA.2664@TK2MSFTNGP09.phx.gbl...
> I'm trying to simplify my cube processing system.
>
> I have 8 dimensions that are needed for various queries.  5 are
> shared/static, and 3 are private that must process daily.
>
> I am trying to use them all in 1 cube, instead of 4-6 cubes.
>
> The problem is the aggregations get a bit out of hand even at 20%.
>
> 4 of the dimensions do not need to relate to each other, and 3 dimensions
> form the base of the cube (time, customer, etc etc)
>
> Is there a way to force what combination the aggregations will use?
Perhaps
> using the Usage-Based_Optimization?  Ie dont aggregate dimension A to
> dimension B..
>
> Thanks.
>
>
>

Relevant Pages

  • Re: Aggregations/performance
    ... If you get good performance out of your cube, ... The first point is that you can certainly have aggregations with a changing ... As a worst-case, even if you have several changing dimensions, this ...
    (microsoft.public.sqlserver.olap)
  • Re: #ERR when trying to view detail of time dimension
    ... Is there any reason you are using HOLAP vs. MOLAP? ... As for the freezing portion - how many aggregations are you creating? ... with a MOLAP cube you can typically just build it at 5-25% without ... >>> all new dimensions. ...
    (microsoft.public.sqlserver.olap)
  • Analysis Services Query Log Inconsistency
    ... Analysis Services 2000 allows up to 128 dimensions per cube; ... level in each dimension a particular query uses. ...
    (microsoft.public.sqlserver.olap)
  • Re: Fairly Large Cube-Performance Improvement recommendations
    ... With a high complexity cube, the total number of possible aggregates grows ... For the little used dimensions, ... dimension from consideration and means that all aggregations that will be ... run the design wizard for a low percentage so you have some aggs design, ...
    (microsoft.public.sqlserver.olap)
  • Re: Can someone suggest me how do you define a big cube..
    ... if you have a DCount aggregated measure, you must store it in a dedicated cube to make sure the performance was good enough. ... to improve the performance insure that your hierarchies in the dimensions are setup with the uniquekeys option. ... Does your queries hit your aggregated content? ... and how big are your aggregations and MOLAP storage on these disks? ...
    (microsoft.public.sqlserver.olap)
Loading