Create Reports

One way is to process and use the report as the Report Generator creates it. Another way is to build up and design a report under the data area created by the Report Generator and then make references to the data area above.

The Report Generator helps you to create advanced management reports in Microsoft Excel format. The wizard allows you to put dimensions, for example company or account, as headers on rows and columns, and loads data directly from the IBM® Cognos Controller database into the data area. When you have defined the rows and columns in the report wizard, you can go to the layout in Excel to make manual additions to the report. You can for example insert, along with Excels own functions, a number of Cognos Controller functions specifically adapted to fetch data from Cognos Controller’s database.

Reports created and saved with the Report Generator functionality can be run from both Cognos Controller and Microsoft Excel. The layout is saved in Cognos Controller.

The Report Generator is based on Microsoft Excel, which means that it has all the functionality of Excel.