SAP ABAP Instance Slice and Dice Analytics Report

SAP ABAP Instance Slice and Dice Analytics report provides administrators with an overview of the modules and their transactions occurring in a SAP ABAP Instance, for a given period of time in the past. This report supports a granular/focused analysis as well, so that administrators can view only what they want to in the report, exclude statistics that may distract them, isolate bottlenecks to user experience quickly and precisely, and troubleshoot efficiently.

To generate this report, do the following:

Login to eG Reporter.
Follow the menu sequence: REPORTS BY FUNCTION -> Domain-specific Reports -> SAP -> ABAP Instance-> Slice and Dice Analytics.
Figure 1 then appears. In Figure 1, select a criterion for analysis from the Analyze By list box.

Figure 1 : Generating the SAP ABAP Instance Slice and Dice Analytics report
Using this report, you can engage in a time-based user experience analysis on SAP ABAP Instance that is part of a zone/segment/service. Indicate your choice by picking the one of the following options from the Analyze by list.
- Component:If the Component option is chosen from the Analyze by list, then all components of the chosen Component Type will be listed in the Component list box. From this list box, select the components for which the report is to be generated. If the Component list consists of too many components, then viewing all the components and selecting the ones you need for report generation could require endless scrolling. To avoid this, you can click the button next to the Component list. The COMPONENTS pop up window will then appear using which you can view almost all the components in a single interface and select the ones for which the report is to be generated.
- Zone: If the Zone option is chosen from the Analysis by list, then you would be required to select the Zone for which the report is to be generated. In addition, you will also have to indicate whether the report needs to include even those components that are included in the sub-zones of the chosen zone. If this is the case, you will have to set the Include sub-zones flag to Yes.
- Service: Select this option if the components for which a report is to be generated are involved in the delivery of a business service. Then, select a Service.
- Segment: Choose this option if the virtual hosts to be evaluated are part of a segment. Then, pick a Segment for analysis.
Next, select the Component Type for which the report is to be generated.
The Modules list will then be populated with the modules that belong to the chosen Component Type. Select a module of your choice from this list. If the Modules list consists of too many modules, then viewing all the modules and selecting the ones you need for report generation could require endless scrolling. To avoid this, you can click the button next to the Modules list. A MODULES pop up window will then appear using which you can view almost all the modules in a single interface and Select the ones to be included in this report.
The Components list will then be populated with the components that belong to the chosen Component Type. Select a component of your choice from this list. If the Components list consists of too many components, then viewing all the components and selecting the ones you need for report generation could require endless scrolling. To avoid this, you can click the button next to the Components list. A COMPONENTS pop up window will then appear using which you can view almost all the components in a single interface and Select the ones to be included in this report.
Provide a report Timeline. You can either select a fixed timeline such as 1 hour, 2 days, etc., or choose the Any option from the Timeline list, and then provide a From and To date/time for report generation.

Note:

For every user registered with the eG Enterprise system, the administrator can indicate the maximum timeline for which that user can generate a report. Once the maximum timeline is set for a user, then, whenever that user logs into eG Reporter and attempts to generate a report, the Timeline list box in the report page will display options according to the maximum timeline setting of that user. For instance, if a user can generate a report for a maximum period of 3 days only, then 3 days will be the highest option displayed in the Timeline list - i.e., 3 days will be the last option in the fixed Timeline list. Similarly, if the user chooses the Any option from the Timeline list and proceeds to provide a start date and end date for report generation using the From and To specifications, eG Enterprise will first check if the user's Timeline specification conforms to his/her maximum timeline setting. If not, report generation will fail. For instance, for a user who is allowed to generate reports spanning over a maximum period of 3 days only, the difference between the From and To dates should never be over 3 days. If it is, then, upon clicking the Run Report button a message box will appear, prompting the user to change the From and To specification.
In addition to the settings discussed above, this report comes with a set of default specifications. These settings are hidden by default. If you do not want to disturb these default settings, then you can proceed to generate the report by clicking the Run Report button soon after you pick a Measure. However, if you want to view and then alter these settings (if required), click on the icon. The default settings will then appear in the MORE OPTIONS drop down window (see Figure 2). The steps below discuss each of these settings and how they can be customized.

Figure 2 : The default settings for generating the SAP ABAP Instance Slice and Dice Analytics report
If the timeline specified for the report needs to exclude the data collected during the Weekends, then set Exclude weekends to Yes. If not, select No.

Note:

By default, the weekend constitutes Saturday and Sunday. To override this default setting, do the following:
- Edit the eg_report.ini file in the <EG_INSTALL_DIR>\manager\config directory.
- In the [RUM_REPOTRS] section of the file, the EXCLUDE_WEEKEND parameter is set to Saturday, Sunday by default. You can modify this by setting the EXCLUDE_WEEKEND parameter to a comma-separated list of other days of the week - say Friday, Saturday.
- Save the file after making the required changes.
Next, specify the start time and end time for report generation against the Time period field.
In large environments, reports generated using months of data can take a long time to complete. Administrators now have the option of generating reports on-line or in the background. When a report is scheduled for background generation, administrators can proceed with their other monitoring, diagnosis, and reporting tasks, while the eG manager is processing the report. This saves the administrator valuable time. To schedule background processing of a report, select the Background Save - PDF option from the Report Generation list. In this case, a Report Name text box will appear, where you would have to provide the name with which the report is to be saved in the background. To process reports in the foreground, select the Foreground Generation - HTML option from this list.

Note:
- The Report Generation list will appear only if the EnableBackgroundReport flag in the [BACKGROUND_PROCESS] section of the eg_report.ini file (in the [EG_INSTALL_DIR]\manager\config directory) is set to Yes.
- The default selection in the Report Generation list will change according to the Timeline specified for the report. If the Timeline set is greater than or equal to the number of days specified against the MinDurationForReport parameter in the [BACKGROUND_PROCESS] section of the eg_report.ini file, then the default selection in the Report Generation list will be Background. On the other hand, if the Timeline set for the report is lesser than the value of the MinDurationForReport parameter, then the default selection in the Report Generation list will be Foreground. This is because, the MinDurationForReport setting governs when reports are to be processed in the background. By default, this parameter is set to 2 weeks - this indicates that by default, reports with a timeline of 2 weeks and above will be processed in the background.
Click the Done button if any changes were made to the More Options drop down window.
Finally, click the Run Report button to generate the report.
If the Report type is Foreground Generation - HTML, then Figure 3 will appear as soon as you click the Run Report button.

Figure 3 : The generated SAP ABAP Instance Slice and Dice Analytics Report
The SAP ABAP Instance Slice and Dice Analytics report (see ) then appears and reveals the following details:
- This report displays the details of SAP Instance in slice and dice format with several data filters (see Figure 3). The KPI Header option on the right side of this report when enabled, provides a detailed view of the SAP Instance, displaying the count of total invocations, activity rate, average extended memory, and average response time breakup (represented by a bar graph).
- The left panel in the report (see Figure 3) shows the filter condition that involves the filter criteria - Transaction code, User, Task type, User response time,etc., Based on those selected filter criteria, a table appears with the details of the selected filter criteria in the right side of the report below the KPI Header section. Each filter criteria has number of filters and the administrators can select the specific filter for which the report gets generated. By default, only 5 filters will be displayed under each filter criteria. If the user requires more filters to be displayed under a specific filter criteria, it can be achieved by clicking the more link alongside. Using this link, the user can also decide on what are the filters to be selected under each filter criteria (see Figure 4).
  
  Figure 4 : Selection of filters in SAP ABAP Instance Slice and Dice Analytics Report
  
  After clicking the Apply button, the selected filters will be displayed in the left panel with enabled check boxes and the report will be generated based on the chosen filter conditions (see Figure 5).
  
  Figure 5 : Report generated based on the selected filters
- The time slots for the filter criteria like User Response Time, Server Time, Database Operation Count, and Lock Time can be defined (see Figure 6).
  
  Figure 6 : Filtration based on time slots
- Based on the time slots defined for the filter criteria, the report gets generated (see Figure 7).
Figure 7 : Report generated based on defined time slots
On the other hand, if the Background Save - PDF option is chosen from the Report Generation list, then clicking on the Run Report button will not generate the report and display it in this page for your benefit. Instead, a message indicating that the report is being processed in the background will appear. This will be accompanied by a link that will lead you to the page that lists all the reports that are being processed in the background, and their current status. If background report generation fails for a report, you can regenerate that report using this page, or can even delete that report if need be. On the other hand, if background processing successfully completes for your report, then, you can view a PDF of the report by clicking on the icon in that page.