aggregates design and consumption of resources

From: TinaWina (TinaWina_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Mon, 20 Dec 2004 23:13:03 -0800

Hi.
I'm new to cubes. i'm working on BI 2005. i am facing some problems and i
would be very thankful if someone could help me.
first problem with aggregates.
I have 4 dimensions of which one of them is a time dimension. After
processing the cube the totals are either sum or count or first/last child as
can be defined in the Cube builder tab. however i want the totals to reflect
a calculation that i do myself. and the calculation differs depending on the
dimension. and i tried in the Calculations tab to create measure using
MDX.but i can't find how they r applied.
any one can help please?

Second problem is that after processing the cube and while trying to view
the data, the server is freezing. it is consuming a lot of resources. i have
pentium 4 2.4 Ghz, 1 gb ram windows 2000 pro. i am using views as dimesions.
could that be the problem? what are the specifications for a server for cubes
and .net?

thanks
tina

Relevant Pages

  • Re: Performance - Best Practices
    ... SP1 is applied on the server. ... I have also heard that parent child dimensions have a significant impact on ... I mean floating calculation and integer ... and the cube in front of this fact provide standard SUMS and DCount!) ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance - Best Practices
    ... with hyperthreading with SQL Server. ... Hyperthreading is good when you run different applications which use ... I mean floating calculation and integer ... I am having some pretty major performance issues with a cube I've ...
    (microsoft.public.sqlserver.olap)
  • Re: Sudden drop in speed after adding some records. Why?
    ... maybe your biggest dimension is too large for your server memory. ... > play with the cube, and see the results with the usage analysis. ... > Try to play with the client connection string to insure you use server ...
    (microsoft.public.sqlserver.olap)
  • Re: Filtering a dimension based on value from another cube?
    ... creating a new dimension called "Targeted population". ... Employees with more then XX absences in the month ... calculated cells formula can apply the MDX formula in the cube. ... then the standard calculation is applied. ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance Benchmarks?
    ... adding memory on the server can help you; more data can be cached on the ... Here is my test query. ... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)