How do I manually rebuild the OLAP cubes for Analysis Center? (NETIQKB50137)

  • 7750137
  • 02-Feb-2007
  • 02-Jun-2011

Environment

NetIQ Analysis Center 2.x

Situation

How do I manually rebuild the OLAP cubes for Analysis Center?

Resolution

If cubes do not appear in SQL Analysis Manager, you can manually recreate the required cubes for Analysis Center.  However, the process could require an extended amount of time depending upon the size of your Analysis Center Data Marts or the amount of data in your AppManager repository.

In the instances of SQL Analysis Services Enterprise edition, you may only need to rebuild a partition.  If you have multiple partitions and only need to rebuild  one, contact NetIQ Techincal Support and reference: NETIQKB55484.

For Analysis Center greater than 2.0 and SQL AS Enterprise edition, please refer to NETIQKB48192

Please contact NetIQ Technical Support and reference this KB Article for more information about the required process. 

Additional Information

Formerly known as NETIQKB50137

Cube creation and the related partitions could take several failed iterations of the OLAP Processing job to complete. You may have to manually run the OLAP Processing job several times for all the cubes to be created before the OLAP Processing job will complete without intervention.