| Dimension (data Warehouse) |
Article Index for Dimension |
Website Links For Dimension |
Information AboutDimension (data Warehouse) |
|
A dimensional Data Element is similar to a Categorical Variable in statistics. Greater than or less than comparisons are not used between categories. If dimensions can be shared between multiple cubes, a great deal of duplicated effort can be avoided. This process is called creating "conformed dimensions" and is a keystone of the Kimball data warehouse methodology. EXAMPLE For example a data warehouse may have a database of people, where each person is categorized as having a gender of male, female or unknown. A user of the data warehouse would then be able to filter or categorize each presentation or report by either filtering based on the gender dimension or displaying results broken out by the gender. Gender could then be a property of the person Dimension Table . USE OF ISO REPRESENTATION TERMS When referencing data from a metadata registry such as ISO/IEC 11179 , Representation Term s such as Indicator (a boolean true/false value), '''Code''' (a set of non-overlapping enumerated values) are typically used as dimensions. For example using the National Information Exchange Model the data element name would be '''PersonGenderCode''' and the enumerated values would be '''male''', '''female''' and '''unknown'''. RELATIONSHIP TO OTHER COMPONENTS OF A DATA WAREHOUSE A data warehouse cube is frequently composed of both dimensions or Measures . These can then be placed into dimension and fact tables in a relational database. SEE ALSO
REFERENCES
|
|
|