THE SQL Server Blog Spot on the Web

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

Greg Low (The Bit Bucket: 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 6, 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



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

Rajasekhar said:

thanks for the help.

July 16, 2013 4:59 AM

Gurberly said:

Thanks too...

August 22, 2013 4:52 AM

Alex Lam said:

Thanks for the help.  Resolved this issue by manually change the red squiggles' "Estimated Count" from 0 to a number.

August 30, 2013 4:03 AM

OM said:

Thanks! It was helpful!

May 21, 2014 3:37 PM

Neeraja said:

It helped me tremendously. Thank you

August 29, 2014 3:23 PM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement