Example - Create a Crosstab for an Analysis of Order Method Revenue

You are a business analyst at the Sample Outdoors Company, which sells sporting equipment. You are asked to analyze the consequences of discontinuing the fax and mail order methods, which are expensive to process.

First you get the items you need and insert them into a crosstab for further analysis.

Before you can try this example, you must set up the sample packages that come with IBM® Cognos® Business Intelligence. For more information, see the IBM Cognos Business Intelligence Administration and Security Guide.

Procedure

  1. In the IBM Cognos Connection home page, click the Public Folders tab.
  2. Click the Sales and Marketing (cube) package.
  3. Click the Analysis Studio Analysis Studio icon link.

    IBM Cognos Analysis Studio opens, and data from the Sales and Marketing package appears in the source tree.

  4. Drag Revenue from the Measures folder to the Measure area in the crosstab.
  5. Drag Retailers to the Columns area in the crosstab.
  6. Drag Order method to the Rows area in the crosstab.
  7. Click the save button on the toolbar.
  8. In the Name box, type Order Methods Revenue
  9. Leave the default destination folder as Public Folders, and click OK.

Results

You now have data to compare and analyze. Next, you can see if revenues for these methods are growing or declining.

An example of an analysis showing a crosstab that compares revenue for sales regions by order method.
Parent topic: Creating a Basic Analysis