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® Controller Link for Microsoft Excel report.
Procedure
- In Microsoft Excel click Paste Codes opens. . The dialog box
- 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.
- Select the parameters of your choice and click OK. The parameters you have selected are pasted into the Excel sheet as values.