Search

A base table is a synonym for a fact table. It contains data stored at the lowest level of detail. In this way the information can be combined with a multitude of dimensional information.

A fact table contains all numeric information for one single business process in context of multiple related dimensions.eg. a sales fact contains number of sold quantities, revenue, margin, etc. The granularity is ideally kept as low as possible in order to enable a variety of reports and analyses.

A fact table contains all numeric information for one single business process in context of multiple related dimensions.eg. a sales fact contains number of sold quantities, revenue, margin, etc. The granularity is ideally kept as low as possible in order to enable a variety of reports and analyses.

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 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.

Master data is the collection of the most important reference data within an organization.This is mostly limited to a certain set of entities, such as customers, products, financial accounts, suppliers, employees, … Next to the central government of this information, attention is given to the ownership and processes which maintain the data and ensure that master data can be used properly and consistently in all of the systems and databases of the organisation.