Prerequisites for deploying Business Intelligence reports

Before deploying the Business Intelligence reports ensure to complete the required prerequisites.

Procedure

  1. Cognos® Connection has been installed.
  2. The content repository has been created through Configuration.
  3. Data Sources have been created using Cognos Connection each named as follows:
    • smcf-meta
    • smcf-config-default
    • smcf-transaction-default
    • smcf-masterdata-default
      Note: The Data Sources are ideally set with isolation level set to Read uncommitted.

Results

You can optionally create sharded data sources at this time for transaction and master data schema types, following this pattern:

smcf-<transaction|masterdata>-<pk_prefix>

For example:

smcf-transaction-01

smcf-masterdata-02

If you are using a non-sharded deployment, the four data sources must point to the same database. However, if you are using a sharded deployment, the four data sources should point to the configured schemas.

Schema

If the user name for a Data Source is not the same as the name of the schema the data source is targeting, an open session command must be added to the Data Source.
Db2
<commandBlock>
<commands>
<sqlCommand>
<sql>SET SCHEMA=<schema-name></sql>
</sqlCommand>
</commands>
</commandBlock>

Oracle
<commandBlock>
<commands>
<sqlCommand>
<sql>ALTER SESSION SET CURRENT_SCHEMA = <schema name></sql>
</sqlCommand>
</commands>
</commandBlock>

For more information, see the IBM® Cognos Analytics IBM Documentation.