Create dashboard data sources

The dashboards use IBM® Cognos® data sources.

Create an IBM Cognos data source for FTMBase_Dashboard_Samples.zip

All of the dashboards and reports in this package use a data source that is named ftmbase_dashboard_source. The dashboards in this archive file display the data for the current business day and are typically connected to the FTM database (FTMDB, for example). However, if a replicated database is available, these dashboards can be connected to the replicated database instead of the FTM database. When the replicated database is used for the dashboards, the data for the dashboards is delayed by at least the database replication interval as well as some other factors.

For more information about defining a data source connection in Cognos Analytics, see Creating a data source connection in the IBM Cognos Analytics product documentation.

The following table shows the parameters for the data source for this package.
Table 1. Data source parameters for the FTMBase_Dashboard_Samples.zip package
Parameter name Value or description
Name ftmbase_dashboard_source
Data Source Type Set the data source type to DQM by selecting the Configure JDBC Connection check box.
Isolation Level Select the isolation level for the data source.
Database Typically, this data source is connected to the FTM database (FTMDB).
Db2 connect string jdbc:db2://localhost:50000/FTMDB
Db2 Connection Parameters Specify any database connection parameters. Test the connection to verify that the configuration works.
Db2 JDBC Connection Parameters Specify any JDBC database connection parameters. Test the connection to verify that the configuration works.
Open Session Commands 
<commandBlock>
   <commands>
      <sqlCommand>
         <sql>SET SCHEMA FTM</sql>
      </sqlCommand>
      <sqlCommand>
         <sql>SET PATH = FTM</sql>
      </sqlCommand>
    </commands>
</commandBlock>

Create an IBM Cognos data source for FTMBase_Trending_Dashboard_Samples.zip

All of the dashboards and reports in this package use a data source named ftmbase_trending_dashboard_source. The dashboards in this archive file display the data for long-term trends and are typically connected to the replicated, or historical, database. However, if a replicated database is not available, these dashboards can be connected to the FTM database instead of the replicated database.

When the FTM database is used to provide the data for the trending dashboards, the data that is available for the dashboard is limited to the amount of data that is available in the FTM database. For example, if the FTM database holds only data for the last 100 days, the dashboards can display only the trends for the last 100 days.

For more information about defining a data source connection in Cognos Analytics, see Creating a data source connection in the IBM Cognos Analytics product documentation.

The following table shows the parameters for the data source for this package.
Table 2. Data source parameters for the FTMBase_Trending_Dashboard_Samples.zip package
Parameter name Value or description
Name ftmbase_trending_dashboard_source
Data Source Type Set the data source type to DQM by selecting the Configure JDBC Connection check box.
Isolation Level Select the isolation level for the data source.
Database Typically, this data source is connected to your replicated database.
Db2 connect string jdbc:db2://localhost:50000/name of the replicated database
Db2 Connection Parameters Specify any database connection parameters. Test the connection to verify that the configuration works.
Db2 JDBC Connection Parameters Specify any JDBC database connection parameters. Test the connection to verify that the configuration works.
Open Session Commands 
<commandBlock>
   <commands>
      <sqlCommand>
         <sql>SET SCHEMA FTM</sql>
      </sqlCommand>
      <sqlCommand>
         <sql>SET PATH = FTM</sql>
      </sqlCommand>
   </commands>
</commandBlock>