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:
- Configuration—This contains the configuration data.
- Transaction—This contains the master data and transaction
data.
Therefore, in order to support multischema
on Cognos®, the following
data sources
must be created:
- wms-meta—Configure this
data source such that it
points to the metadata schema of the IBM Sterling Selling and Fulfillment Foundation.
Specify the name of the data source as wms-meta.
Note: The
metadata schema contains information pertaining to the colonies. For
each colony, configure the following data sources:
- wms-configuration-<PK_PREFIX>
- wms-transaction-<PK_PREFIX>
- wms-master-<PK_PREFIX>
- wms-configuration-<PK_PREFIX>—Configure
this data source such that it points to the configuration schema of
the colony in the IBM Sterling Selling and Fulfillment Foundation.
- wms-transaction-<PK_PREFIX>—Configure
this data source such that it points to the transaction schema of
the colony in the IBM Sterling Selling and Fulfillment Foundation.
- wms-master-<PK_PREFIX>—Configure this
data source such that it points to the transaction schema of the colony
in the IBM Sterling Selling and Fulfillment Foundation.
Note that the transaction schema contains both the master data and
the transaction data.