THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Analysis Services - Usage Based Optimization - Unhelpful UI

When using the Usage Based Optimization wizard (or the Aggregation Design Wizard), on the screen that asks you to enter counts. There is a button that says "Count" but after using it, you might still be confronted by the message ""Estimated Count or Partition Count must be specified for cube objects that require counting". It's not overly helpful, given you have just asked it to count them itself.

If you see this, look through the list of dimensions and find any that have red squiggles under them. Then open each and find the attributes that also have squiggles and update those counts. Make sure that all squiggles disappear.

You should then be able to continue to the next screen.

Hope this helps someone.

Published Wednesday, July 06, 2011 7:09 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jeremy said:

This helped me.  I have overlooked the red squiggles for a long time now.  Thanks.

July 6, 2011 4:13 PM
 

Paul said:

Thanks for this....

September 7, 2011 11:37 PM
 

Crashn Cor said:

Yes this helped although I am not sure why it couldn't perform the count on those attributes.

April 4, 2012 1:40 PM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement