Installing Cognos Controller Financial Analytics Publisher

IBM® Cognos® Controller includes an integration component, IBM Cognos Financial Analytics Publisher, that automates the process of extracting data in close to real time from Cognos Controller into IBM Cognos TM1®.

IBM Cognos Financial Analytics Publisher uses a temporary storage area before populating the TM1 cube. Once the initial publish operation is started, the TM1 cube is updated continuously, and you can define how often the service should run. From the TM1 cube, the IBM Cognos Controller data can be accessed by a number of reporting tools, including IBM Cognos BI studios. For more information about using Cognos Controller Financial Analytics Publisher, see Using Financial Analytics Publisher.

Schematic overview

Because the installation of IBM Cognos Controller Financial Analytics Publisher includes several different server components, there are a number of installation options.

The following diagram shows one of these options and how it relates to the IBM Cognos Controller application and database servers. The Cognos Controller Financial Analytics Publisher Client (that is, the admin console) is installed on the Cognos Controller application server, the Financial Analytics Publisher database on a separate database server, finally the Financial Analytics Publisher Server and TM1 on the TM1 application server.

A Cognos Controller application server icon with Cognos Controller Financial Analytics Publisher Client installed on it, a database server icon with the Controller database, a database server icon with the Financial Analytics Publisher database, finally a TM1 application server icon with Financial Analytics Publisher Server, TM1 and the ODBC data source installed on it.

In addition to the server components, you need access to the cube. There are a number of reporting tools you can use, including IBM Cognos BI studios.