Dimension (data warehouse)
A dimension is a structure that categorizes facts and measures in order to enable users to answer business questions. Commonly used dimensions are people, products, place and time. (Note: People and time sometimes are not modeled as dimensions.) 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 labelling.
Wikipage disambiguates
Aggregate (data warehouse)Aggregate dataBitmap indexContextual Query LanguageData dimensionData warehouseDegenerate dimensionDimensionDimension(data warehouse)Dimension (disambiguation)Dimension tableDimensional Role-PlayingDimensional modelingEarly-arriving factExtract, transform, loadFact constellationFact tableGESMES/TSIBM Planning AnalyticsMeasure (data warehouse)MultiDimensional eXpressionsMultidimensional analysisOLAP cubeOnline analytical processingOutline of databasesPostgreSQLReverse star schemaShard (database architecture)Slowly changing dimensionSnowflake schemaStar schema
Link from a Wikipage to another Wikipage
primaryTopic
Dimension (data warehouse)
A dimension is a structure that categorizes facts and measures in order to enable users to answer business questions. Commonly used dimensions are people, products, place and time. (Note: People and time sometimes are not modeled as dimensions.) 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 labelling.
has abstract
A dimension is a structure tha ...... e grouped into) Years"
* etc.
@en
En un almacén de datos o un si ...... strados en la tabla de hechos.
@es
Розмірність (англ. dimension t ...... а допомогою зовнішнього ключа.
@uk
Таблица измерений (англ. dimen ...... атрибут в существующую строку.
@ru
Wikipage page ID
page length (characters) of wiki page
Wikipage revision ID
1,015,254,254
Link from a Wikipage to another Wikipage
wikiPageUsesTemplate
subject
hypernym
type
comment
A dimension is a structure tha ...... ering, grouping and labelling.
@en
En un almacén de datos o un si ...... strados en la tabla de hechos.
@es
Розмірність (англ. dimension t ...... тегорійну змінну в статистиці.
@uk
Таблица измерений (англ. dimen ...... ений с помощью внешнего ключа.
@ru
label
Dimension (data warehouse)
@en
Tabla de dimensión
@es
Розмірність (сховище даних)
@uk
Таблица измерений
@ru