Publish Datamarts

You can use this function to make the data or structure templates you defined in Transfer/Publish Data and Structures/Define Data Mart available in other IBM Cognos applications, for analysis purposes.

All templates that you have defined are available in the Publish Data Mart window.

You publish data by selecting the Generate column and the Periods that you want to export values for.

Data and structures will be published in the languages that are selected as Group Language and Local Language in IBM® Cognos Controller.

It is also possible to select if you want to update structure tables or use structure information from the previous export.

You can put a datamart process in the batch queue.

For more information, see The Batch Queue.

Note: The ability to publish datamarts is not available in Cognos Controller on Cloud.

Before you begin

Note: Cubes can only be defined and published if additional configurations have been performed. Contact your Controller administrator for more information.

The instruction describes how you publish datamarts, which means that you select relevant cubes or export templates with the purpose to perform analyzes.

Note: To be able to use the Additional Target IBM Cognos BI, you have to log on to IBM Cognos Controller with IBM Cognos Authentication. For more information, see IBM Cognos authentication.

Procedure

  1. On the Transfer menu, click Publish Data and Structures/Publish Data Mart. The Publish Data Mart window opens.
  2. All defined export templates and cubes are displayed. Select the check boxes in the Generate column for the cubes or templates you want to process.
  3. Enter the period or periods you want to export values for. You can click the browse button to select one or more periods.

    Select Structures if you want to update the extended dimension structures. Otherwise, structure information from the previous export will be used.

    Use Scheduled at to schedule when the cube/template is to be processed. The job will be put in the Batch Queue.

  4. Click Run. The information is processed. This may take a while. When the processing is ready a message appears.