Initial publish

The initial publish process creates the FAP dimensions and cubes and fills the cubes with facts and data.

If the dimensions are already present on the TM1® server, they are emptied and not re-created.

Figure 1. FAP Initial publish
In the FAP client, users start the publish process. The FAP Service transfers data from the Controller database to the FAP database and then data is moved into the FAP cubes.

The initial publish process:

  1. Select the IBM® Cognos® Controller data to publish in the FAP client.
  2. Start the initial publish from the FAP client. You can initiate a full or partial initial publish process.
  3. The FAP Service transfers facts and dimensions from IBM Cognos Controller to the FAP database.
  4. A TM1 API call is initiated, building dimensions and creating the cubes.
  5. A TM1 Turbo Integrator (TI) script is run to collect facts and data from the FAP database and fill the cube.

Verify all IBM Cognos Controller structures prior to starting the initial publish.

Once the initial publish is completed it is shown in the FAP client log. Please note that a full initial publish may take some time, depending on the volumes to be moved from the source to the target.