Functionality

Do not use data that is a result of a formula or a condition (like =IF()) when you enter an IBM® Cognos Controller function. Do not conditionally evaluate an Cognos Controller function. Use simple expressions in many cells instead. Long expressions can easily become errors. Example: The following examples shows conditional evaluation: =IF(condition;=cc.fStatus( );=cc.fStatusDate( )) =cc.fStatus(IF(A2>2;param1a;param1b)param2,param3)

When you update the IBM Cognos® Controller Link for Microsoft Excel with data from the Cognos Controller database it is recommended to have only the workbook to be updated open in Microsoft Excel. Close all other Excel files.

In the Report Generator report, remember to keep the report created by Cognos Controller in the first sheet. You cannot, for example, insert another sheet in front of the Cognos Controller data sheet.

In Report Generator reports, the entire first row and the entire first column are so called system rows/columns (as well as columns A, B and C, row 1-26). Do not enter anything on the system rows/columns. It is also recommended that no data is entered on the entire area of the report. Also do not make references to the system rows since these can be subject to changes. In the IBM Cognos Controller Link for Microsoft Excel any rows/columns can be used.

It is recommended that you keep the expressions in the cells as simple as possible. One example is that you can use formatting of the cells instead of, for example, =CC.fGetVal(...) /1000.

When defining an fGetVal statement in an IBM Cognos Controller Link for Microsoft Excel report, you can define currency as LC or LE for a particular period. If the legal currency (LE) or local currency (LC) changes from one period to another then the currency of the value retrieved will remain the same for both periods. This is because the function fGetVal retrieves values in the currency that is the LC/LE currency in the lowest (earliest) period used in any fGetVal for a particular company in the workbook.

If you insert a hard coded currency, for example SEK, the fGetVal will then retrieve the values in SEK for the period you choose.