Estimated Count or Partition Count must be specified for cube objects that require counting...

While creating an aggregation design for a partition in SSAS Cube using SQL Server Management Studio, below error was thrown while trying to get the Estimated Count and Partition Count.

Estimated Count or Partition Count must be specified for cube objects that require counting.

The issue was for some dimension, there is no Estimated Count and those were highlighted in Red color line. Just provide the value for those and it will fix this issue.

No comments:

Post a Comment

How the transformed data is written to an output file with column headers in U-SQL...

While working with U-SQL language, I noticed that there are few ways of writing data to an output file. Let's assume the SalesDetails....