Issues with rehomed data in the parent entity level in Data Availability Reports

Symptoms

If the parent entity level has rehomed data in the parent daily Data Availability Report, then the instance counts in child entity level are displayed incorrectly.

Resolving the problem

To work around this issue, follow these steps:

Open the parent daily Data Availability Report in Report Studio. For example, NOKIA_GSM_FAbis_BSC_DDA report that has rehomed data at the parent entity level.
Click Query Explorer, and then select Query1.
Right-click a filter in the Detail Filters, copy, and paste the filter two more times.

For each new filter, modify the filters as follows:

Filter 1

[Consolidation Views].<Entity>.[TIMESTAMP] < [Consolidation Views].[TIMES].[DATE_KEY_DAY]

For example, if the rehomed parent is Cell in the Data Availability Report, the filter must be modified as follows:

[Consolidation Views].[Cell].[TIMESTAMP] < [Consolidation Views].[TIMES].[DATE_KEY_DAY]

Filter 2

[Consolidation Views].<Entity>.[ENDSTAMP] > [Consolidation Views].[TIMES].[DATE_KEY_DAY]

For example, if the rehomed parent is Cell in the Data Availability Report, the filter must be modified as follows:

[Consolidation Views].[Cell].[ENDSTAMP] > [Consolidation Views].[TIMES].[DATE_KEY_DAY]

Save the report template and run the parent Daily Data Availability Report.

Parent topic: Troubleshooting Tivoli Netcool Performance Manager - Application Studio and Common reporting