Cannot see information before installation date in Analysis Center (NETIQKB48511)

  • 7748511
  • 02-Feb-2007
  • 27-Jan-2011

Environment

NetIQ Analysis Center 2.x

Situation

Cannot see information before installation date in Analysis Center
Cannot pull up data that was taken prior to when I installed.
Historical data is missing.

Resolution

To verify that the filter is set correctly and then process the partition:

  1. In SQL Analysis Manager, navigate to the applicable cube partitions
  2. Right-click the partition  for the month that is missing data and select Edit.  If the missing data is from reports that have the "UTC" check box selected, then go to the appropriate partition for the AMGeneric#UTC cube.  If the missing data is from reports that don't have the "UTC" check box selected, then go to the appropriate partition for the AMGeneric# cube
  3. Click Next on each windows until you reach the last window titled Finish the Partition Wizard
  4. In the Finish the Partition Wizard window, click Advanced to display the filter.  If the filter does not  show something like "vFact.idLoad <= # and vFact1.idUTCDateTime between # and #,  then copy the filter statement in the text box and send to Technical Support for evaluation.  Do not perform the remaining steps until you hear back from Technical Support.

    example:             vFact1.idLoad <= 5424
  5. If the filter is as expected, then "CANCEL" the Advanced Settings window and "CANCEL" the Partition Wizard
  6. In SQL Enterprise Manager, navigate to the Management > SQL Server Agent > Jobs
  7. Disable the OLAP Processing job
  8. Once the job has been disabled, process the cube partition in SQL Analysis Manager by right-clicking the partition for the month missing data and selecting Process
  9. After the cube partition has successfully completed processing re-enable the OLAP Processing Job

If this process does not allow the Cube Porcessing (OLAP Processing Job) to complete, contact NetIQ Technical Support and reference this article.

Cause

The ETL job executions were not processed in the OLAP database. If data exists in the Data Mart, you should be able to fully process the AMGeneric1 and AMGeneric1UTC cubes manually to get the data into the cubes for reporting.  However, you must verify the filter for the cube partition is set correctly.

Additional Information

Formerly known as NETIQKB48511