Refresh Instance Overview

This section describes the fields and descriptions on the Refresh Instance Overview report.

Overview

The Refresh Instance Overview report enables you to monitor which reports have been actively accessed within a selected time period.

The report is specifically designed for Business Objects (BO), built on objects from the SAP universe. It helps track report usage patterns and frequency of refreshes, which are crucial for ensuring that active reports are regularly updated. The Development and Quality Engineering (QE) teams can prioritize reports with higher user engagement for performance optimizations, improvements and testing efforts.

Report Workspace

Navigation

To open the report workspace, go to Reporting » BI Launch Pad and click Open BI Launch Pad. The report is located on the Audit Analysis folder.

Selection Criteria

Note: Pre-defined filters are set to include only "Web Intelligence" report types, exclude reports containing "do_not_use." and event type include only "Refresh".
Prompt Title Expression Mandatory
Events Started After Only include figures from this event date after the answer to this prompt. No
Events Started Before Only include figures from this event date before the answer to this prompt. No

Generate the Report

To generate the report:

  1. Go to Auditing Analysis » Refresh Instance Overview.
  2. Enter the selection criteria for running the report.
  3. Click Run. The screen refreshes and displays the generated report.

    To keep a copy, click the Download icon. In the dialog box, specify the parameters for the export file (file type, reports and options), then click Export.

Report Description

Universes

The report is based on the following universe(s):

  • SAP universe

Export Fields and Descriptions

The report includes filters to narrow down the time frame for the refresh activity, as well as specific filters for report types and paths to ensure accurate data retrieval.

The report is structured as a cross-tab table, where the Year serves as the primary header and the Month as the subheader, displaying the refresh activity by month within each year. This format allows administrators to easily track report refreshes over time and identify trends in usage, helping to prioritize reports for performance improvements and testing.

The report document is to contain just one report tab named Refresh Instance Overview.

Header Title Sub-header Description
Event Date This displays the date when the current report was generated.
Report Name This column displays the name of reports that have been refreshed within the selected period.

These headers are hardcoded.

Report Path This column displays the path where the report is located.
Date First Run This column displays the date when the report was first refreshed during the selected period.
Last Run This column displays the date when the report was last refreshed during the selected period.
Year Month This column organizes the data by year, with each month listed as a sub-header under the corresponding year.
Total Refresh Instances This column displays the total number of times the report has been refreshed during the selected period.
Note: You can show/hide the Year/Month column by clicking the Toggle icon.

Limitations

None reported.

Admin Setup

Maconomy Setup

Not applicable for this report.

External Setup

Enable Folder Path Details

To view and filter the folders for the report:

  1. Log into SAP Business Objects.
  2. On the Central Management Console (CMC), select Auditing from the drop-down list.
  3. In the Set Event Details section, enable Folder Path Details.
    Note: You can also enable Property Value Detals to know whether a report is existing or not.

Flush Database

You can reset the values on the database so the refresh count starts from zero.

By default, the counter resets to zero after a year.

Note: The steps below affects all reports.
  1. Log into SAP Business Objects.
  2. On the Central Management Console (CMC), select Applications from the drop-down list.
  3. Select BI Admin » Monitoring Properties.
  4. In the Trending Database Settings section, enable and enter a value in the Delete all history older than [numerical value] of Days checkbox.