Sunday, March 11, 2012

Aggregation Design Wizard hangs after Count

After clicking the Count button in this wizard, the counts are entered, but the Next button remains greyed out. This started to happen recently on a small development database. Not sure what development changes caused the wizard to stop working. The wizard still works fine on an AdventureWorks database on the same instance of AS2005.

Any comments/advice appreciated.

Thank you

Aggregation Design Wizard needs to obtain estimated counts of members in a dimensions. For that it will try to connect to relational database and issue query to obtain counts.

If database is not available or it takes long time for it to return counts, you might see delays. You can manually enter EstimatedCount value for your dimension attributes, in this case Aggregation Design Wizard will have information needed to proceed.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.|||

Edward

Thanks for your prompt response. It turns out that it wasn't entering a count for attributes with hierarchies that I had disabled (listed unbolded in the Count dialog with the Partition coulum count cell greyed out). After I overtyped the zero with a number in each of these cases I was able to proceed.

Thank you.

No comments:

Post a Comment