Post reply

Analysis Services 2005 Cannot Create Aggregation > 0%

  • November 22, 2006 at 8:03 pm

    #117811

    Dear Guru,

    I was experianced some weird things in Analysis Services 2005 (with SP1). My cube structure:

     

    3 measures in measure group

    5 calculated measures

    3 time dimension

    more than 10 flat dimension (dim with no hierarchy)

     

    When I tried to design an aggregation using the wizard, I always got 0% aggregation, even thought I choose 100%. 

    FYI, the same wizard working fine with the others cube.

     

    What's wrong?

     

    Thanks

    Hendra

     

  • November 28, 2006 at 12:16 pm

    #674483

    I'm not sure what's going wrong (or right ) with your aggregations but I would hazard a guess that it's related to the aggregation candidates.  For a pretty good overview of what this means and how to influence it, look at Liz Vitt's blog entry here.

    Cheers,

     

    Steve.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply