0 aggregations designed - Analysis Services 2005

[dean12]

Sorry if this is a duplicate, I can't seem to search on the tek-tips site any more.

For three days now I've been screwing around trying to figure out why the aggregation design wizard refuses to create any aggregations. Every time I run it it says 0 aggregations designed. The optimization level is zero.

Its MOLAP storage. I've got counts on all the dimensions and in all the hierarchies. It's just got to be something terribly stupid that I'm doing that is preventing aggregations.

Anyone every run across this type of problem?

All SQL ans AS service packs are installed.

 

[MDXer]

never seen this before. What setting are you using to build the aggs?

File limit, precentage or until you click stop?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[dean12]

Tried'm all.

Migrated AS2000 cube builds aggregations. My hand-crafted doesn't. Does that say something for my hand-crafting?

Found lots of notes on the net about folks having this problem. Some people say its a known bug. Others say a careful adjustment of the thousands of attribute settings will fix things up.

Two days of screwing around with this issue. I give up. SQL2005 is like a space shuttle grafted onto a VW bus - why would anyone want that?

 

[MDXer]

You have defined all your Attribute relationships. Your previous post regarding the date dim issues I just saw had a error that refferences the Attribute relationship.

Are you carrying attibutes that are not being used? Attributes in SSAS work a bit differently than Member Properties did in AS 2K. You should only carry the Attributes that are going to be used. any that aren't used should either be removed or set the Attribute Hierarchy to false.

I would open each dimension and see if there are any errors or warning regarding your attribute relationships.

Next Item I would check is the Dimension Usage tab of the cube to make sure that your dimensions are properly referencing your measures.

I personally have never had issue building aggs on my cubes.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[dean12]

I looked for errors on dimensions - they are not hard to spot. Those are all taken care of. As to excess attributes, I think that is taken care of as well and I'm sure the migration wizard creates things that are not needed. Too bad Microsoft chose to be silent on so many things - why isn't there some trace or log file that one could look to and discover what the aggregation wizard thinks is going on?

I guess no choice but to start killing things off till it works or start over one dimension at a time till it fails, the old brute force approach. What a time waster.

 

[MDXer]

Persoanlly I never us the upgrade wizards. In the end you save time and learn more by just rebuilding.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[dean12]

I agree with you on that. Unfortunately, in this case its the only way I can get an operational cube.