Extending the Operational Reporting Data Model

You can modify the operational reporting data model to incorporate the specific needs of your Sterling™ Order Management System Software installation by extending the catalog.

Before you extend the data model, see the IBM® Cognos® Analytics documentation to understand how to use the product and then apply that knowledge for the data model. Be sure to create a backup of all components that are going to be modified.

The Data Model is extended by adding, deleting, or renaming fields, tables, or entities. You can extend the application-provided Data Model to include custom columns or tables from the Sterling Order Management System Software database.

Note: If you create any new Data Models, you must upload them to a subfolder in the shared directory.

To customize the default data model provided by Sterling Order Management System Software, see Customizing the SMCF-Analytics Model.

Adding fields and tables

You can add fields and tables in Business Intelligence. For more information, see the IBM Cognos Analytics documentation.

Deleting or renaming fields and tables

Ensure that you do not delete or rename the objects that exist in the catalog that are delivered with operational reporting. If you delete the objects, it can create compatibility problems with future versions of the framework components. However, if it is necessary to delete some objects, follow the guidelines that are provided in the IBM Cognos Analytics documentation.

Note: You do not need extra license to use any of the inbuilt Cognos tools, which includes the framework manager.