Monitoring the Status of BI Object Requests
Use
You can monitor the status of requests and records for BI objects and view this information for selected BI systems. You can monitor the request status of the following BI objects:
· InfoCubes
· DataStore objects
· Master data
You can display the number of request or records that are not compressed, aggregated, or activated, as well as the technical name of the object, number of erroneous requests or records, and so on. This allows you to identify the objects that are adversely affecting system performance.
Procedure
1. In the Detailed Navigation pane, under Data Load Status, choose BI Object Request Status.
2. On the BI Object Request Status screen, in the BI System Selection area, select a BW System.
3. Check the following iViews for data load requests:
InfoCube Status
You can view the number of requests that are erroneous, not compressed, or not aggregated. This iView is tabular and provides the following information:
Information |
Description |
InfoCube |
Technical name of the InfoCube. |
Time Stamp Lst Load |
Date and time at which the InfoCube was last loaded. The date format is day.month.year hours:minutes:seconds (DD.MM.YEAR HH:MM:SS), for example, 06.10.2006 22:26:34. |
Time Stamp Lst Aggr |
Date and time at which the last aggregate was successfully executed. The date format is day.month.year hours:minutes:seconds (DD.MM.YEAR HH:MM:SS), for example, 06.10.2006 22:26:34. |
Time Stamp Lst Comp |
Date and time at which the last compression was successfully executed. The date format is day.month.year hours:minutes:seconds (DD.MM.YEAR HH:MM:SS), for example, 06.10.2006 22:26:34. |
No.of. Reqs. Not OK |
Number of requests that are erroneous. |
No.of.Reqs.Not Compr. |
Number of requests that are not compressed. |
No.of.Reqs.Not Aggr. |
Number of requests that are not aggregated. |
No.of. Recs. Not OK |
Number of records that are erroneous. |
No.of.Recs.Not Compr. |
Number of records that are not compressed. |
No.of.Recs.Not Aggr. |
Number of records that are not aggregated. |
DataStore Object Status
You can view the number of requests that are erroneous or not activated. This iView is tabular and provides the following information:
Information |
Description |
DataStore Object |
Technical name of the DataStore object. |
No. of Reqs. Not OK |
Number of requests that are erroneous. |
No. of Reqs. Not Activated |
Number of requests that are not activated. |
No.of.Recs.Not OK |
Number of records that are erroneous. |
Time Stamp Lst Load |
Date and time at which the DataStore Object was last loaded. The date format is day.month.year hours:minutes:seconds (DD.MM.YEAR HH:MM:SS), for example, 06.10.2006 22:26:34. |
Master Data Status
You can view the number of requests and records that are erroneous. This iView is tabular and provides the following information:
Information |
Description |
Type |
Icon for BI object
type. For example, |
InfoObject |
Technical name of the InfoObject. |
Time Stamp Lst Load |
Date and time when the master data was last loaded. The date format is day.month.year hours:minutes:seconds (DD.MM.YEAR HH:MM:SS), for example, 06.10.2006 22:26:34. |
No. of Reqs. Not OK |
Number of requests that are erroneous. |
No. of Recs. Not OK |
Number of records that are erroneous. |
Result
You can identify BI objects that are adversely affecting system performance. You use the available report-report interfaces (RRIs) to further analyze these BI objects and ascertain why they are affecting system performance.