A general category of data, such as time, product, or geography. ()
The data structure of a cube or a means to describe, divide, summarize or view a category of data.
a collection of hierarchies
a descriptive category within the database
an attribute, or set of attributes, by which you can divide measures into sub-categories
an element or category tracked in a WebTrends report
an organized hierarchy of categories, known as levels, that describes data in data warehouse fact tables
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
a structure, often composed of one or more hierarchies, that categorizes data
a structure that categorizes data in order to enable end users to answer business questions
a user defined element such as 'Geography'
As used by multi-dimensional databases (MDDs): A distinct logical hierarchical grouping, such as "geography" (e.g., Store, District, Region) which can be selected and used by the end user to display aggregations at any of the levels in the hierarchy.
A data category, such as time, accounts, products, or markets. In a multidimensional database outline, the dimensions represent the highest consolidation level.
One of the logical "perspectives" for viewing data in a data warehouse. Dimensions contain one or more data hierarchies, which in turn may have one or more data levels.
The term dimension is commonly used in two ways: A general term for any characteristic that is used to specify the members of a data set. The 3 most common dimensions in sales-oriented data warehouses are time, geography, and product. Most dimensions have hierarchies. An object defined in a database to enable queries to navigate dimensions. In Oracle Database 10, a dimension is a database object that defines hierarchical (parent/child) relationships between pairs of column sets. In Oracle Express, a dimension is a database object that consists of a list of values.
A broad grouping of descriptive data about a major aspect of a business, such as products, dates, or markets. Each dimension includes different levels of categories in one or more drill-down paths and an optional set of special categories.
A structural attribute of a cube, which is an organised hierarchy of categories (levels) that describe data in the fact table. These categories typically describe a similar set of members upon which the user wants to base an analysis. For example, a geography dimension might include levels for Country, Region, State or Province, and City.
An aspect of the data (such as SEX or GEOGRAPHY), which is broken down into one or more items [categories] (such as male and female, or Brevard County and Multnomah County). Beyond 20/20 tables contain at least two dimensions, but can contain up to eight dimensions. When you first open a table, all of the items [categories] from two dimensions are displayed in the column and row dimensions. One item from each of the remaining dimensions is displayed in the Dimension bar.
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.
A collection of data of the same type, allowing us to structure the multidimensional database. A dimension is sometimes referred to as an axis. In a measure, each cell of data is associated with one single position in each dimension. Time, Location and Product are the classic dimensions.
In a flat or relational database, each field in a record represents a dimension. In a multidimensional database, a dimension is a set of similar entities; for example, a multidimensional sales database might include the dimensions Product, Time, and City.
Used in structuring materialized views (see materialized view), a dimension defines hierarchical (parent/child) relationships between pairs of columns or column sets. A hierarchical relationship is a functional dependency from one level of a hierarchy to a more abstract level in the hierarchy. Each value at the child level is associated with one and only one parent-level value.
A structure that categorizes data. Among the most common dimensions for sales-oriented data are time, geography, and product. Most dimensions have hierarchies. In an analytic workspace, a dimension is a container for a list of values. A dimension acts as an index for identifying the values of a variable. For example, if sales data has a separate sales figure for each month, then the data has a month dimension; that is, the data is organized by month. In SQL, a dimension is a type of object that defines hierarchical (parent/child) relationships between pairs of column sets. See also hierarchy.
In a data warehouse, a dimension is a data element that categorizes each item in a data set into non-overlapping regions.