Cubes fact table as 85000 rows but processing reads millions of records

#1

I have a fact table of 85000 records and about 5 dimensions. Only one
with 800 members a customer dimension. When I process the cube it first
reads the 85000 records from the fact table and then the number READ
rows keeps increasing to like 18 or 20 million records as having read.

I do not have a clue where Analysis services is finding this many
alarming number of rows. Appreciate how I can eliminate this kind of
weird reads.

Thanks
Karen

#2

It sounds like it's trying to fill in holes in data. Your data rows are
probably a multiple of the possible combinations of your dimensions.

--
Cheers,

'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com

"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote

Quote:

I have a fact table of 85000 records and about 5 dimensions. Only one
with 800 members a customer dimension. When I process the cube it first
reads the 85000 records from the fact table and then the number READ
rows keeps increasing to like 18 or 20 million records as having read.

I do not have a clue where Analysis services is finding this many
alarming number of rows. Appreciate how I can eliminate this kind of
weird reads.

Thanks
Karen

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

Cubes fact table as 85000 rows but processing reads millions of records

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Cubes fact table as 85000 rows but processing reads millions of records - 11-14-2005 , 06:20 AM

Re: Cubes fact table as 85000 rows but processing reads millions of records - 11-14-2005 , 11:34 AM