Analyze Report

Explanation

This activity is used to analyze an executed report. You can use Zoom In and Drill Down features to analyze the report. Any non BA output that should be saved with the BA report can be placed on a non-BA sheet during the report analysis.

Dataset Information

Use this activity to display data sets created during execution and the execution time for each data set created. This activity is also related to Display Datasets before Execution activity description. Please refer to that for more information.

Prerequisites

In order to analyze a report you must have an executed report.

If you want to zoom-in a report then, the report must have been designed using the Zoom-in feature. If you want to drill down a report then, the report must have been designed using the Drill Down feature.

If you want to enter non-BA content that needs to be saved with the BA report, a non-BA sheet should be defined when designing the report.

Dataset Information

In order to analyze the executed time for each data set in the report, you need to select the check box Display Dataset Information before Execution under debug options in the Report Options in designer mode.

System Effects

N/A

Related Process Model

Execute Report
Analyzing Report

Related Activity

Perform Writeback
Disable Sheets during Execution

Procedure

To analyze a report using Zoom In:

1. Right-click and click Zoom In option to view zoomed in information. This information will open up in a new worksheet in Microsoft Excel.

To analyze a report using Drill Down:

1. Right-click and click Drill Down option to view drilled down information. This information will open up in a new worksheet in Microsoft Excel.
2. Select a row in the opened up excel sheet.
3. Right-click and click on the URL option available. This will take you to the relevant window in IFS Applications.

Note: If the system parameters relating to the URL option 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-BA content:

1. Open the relevant non-BA 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-BA sheet by referring to data from the BA sheets.

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

To display data set created and to analyze executed time of each dataset created in the report.

1. Click Debug located in the Document Actions pane in the Report Mode.
2. Now click on the Dataset Info button.
3. In the Data Set Information dialog box you will find information about the data sets sent to the server together with the execution time for each dataset and also the design row reference to each dataset.
4. Click the button in the SQL column to see a simplified version of the used SQL.
   Note :The visualized SQL differs from the more complex SQL that will be generated in the server.