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.
- 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.
- On the TADDM server, open the $COLLATION_HOME/bin directory.
Refresh the extended attributes views by completing the following steps:
If you created any extended attribute views, remove them by running the following
Generate SQL scripts with extended attribute views definitions by running the following
Create the extended attribute views with the use of the generated SQL scripts by running the
- If you created any extended attribute views, remove them by running the following command:
To generate the Cognos model file, run the following command:
./genCognosModel.shThe 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.
For more information about extended attributes views, see Extended attributes views.