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.

Dimensions also provide contextual information to facts. For example, order being shipped is a fact, However, data such as the order ship date, ship to address, ship from address, and so on are contextual information that is captured by a dimension. Dimensions can be used to filter data and arrive at an appropriate data set. Business Intelligence contains the following target model dimensions.