Dimension

Choose Index below for a list of all words and phrases defined in this glossary.

Dimension : (1) See Information quality characteristic. (2) A category for summarising or viewing data (e.g., time period, product, product line, geographic area, organisation). See also Enterprise dimension.

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 23-Jan-2009 12:46

These advertisers support this free service

Dimension - High level data grouping which serves as a mechanism for slicing the statistical measures of the warehouse, such as: geography, account, product and time.

[Category=Data Governance ]

Source: The Data Governance Institute, 30 November 2009 08:53:28, http://www.datagovernance.com/glossary-governance/

Dimension - One of the perspectives that can be used to analyze the data in an OLAP cube. When you are browsing the data in a cube, you can view the data from the perspective of different combinations of dimensions. For a Sales database, the dimensions could include Product, Time, Store, and Promotion. Dimensions contain one or more hierarchies, which have levels for drilling up and drilling down in the the cube. When a dimension has just one hierarchy (which is quite common ), people often refer to the dimension itself having levels.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 07 May 2010 07:52:32, SDG Computing, now offline

Dimension - A dimension is a structural attribute of a cube that is a list of members, all of which are of a similar type in the user's perception of the data. For example, all months, quarters, years, etc., make up a time dimension; likewise all cities, regions, countries, etc., make up a geography dimension. A dimension acts as an index for identifying values within a multidimensional array. If one member of the dimension is selected, then the remaining dimensions in which a range of members (or all members) are selected defines a sub-cube. If all but two dimensions have a single member selected, the remaining two dimensions define a spreadsheet (or a "slice" or a "page"). If all dimensions have a single member selected, then a single cell is defined. Dimensions offer a very concise, intuitive way of organizing and selecting data for retrieval, exploration and analysis.

[Category=Information Management ]

Source: Information-Management.com, 14 June 2010 07:54:25, http://www.information-management.com/glossary/d.html

Dimension - A dimension is a structural attribute of a cube that is a list of members, all of which are of a similar type in the user's perception of the data. For example, all months, quarters, years, etc., make up a time dimension; likewise all cities, regions, countries, etc., make up a geography dimension. A dimension acts as an index for identifying values within a multi-dimensional array. If one member of the dimension is selected, then the remaining dimensions in which a range of members (or all members) are selected defines a sub-cube. If all but two dimensions have a single member selected, the remaining two dimensions define a spreadsheet (or a "slice" or a "page"). If all dimensions have a single member selected, then a single cell is defined. Dimensions offer a very concise, intuitive way of organizing and selecting data for retrieval, exploration and analysis.

[Category=Data Management ]

Source: DataMentors, 18 August 2010 09:20:36, http://www.datamentors.com/News-and-Resources/Glossary.html

Dimension - A multidimensional structure which represents a side of a multidimensional cube. Each dimension represents a different category, such as region, time, product type. Discovery The evaluation and validation of the implemented data warehouse increment, experiences and lessons learned, and scope for next increment to be developed.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 28 November 2010 13:42:18, http://www.aexis.eu/DataWarehouse-Glossary/

dimension -

(1) [physics] A length of a certain distance and bearing.

(2) [physics] The area over which an entity extends.

(3) [physics] The number of axes that are essential to the existence of an entity in space. For example, the identity of a location on a plane requires two axes; therefore, a plane exists in the second dimension, and an entity with two axes, or dimensions, may be uniquely identified as a plane.

[Category=Geospatial ]

Source: esri, 29 March 2012 09:25:45, http://support.esri.com/en/knowledgebase/GISDictionary/term/abbreviation

Dimension - Dimensions can be thought of as perspectives on a subject. Let's say your subject of interest is sales. One way of analyzing sales is by time. How many widgets did we sell last month? Last quarter? Last year? This is a time dimension.

Maybe you want to look at your sales data by geography. What were our sales in Beijing? China? How about all of Asia? This is a geography dimension.

Product or product category might be useful. What was my best selling product? are there any product categories that aren't hitting their sales targets? This is a product dimension.

Having multiple perspectives or dimensions with which to view the subject is very powerful. This allows you to put them together and get answers to even more detailed questions. What was the worst selling product category in Beijing last quarter?

[Category=Business Intelligence ]

Source: Deanna Dicken, 07 November 2012 09:45:53, http://www.databasejournal.com/features/mssql/article.php/3919011/Business-Intelligence-Terminology-101.htm

dimension - In data warehousing, a dimension is a collection of reference information about a measurable event. In this context, events are known as "facts." Dimensions categorize and describe data warehouse facts and measures in ways that support meaningful answers to business questions. They form the very core of dimensional modeling.

A data warehouse organizes descriptive attributes as columns in dimension tables. For example, a customer dimension’s attributes could include first and last name, birth date, gender, etc., or a website dimension would include site name and URL attributes.

A dimension table has a primary key column that uniquely identifies each dimension record (row). The dimension table is associated with a fact table using this key. Data in the fact table can be filtered and grouped (“sliced and diced”) by various combinations of attributes. For example, a Login fact with Customer, Website, and Date dimensions can be queried for “number of males age 19-25 who logged in to funsportsite.com more than once during the last week of September 2010, grouped by day.”

Many dimensions contain a hierarchy of attributes that support drilling up and down. For example, a Date dimension could contain a hierarchy of year > quarter > month > week > date. A report displaying the number of website logins for 2009 by month could drill up to display logins by year, or drill down to display logins by day.

Dimensions are used in data warehouse star and snowflake schemas, OLAP cubes, and business intelligence (BI) and business analytic (BA) applications.The following dimensions can be used to meet specific data warehousing needs:

   * junk dimensions - a collection of miscellaneous attributes that are unrelated to any particular dimension.
   * degenerate dimensions - data that is dimensional in nature but stored in a fact table.
   * role playing dimensions - a dimension that can play different roles in a fact table depending on the context.
   * conformed dimensions - a dimension that has exactly the same meaning and content when being referred to from different fact tables.

[Category=Data Management ]

Source: WhatIs.com, 27 July 2013 11:02:47, http://whatis.techtarget.com/glossary/Data-and-Data-Management

Dimension

Dimension - definitions