Adding a transpose

Use a transpose to transpose rows into columns to change the way your data is displayed in an IBM® Cognos® Incentive Compensation Management Presenter report.

About this task

Transpose can be helpful if the data you want to present is displayed in a different format than the final source results.

Table 1. Original data
Payee Month Value
John Smith Month 1 10
John Smith Month 2 20
John Smith Month 3 30
John Smith Month 4 40
Jennifer Williams Month 1 15
Jennifer Williams Month 2 25
Jennifer Williams Month 3 35
Jennifer Williams Month 4 90
Table 2. Transpose original data
Payee Month 1 Month 2 Month 3 Month 4
John Smith 10 20 30 40
Jennifer Williams 15 25 35 90

In order for the Transpose functionality to be available, it needs an explicit key structure to work with. The workaround to define this key structure is to create an aggregated transformation of your source and partition by all of the columns. After this has been completed, you should be able to create a transposed source from the original source.

Procedure

  1. Expand the Sources folder.
  2. To add a transpose, perform one of the following steps:
    • Right-click the data source and select Add Source > Add Transformation > Add Transpose.
    • Select the data source, click the Add icon, and select Add Transpose.
  3. Type a name for the transposed source and click Next.
  4. Select the column to transpose.
  5. Name the new column and click Next.
  6. Choose the rows in the Row Value column and select >> to move them to the New Columns pane.
  7. Click Finish.
Parent topic: Transformations