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

tablename_WriteToDataDestination: Mashup Exception Data Source Error Couldn't refresh the entity...

 Once a Dataflow is created and published on Fabric, got the below error while refreshing the Dataflow. tablename_ WriteToDataDestination: M...