I am building a cube which as 10 dimensions and all these are shared
dimensions that have been processed. The fact table data for the above
cube as about 40000 records when I do processing of the cube I have
set the fact table size as 45000 despite it while processing analysis
services appears to be just counting more than 3 million rows not sure
where it is getting this count from. The count(*) on the fact tables
is only 41000 records when I have only about 3 dimensions in this cube
the processing and the count during the processing of the count
finishes in less than 45000 records when I add more than 3 dimensions
the count while processing is going to more than 4 million records.

This is the first time this weird problem is happening in the past I
have build cubes from fact tables that are about 3.5 to 4 million
records and set the fact table size to the same and the processing did
not go past that now not sure why it keeps going forever.

ANy help is highly appreciated.

Thanks
Belinda

It sounds like a cartesian product between the fact table and a dimension
table. Are you sure joins are properly defined between all tables? What is
the SQL statement AS is using?

"Belinda" <belindacur (AT) yahoo (DOT) com> wrote