Fix Pack
9

Generating the TADDM model

You can generate the TADDM model to have the up-to-date snapshot of the TADDM database content, including definitions of all extended attributes. If you do not use extended attributes, you can skip this procedure and use the prebuilt TADDM Cognos model file, the $COLLATION_HOME/etc/reporting/tcr/model.xml file.

The generated TADDM model includes all Common Data Model classes that are supported by TADDM and extended attributes definitions that are stored in the TADDM database. You can publish the TADDM model in IBM® Cognos® Analytics server and use it in Cognos reports. You can generate the TADDM model many times. Each time the model is regenerated, it contains the updated TADDM database content.
Notes:
  • If extended attribute definitions are removed from the TADDM database after the TADDM model is published in IBM Cognos Analytics server, the Cognos reports that use them might stop working.
  • If you use the Windows operating system, change the extension of the scripts that are used in the following procedure from .sh to .bat.
  1. On the TADDM server, open the $COLLATION_HOME/bin directory.
  2. Refresh the extended attributes views by completing the following steps:
    1. If you created any extended attribute views, remove them by running the following command:
      ./extattr_views.sh remove
    2. Generate SQL scripts with extended attribute views definitions by running the following command:
      ./extattr_views.sh scripts
    3. Create the extended attribute views with the use of the generated SQL scripts by running the following command:
      ./extattr_views.sh create
  3. To generate the Cognos model file, run the following command:
    ./genCognosModel.sh
    The generated TADDM model is stored in the model.xml file and it is placed in the $COLLATION_HOME/etc/reporting/tcr directory. The log messages of the command are in the $COLLATION_HOME/log/genCognosModel.log file.
You can publish the generated TADDM model in IBM Cognos Analytics server by using IBM Cognos Framework Manager. For more information, see Publishing the model using IBM Cognos Framework Manager.

For more information about extended attributes views, see Extended attributes views.