A dimension can define multiple dimension elements for
different levels of summation.
For example, all the elements that relate to the structure of a
sales organization might comprise one dimension. The following figure
shows the dimension elements that the Accounts dimension defines. Figure 1: Dimension elements in the accounts dimension
Dimensions are made up of hierarchies of related elements. Because
of the hierarchical aspect of dimensions, users are able to construct
queries that access data at a higher level (roll up)
or lower level (drill down) than the previous level of
detail. The figure shows the hierarchical relationships of the dimension
elements:
The account elements roll up to the territory elements
The territory elements roll up to the region elements
Users can query at different levels of the dimension, depending
on the data they want to retrieve. For example, users might perform
a query against all regions and then drill down to the territory or
account level for detailed information.
Dimension elements are usually stored in the database as numeric
codes or short character strings to facilitate joins to other tables.
Each dimension element can define multiple dimension attributes,
in the same way dimensions can define multiple dimension elements.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.
