Example - Order Methods Ranking

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.

Now that you have detected a trend in the data, you want to see how they rank in your overall revenues.

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. Open the Order Methods Trend analysis.
  2. Right-click the Fax row and click Calculate calculate icon, Custom.
  3. In the Calculate dialog box, under Rank, click Compare each value in Fax with other values in Order method.
  4. Click OK.

    A new row appears that ranks the Fax order method against other order methods for each year.

  5. Repeat steps 2 to 4, using the Mail order method.

    You can see that both Fax and Mail rank low in every year.

  6. Save the analysis as Order Methods Rank, leave the default destination folder as Public Folders, and click OK.

Results

An example of a ranked analysis.
Parent topic: Using Calculations