Show TOC

DimensionLocate this document in the navigation structure

Definition

The grouping of classification groups (characteristics) whose content is logically connected, under a single generic term. If the dimension contains a characteristic whose value already uniquely determines the values of all other characteristics from a business-orientated viewpoint, then the dimension is named after this characteristic.

The customer dimension could, for example, be made up of the customer number, the customer group and the levels of the customer hierarchy.

The sales dimension could contain the characteristics Sales Person, Sales Group, and Sales Office.

The time dimension could be given using the characteristics Day (in the form YYYYMMDD), Week (in the form YYYY.WW), Month (in the form YYYY.MM), Year (in the form YYYY), and Period (in the form YYYY.PPP).

Use

When defining an InfoCube, characteristics for dimensions are grouped together to enable them to be stored in a star schema table (dimension table). The aforementioned business-orientated grouping can be the basis for this. With the aid of a simple foreign key dependency, dimensions are linked to one of the key fields of the fact table.

For more information, see Enhanced Star Schema.

When you create an InfoCube, the dimensions data package, time, and unit are already defined by default. The data package dimension contains technical characteristics. Units are automatically assigned to the corresponding dimensions. You have to assign time characteristics manually. When you activate the InfoCube, only those dimensions that contain InfoObjects are activated.

Structure

From a technical perspective, several characteristic values are mapped to an abstract dimension key (DIM ID) to which the values in the fact table refer. The characteristics chosen for an InfoCube are divided up among InfoCube-specific dimensions when creating the InfoCube.

Also refer to the following for specific cases arising when defining dimensions:

Line Item and High Cardinality