The Sterling™ Business Intelligence model

This topic explains the data model and the schemas pertaining to Business Intelligence.

IBM Cognos Framework Manager model star schemas for Sterling Business Intelligence
Business Intelligence provides Cognos® Framework Manager models and a mapping document that defines the facts, dimensions, source, and target, using which you can implement custom extract, transform, and load (ETL) solutions.
Target model star schemas for Sterling Business Intelligence
The star schema groupings delivered in the target model provides a business view of the information in the source model, and is used to simplify the building of reports, analyses, and queries.
Target model dimensions for Sterling Business Intelligence
Dimensions reflect the attributes of a business, such as enterprise, channel, seller, buyer, and so on. Each dimension consists of one or more hierarchy that typically contain several levels. For example, the enterprise dimension contains the enterprise hierarchy and the corresponding levels such as Enterprise (All) and Enterprise Code.
Parameter maps for Sterling Business Intelligence
Parameter maps are objects that store key-value pairs. Use parameters to create conditional query subjects that allow for substitutions when a report is run. Parameter maps are similar to data source look-up tables. Each parameter map has two columns, one for the key and one for the value that the key represents.

Parent topic: Configure Sterling Business Intelligence