IT Analytics Cube for NS are Not Processing
search cancel

IT Analytics Cube for NS are Not Processing


Article ID: 171927


Updated On:


IT Analytics


After working for a certain period of time, the automatic processing job configured on the SMP stopped working.  When manually processing the cubes on the SQL Analysis server, it was noticed that some dimensions for the Tasks cube were not processing. Dimension [Task] cannot be saved


7.6 ITA


The data set used to generate the Task dimension had grown to be larger than 4GB.  


The workaround for this is to remove the Task cube from Processing.

To resolve the issue, the SQL server version must be a Enterprise Version, or a Data Center version, and the dimension must have its StringStorecompatibilityLevel property set to 1100.  See for instructions on how to do this.

This cannot be changed on a SQL Server Standard version.