Performance issue with topcount

#1

Hello All,

I need to find out top 20 partner, so I created following named set:

topcount([Partners].[CBN].Members, 20, [Measures].[Rate of failure])

My problem is it takes to much time (0.5 - 1 Hour) to calculate the data.

The table Partners contains less then 9000 records and the fact table is
about 280000 records.

Any ideas how I can increase performance?

Thanks and best regards,
Andrej

#2

do you use AS2000 or AS2005?

have you defined the non empty behavior for the Rate of failure measure? (if
its a calculated measure)

"Andrei Litovka" <AndreiLitovka (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello All,

I need to find out top 20 partner, so I created following named set:

topcount([Partners].[CBN].Members, 20, [Measures].[Rate of failure])

My problem is it takes to much time (0.5 - 1 Hour) to calculate the data.

The table Partners contains less then 9000 records and the fact table is
about 280000 records.

Any ideas how I can increase performance?

Thanks and best regards,
Andrej

#3

Hi JÃ©jÃ©,

I use AS2000. I didn't define a non empty behavior, but Rate of failure is
rather never empty.

Regards.
Andrej

"JÃ©jÃ©" wrote:

Quote:

do you use AS2000 or AS2005?

have you defined the non empty behavior for the Rate of failure measure? (if
its a calculated measure)

"Andrei Litovka" <AndreiLitovka (AT) discussions (DOT) microsoft.com> wrote in message
news:B362CDBD-0CE2-4665-9EC0-03AC39CA61C9 (AT) microsoft (DOT) com...
Hello All,

I need to find out top 20 partner, so I created following named set:

topcount([Partners].[CBN].Members, 20, [Measures].[Rate of failure])

My problem is it takes to much time (0.5 - 1 Hour) to calculate the data.

The table Partners contains less then 9000 records and the fact table is
about 280000 records.

Any ideas how I can increase performance?

Thanks and best regards,
Andrej

#4

Hi,

Is the [Rate of failure] a calculated measure? What is it's formula?
What a box do you have?

Vladimir Chtepa

"Andrei Litovka" <AndreiLitovka (AT) discussions (DOT) microsoft.com> schrieb im
Newsbeitrag news:5BDD4D10-347A-4EA0-99D0-4A5C205B5BD4 (AT) microsoft (DOT) com...

Quote:

Hi Jéjé,

I use AS2000. I didn't define a non empty behavior, but Rate of failure is
rather never empty.

Regards.
Andrej

"Jéjé" wrote:

do you use AS2000 or AS2005?

have you defined the non empty behavior for the Rate of failure measure?
(if
its a calculated measure)

"Andrei Litovka" <AndreiLitovka (AT) discussions (DOT) microsoft.com> wrote in
message
news:B362CDBD-0CE2-4665-9EC0-03AC39CA61C9 (AT) microsoft (DOT) com...
Hello All,

I need to find out top 20 partner, so I created following named set:

topcount([Partners].[CBN].Members, 20, [Measures].[Rate of failure])

My problem is it takes to much time (0.5 - 1 Hour) to calculate the
data.

The table Partners contains less then 9000 records and the fact table
is
about 280000 records.

Any ideas how I can increase performance?

Thanks and best regards,
Andrej

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

Performance issue with topcount

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

Performance issue with topcount - 07-17-2006 , 11:02 AM

Re: Performance issue with topcount - 07-17-2006 , 05:48 PM

Re: Performance issue with topcount - 07-18-2006 , 01:35 AM

Re: Performance issue with topcount - 07-18-2006 , 02:39 AM