Customizing the WebSphere Commerce Analyzer

You can create new WebSphere Commerce Analyzer business intelligence reports and customize the reports to fit the end-users' needs using the reporting framework provided with the product.

As a sample scenario, the WebSphere Commerce merchant wants to see the profit analysis information of the Gift Center within a time period in the WebSphere Commerce Analyzer report. After carefully analyzing the business requirements, you decide to customize an existing report or create a new report to meet the business needs.

This customization scenario demonstrates the customization of Replication, ETL, and reports to generate a Gift Center report to determine the profit analysis information. WebSphere Commerce Analyzer extracts data from a WebSphere Commerce database and populates it into the WebSphere Commerce Analyzer data mart on the WebSphere Commerce Analyzer server. All the WebSphere Commerce Analyzer reports are designed based on the WebSphere Commerce Analyzer data mart.

The following topic describes the customization of WebSphere Commerce Analyzer for creating new reports such that configure and run the WebSphere Commerce Analyzer to create new tables and extract the data from WebSphere Commerce database.

  1. Customizing the replication setup

  2. Customizing the extract, transform and load (ETL) processes

  3. Customizing the business intelligence reports

In case the tables already exist in the WebSphere Commerce Analyzer server, and you only want to modify the report then just follow the steps in Customizing the business intelligence reports

Before you start the customization, ensure that you have installed the following:

Before attempting to make any customization changes, you should have experience in:

Related concepts