FTM sample reports installation

To use the sample reports, do the following steps.
  1. Create a database to use as the content store for Cognos®. This database is separate from the FTM database.
  2. Use Cognos Administration to create a data source with the following properties:

    Name: ftmbasedb_source

    Table 1. Data source properties (sample)
    Type IBM® Db2® database Oracle database
    Database FTMDB Not supported
    Connection string jdbc:db2://localhost:50000/FTMDB Not supported
    Open Session Commands Add the following command block to the open session command block.
    <commandBlock>
   <commands>
      <sqlCommand>
         <sql>SET SCHEMA FTM</sql>
      </sqlCommand>
      <sqlCommand>
         <sql>SET PATH = FTM</sql>
      </sqlCommand>
   </commands>
</commandBlock>
    		 Not supported
  3. Ensure that the installation of the database tables for FTMDB is complete.
  4. Copy FXH_Cognos_Samples.zip to cognos_install_directory/deployment. The files that you need are provided in the FTM artifacts pod and must be downloaded from the pod. For more information about getting files from the artifacts container for your offering, see Getting the files from the artifacts container for your FTM offering.
  5. Use Cognos Administration to import the sample report package.
  6. The reports can be run in Cognos Viewer, or Cognos Report Studio.