Analyze BR Report

Explanation

This activity is used to analyze an executed IFS Business Reporter (BR) report.

You can use Zoom In and Drill Down features to analyze the report. With these features, it is possible to analyze information in IFS Applications directly from the report. This will give you more information about the underlying data related to a resulting information in a report. Zoom In will perform a detailed breakdown within the same data source. Drill Down will perform a detailed breakdown from related data sources.

Any non-BR output that should be saved with the report can be placed on a non-BR sheet during the report analysis.

Dataset Information

Report Mode provides Debug options, where one option can be used to display datasets created during execution and also the execution time for each dataset. This option is useful when analyzing performance issues in a report, providing the possibility to find the datasets in a report that consumes most of the total execution time. Please refer to Prerequisites.

Prerequisites

In order to analyze a report, an executed Business Reporter report must be available.

If you want to zoom-in or drill-down a report, then these options should have been enabled in the report design.

To enter non-BR content to be saved as a part of the BR report, a non-BR sheet should be defined when designing the report.

Dataset Information

In order to analyze the execution time for each dataset in the executed report, it is necessary that the Debug option Display Dataset Information before Executing has been selected in the design mode in Report Options located in IFS Business Reporter ribbon.

System Effects

N/A

Related Process Model

View and Analyze BR Report
Order BR Report
Execute BR Report

Related Activity

View BR Report

Procedure

To analyze a report using Zoom In:

  1. Select a cell in the executed report.
  2. Right-click and select the option Zoom In to view zoomed-in information. A new worksheet in Microsoft Excel will open to display the zoom-in information.

To analyze a report using Drill Down:

  1. Select a cell in the executed report.
  2. Right-click and select the option Drill Down to view drilled down information.  A new worksheet in Microsoft Excel will open to display the drill-down information.
  3. Select a row in the excel sheet which opened.
  4. Right-click and select one of the two URL options available. This will take you to the relevant window in IFS Applications.

Note: If the system parameters relating to the URL options have not been setup in IFS Solution Manager, it will result in an error. In such an instance, contact the system administrator.

To enter notes, comments and any other non-BR content:

  1. In the exeuted report,open the relevant non-BR sheet.
  2. Enter the required notes, comments, diagrams or text reports based on the report analysis that you want to save with the report.
  3. Enter the required pivot tables/charts in the non-BR sheet and refer to data from the ordinary BR sheets.

Note: If the Auto-Refreshing Enabled for Excel Pivot check box is selected for the non-BR sheet, the pivot table/chart will get updated with latest data from the subsequent BR report executions.

To display dataset created before execution, to analyze execution time and check the datasets created in the report:

  1. In the Document Actions pane, click on Debug.
  2. If Data Set Information option was enabled in Design Mode there will be two tabs available, the Activity Log tab showing execution time and details for the different activities and the Data Set Info tab showing information about created data sets and how they have been grouped.
  3. If the Display Dataset Info Before Executing option was enabled in Design Mode, the button Dataset Info will be enabled and clicking on it will show all server data sets and the execution time for each set and also the client data sets that correspond to each server data set.