Publishing to a Data Mart

The following example illustrates the Publish to Data Mart function in IBM® Cognos® Controller.

If you want to use the Publish to Data Mart function in IBM Cognos Controller instead, the transformation will look like the following diagram. Note that the Publish to Data Mart function does not support the time dependent dimension concept of IBM Cognos Controller Financial Analytics Publisher, and that the elimination company naming convention is slightly different.

Figure 1. Publish to Data Mart function
Compared with trial balance function example, in Controller Publish to Data Mart function, elimination data in the target is stored on the EC_1000 company.