[fix]-Cannot build cube

Wikitechy | 918 Views | sql server | 08 Jun 2016

 

Scenario:

As per requirement performed changes in the dimensions of a cube and on code re-build the error occurs. 


Error:

Can't build cube because of broken aggregations

Reason for the error:

The dimensions are missing in the aggregations for current cube changes. 

Fix:

Add the missing dimensions in the aggregation and perform a code rebuild. Follow the below steps to perform the same:

1. Go to the Design Aggregations tool. 

2. Stop after building an aggregation. 

3. Now proceed with removing the dimensions that are not needed anymore.

4. Perform the aggregations rebuild to fix the issue.

Related Tags:

  • Avoid Common SQL Server Analysis Services Problems 
  • ssas Aggregation design wizard
  • The Impact of Aggregate
  • SAS OLAP Cube: 3 Tips to Increase Performance
  • sql server - SSAS cube process time increased after making fact 
  • How do aggregations work in SSAS? 
  • ssas cube design cannot build.



Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise