Paste Codes

You can put parameters as headers on rows or columns in a report.

With the Paste Codes functionality it is possible, in an efficient way, to paste parameters like Account, Company, Currency Code and Extended Dimensions 1-4 horizontally or vertically into the Microsoft Excel sheet. The Paste Codes functionality is the only way to download these parameters automatically into an IBM® Cognos® Controller Link for Microsoft Excel report.

Procedure

  1. In Microsoft Excel click Controller > Reports > Paste Codes Paste codes. The dialog box Paste Codes opens.
  2. Select the code of your choice and whether you want to paste it horizontally or vertically. Click OK. A list box containing all available parameters opens.
  3. Select the parameters of your choice and click OK. The parameters you have selected are pasted into the Excel sheet as values.