Adding a data mart

You can add data marts in IBM® Cognos® Financial Analytics Publisher to define which data you want to publish, and save the information as a definition.

You can choose to publish the company structure, start period, and actuality. You can edit the definition and add a new company structure when needed. You can also specify which forms are to be published, edit naming conventions for specific structures, and select a company details or a consolidated groups cube.

Note: IBM Cognos Financial Analytics Publisher must be used in conjunction with IBM Cognos Controller databases that have verified structures and validated data. Before publishing, verify the structures and validate the data using IBM Cognos Controller.

Before you begin

When you define a source, then a check will be done on the existence of a new consolidation model. If only old consolidation models exists, then an error will be displayed that old consolidation models are not supported.

Procedure

  1. In the IBM Controller Financial Analytics Publisher window, click the Data Marts tab.
  2. Click New.
  3. Set the data mart options:
    • Name - Enter the name of the data mart.
    • Source - Select a defined source
    • Log level - Select Low, Normal, High, or Detailed. It is usually best to use log level High.
    • Interval - Specify how many service clock intervals will elapse until the tasks for this data mart are performed.
    • Specify forms - Specify which forms you want to publish.
    • Naming conventions - Specify which names you want to use. When IBM Cognos Express is installed, then naming conflicts can occur because other dimensions are available in the same IBM Cognos TM1® instance. To avoid naming conflicts you can add a suffix and a prefix to FAP dimensions. The valid characters for the prefix and suffix are:
      • Alphanumeric
      • Special characters: ( ) * , . / < > @ \ _ |
      The maximum length of a prefix or suffix is 10 characters. The maximum combined length of a prefix and a suffix is 20 characters.
    • Company details - Publish the company details cube.
    • Consolidated groups - Publish consolidated groups.
    • Description - Enter text that describes the data mart.
    • Company Structure - Select one or more consolidation types for the company structure in the data mart, and enter the period (YYMM) from which the company structure in the data mart will be set up.
    • Start period/Actuality - Decide from when data will be visible in the data mart. You can select one or more periods of the same consolidation type.
    • Admin host - Specify the name of the server that hosts the TM1 servers.
    • Server - Specify the name of a specific TM1 server.
    • Client - Use TM1 Admin.
    • Password - Specify a valid password for the TM1 user.
  4. Click Save.
  5. Confirm that the new data mart is visible in the list on the Data Marts tab.

    You can change the source settings by clicking the Edit button.

  6. Select the data mart that you want to run, and click Start. The status changes from Under definition to Ready for publish.

Results

The next time that the FAP Service runs, it detects the Ready for publish status, creates the cube, and starts the initial publishing of data. When the initial publishing is finished, the data mart status changes to Running. The cube is then updated on a regular basis according to the Clock Interval setting on the Service Settings tab.