What is Dimension

A dimension is a structure that categorizes facts and measures to enable identities to answer business questions. Commonly used dimensions are people, products, place, and time.

In a data warehouse, dimensions provide structured labeling information to otherwise unordered numeric measures. The dimension is a data set composed of individual, non-overlapping data elements. The primary functions of dimensions are threefold: to provide filtering, grouping, and labeling.

These functions are described as "slice and dice". A common data warehouse example involves sales as the measure, with customer and product as dimensions. In each sale, a customer buys a product. The data can be sliced by removing all customers except for a group under study, and then diced by grouping by product.

Dimension in Profitbase InVision

You have the option to create two types of dimensions in Profitbase LOW CODE. Free dimensions and linked dimensions. Linked dimensions are connected to a dimension in your Profitbase Data Warehouse and the maintenance of these dimensions will be done in Profitbase Studio.

See Also