Search

A measure is a numeric expression, which can be used and displayed –by dimension- on reports and consist of base facts, aggregated values or mathematical functions.

A dimension table contains all information for one single entity in context of one or more related fact tables. Within a business question it deals with the "by” part. E.g. a customer dimension contains a customer number, name, address, contacts etc.

A dimension table contains all information for one single entity in context of one or more related fact tables. Within a business question it deals with the "by” part. E.g. a customer dimension contains a customer number, name, address, contacts etc.

Metadata is data about data. Metadata is used to describe the properties of data such as dimensions, hierarchies, performance metrics and report layout objectsA distinction can be made between business and technical metadata.

Metadata is data about data. Metadata is used to describe the properties of data such as dimensions, hierarchies, performance metrics and report layout objectsA distinction can be made between business and technical metadata.

The natural key or business key is the key of a table as defined within a source system.

A foreign key is the connecting link between two tables which enables the possibility to use the related information together. In a proper setup, the foreign key is pointing to the primary key of the connected table and it thus ensures the referential integrity of the data.

A foreign key is the connecting link between two tables which enables the possibility to use the related information together. In a proper setup, the foreign key is pointing to the primary key of the connected table and it thus ensures the referential integrity of the data.

A measure is a numeric expression, which can be used and displayed –by dimension- on reports and consist of base facts, aggregated values or mathematical functions.

A surrogate key or technical key is an artificially created numerical key without any business meaning. These keys are used within a data warehouse environment in order to easily combine tables.