Slow performance on Custom Rollup Formula

#1

I have a cube with a measure that indicates a maximum capacity. It can be
summarized along all the dimensions, except for the time dimension, on which
it should be aggregated by taking the maximum value. To get this done, I've
used a custom rollup formula, something like
MAX( time.currentlevel.children ).
The performance of the cube after processing is very poor, in fact, I havent
even been able to check if this produces the right results for me. I've
tested performance with the 'browse data' function in the MAS Enterprise
manager.
The cube has 3 other dimensions that are rolled up by sum (plain rollup).

Is there something wrong with my custom rollup formula, or is the bad
performance what I should expect.?

#2

Care to post the formula?

tom @ the domain below
www.tomchester.net

"Tjibbe Chris Kuipers" <asdf@a.c> wrote

Quote:

I have a cube with a measure that indicates a maximum capacity. It can be
summarized along all the dimensions, except for the time dimension, on
which
it should be aggregated by taking the maximum value. To get this done,
I've
used a custom rollup formula, something like
MAX( time.currentlevel.children ).
The performance of the cube after processing is very poor, in fact, I
havent
even been able to check if this produces the right results for me. I've
tested performance with the 'browse data' function in the MAS Enterprise
manager.
The cube has 3 other dimensions that are rolled up by sum (plain rollup).

Is there something wrong with my custom rollup formula, or is the bad
performance what I should expect.?

#3

"Tjibbe Chris Kuipers" <asdf@a.c> wrote

Quote:

I have a cube with a measure that indicates a maximum capacity. It can be
summarized along all the dimensions, except for the time dimension, on
which
it should be aggregated by taking the maximum value. To get this done,
I've
used a custom rollup formula, something like
MAX( time.currentlevel.children ).
The performance of the cube after processing is very poor, in fact, I
havent
even been able to check if this produces the right results for me. I've
tested performance with the 'browse data' function in the MAS Enterprise
manager.
The cube has 3 other dimensions that are rolled up by sum (plain rollup).

Is there something wrong with my custom rollup formula, or is the bad
performance what I should expect.?

How many levels Time dimension has ? You might be better of by defining cell
calculation with scope on all levels of Time dimension except the last one
with the expression of

MDX(Descendands(Time.CurrentMember, Time.LastLevelOfTimeLikeDays))

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#4

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Quote:

"Tjibbe Chris Kuipers" <asdf@a.c> wrote in message
news:3f847393$0$58698$e4fe514c (AT) news (DOT) xs4all.nl...
I have a cube with a measure that indicates a maximum capacity. It can be
summarized along all the dimensions, except for the time dimension, on
which
it should be aggregated by taking the maximum value. To get this done,
I've
used a custom rollup formula, something like
MAX( time.currentlevel.children ).
The performance of the cube after processing is very poor, in fact, I
havent
even been able to check if this produces the right results for me. I've
tested performance with the 'browse data' function in the MAS Enterprise
manager.
The cube has 3 other dimensions that are rolled up by sum (plain rollup).

Is there something wrong with my custom rollup formula, or is the bad
performance what I should expect.?

How many levels Time dimension has ? You might be better of by defining cell
calculation with scope on all levels of Time dimension except the last one
with the expression of

MDX(Descendands(Time.CurrentMember, Time.LastLevelOfTimeLikeDays))

In reaction on the previous posts:

- The Custom rollup formula I used was: Max(
datum.currentmember.children )

- The Dimension has 5 levels (Century, Year, Month, Day, Hour) with
569808 members on the hour-level

- How/Where would I define cell calculation?

#5

Quote:

- How/Where would I define cell calculation?

Cell calculations can be defined in the Cube Editor. This feature is enabled
only in Enterprise Edition.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Slow performance on Custom Rollup Formula

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Slow performance on Custom Rollup Formula - 10-08-2003 , 03:31 PM

Re: Slow performance on Custom Rollup Formula - 10-08-2003 , 03:51 PM

Re: Slow performance on Custom Rollup Formula - 10-08-2003 , 05:24 PM

Re: Slow performance on Custom Rollup Formula - 10-09-2003 , 02:07 AM

Re: Slow performance on Custom Rollup Formula - 10-09-2003 , 12:14 PM