Novell Home

My Favorites

Close

Please to see your favorites.

No data is available in Analysis Center reports after applying a product hotfix or service pack (NETIQKB73383)

This document (7773383) is provided subject to the disclaimer at the end of this document.

Situation

No data is available in Analysis Center reports after applying a product hotfix or service pack

Resolution


1. Disable all ETL & Analysis Center OLAP Processing SQL jobs

2. Maually run the 'Create Data Sources Data Marts' for each Data Source to trigger a rebuild of the SSIS packages & ETL SQL processing job, and wait for each to complete successfully

3. Once the ETL jobs have completed, temporarily disable the jobs & ensure they are not currently running.

4. Manually run the 'Analysis Center Installation' SQL job & wait for the OLAP processing job to complete in this step.  NOTE: This could take a significant amount of time to complete depending on the size of the environment & volume of data stored each data mart.

5. Once the OLAP Processing SQL job completes successfully, re-enable all ETL jobs to resume scheduled processing and verify data availability in your Analysis Center reports.

Cause

In certain situations, after installing a hotfix or service pack that requires you to rebuild the Analysis Services AC_OLAP database, the databases may get out of synchronization & will not fully process the data.  Using the steps below will trigger a rebuild & full process of the AC_OLAP databases after which the all the processed data will be available to Analysis Center reports.

Additional Information

Formerly known as NETIQKB73383

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7773383
  • Creation Date:16-FEB-12
  • Modified Date:22-FEB-12
    • NetIQAnalysis Center

Did this document solve your problem? Provide Feedback