Setting Up the Aggregator Application 

Purpose

The aggregator application is a stand-alone Java-application delivered with the portal that processes raw data collected by the data collection service and generates aggregated data for use by portal activity report iViews. The aggregated data is also stored in the portal database.

The aggregator application generates aggregation data for hourly, daily, weekly, monthly or quarterly reports.

In order to use the portal activity report feature, configure and run the aggregator application. Starting the data collection service is not enough. Portal activity report iViews display only aggregated data and not the raw data amassed by the data collection service.

Data is aggregated each hour, but only if the aggregation application is running at the start of each hour. If not, aggregation for the current hourly period is not performed until the start of the first hour after the application is restarted.

Scheduling Aggregation

You can start the aggregation application – by executing the batch file aggregator.bat – and keep the application running indefinitely. As long as the application is running, data is aggregated every hour.

In case you cannot keep the application running all the time, you may want to schedule the application to run each hour, for example, using the Windows Scheduled Tasks wizard. The portal provides a second batch file for starting the application, scheduled_aggregator.bat, which runs the application so that it shuts down as soon as the aggregation is complete. Your scheduler can then start the application automatically again at the start of the next hour.

Location of Files

If the portal is installed in c:\usr, the aggregator application files are located in c:\usr\sap\<SAP_system_ID>\JC<inst_number>\j2ee\cluster\
server<server_number>\apps\sap.com\irj\servlet_jsp\irj\root\
WEB-INF\portal\portalapps\com.sap.portal.activityreport.core\lib

The following are the contents of this folder:

File	Description
DB_Connection.properties	The aggregator application’s properties file, which defines variables needed for connecting to the database
aggregator.bat, aggregator.sh, scheduled_aggregator.bat, scheduled_aggregator.sh	Batch files that start the report aggregator application on Windows (*.bat) or UNIX (*.sh) operating systems All the files start the aggregator application. scheduled_aggregator.bat and scheduled_aggregator.sh start the application and automatically shut down the application after aggregation.
com.sap.portal. activityreport.core_api.jar	The java archive (*.jar) file that contains the main java classes for running the aggregator application

Prerequisites

If you are using an Oracle database, copy classes12.jar from your Oracle client installation to the folder that contains the java archive files for the aggregator.

Process

The following is the workflow for configuring the aggregator application:

...

       1.      Configuring the Aggregator Application. Update the application’s properties file.

       2.      Starting the Aggregator Application. Run the application batch file.