Defining the data mart

You add data marts in Financial Analytic Publisher to define the data you want to publish, and save the information as a definition.

1. Log in to Controller Web.
2. Navigate to the Administration tab > FAP screen.

   The user who has privilege to access the FAP menu can access the FAP screen.

3. On the Database Configuration tab, enter FAP in the Database Name field, and click Connect.
4. On the Sources tab, select the source that is named Production, and click Start.
   The Sources tab details are preconfigured by IBM. Do not make any changes to the details present in the Sources tab.
5. On the Data Mart tab, click New.
6. Enter the following values:

   Name

   Name of data mart

   Source

   Production

   Log level, Interval, Specify forms, Naming conventions, Consolidated groups

   Define these fields as required for your environment. For example, select the Consolidated groups checkbox if you want the monthly consolidated cube holding consolidated values from the last consolidation in Cognos Controller on group level only.

   Admin host

   tm1svr

   Server

   Name of the TM1 Server that holds the data mart

   Client

   LDAP\non-interactive TM1 account

   Password

   password of the non-interactive TM1 account

7. Under Company Structure, click Add, and define the period and consolidation type as required for your organization.
8. Under Start period/Actuality, click Add, and define period and actuality to be published.
9. Click Save.