Configuration for Multischema

When the IBM® Sterling Selling and Fulfillment Foundation is hosted on multischema, there are three types of schemas, of which one is static, and the other two varies with the colonies.

Note: A colony represents a set of enterprises that are grouped together. A PK_PREFIX is a unique two digit number for each colony.

The following figure illustrates the setup required for multischema.

Figure 1. Multischema Setup

The static schema is called metadata, and contains information pertaining to colonies, and the schemas contained under the colonies. Each colony contains the following schemas:

Therefore, in order to support multischema on Cognos®, the following data sources must be created: