Re: 0 Aggregations designed

Tech-Archive recommends: Speed Up your PC by fixing your registry

Fazal,
try replacing AggUsage to Unrestiricted.

Ramunas


"Fazal" <Fazal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D06A3B80-C338-4BCB-957D-7145A702C10D@xxxxxxxxxxxxxxxx
Hello,
I have designed cube in AS 2005. I have set AggregationUsuage Property to
FULL for most of the attributes that the users will query most. When I try
to
design the aggregations, it does not create any (It gives me message that
0
aggregation desgined). If I change the AggregationUsage proeprty back to
"Default" then it only calculates 140 aggregations with 24% performance
even
though it is set for 100% performance gain. Can anyone please help me what
else do I need to change inorder to improve the cube perfromance. I have
close to 9million records in my Fact table and about 30 dimensions.


.