<![CDATA[Dundas Support Zone - Overview - Dimensions]]>http://support.dundas.com/Dashboard5.Dimensions_Overview.ashxThu, 18 Jun 2020 02:11:31 GMTScrewTurn Wiki RSS Feed Generator<![CDATA[Overview - Dimensions]]>http://support.dundas.com/Dashboard5.Dimensions_Overview.ashxDocumentation | Defining Dimensions


A dimension can be thought of as a collection of categories that you use, in conjunction with KPIs/datasets, to perform data filtering, grouping, and sorting. To allow for both detailed and general views of your data (&ie; drilling down and drilling up), these categories are typically arranged in a hierarchy of dimension levels. For example, using Dundas Dashboard, you can define a dimension that has a single hierarchy with three levels:

  • Level 1 - Product Category
  • Level 2 - Product Subcategory
  • Level 3 - Product Item

A level has members, which are the distinct categories available at that level. For example, a Product Category level could have the following members:

  • Cameras
  • Computers
  • Monitors

A level also has attributes or metadata associated with it, such as a level name.

Tip: Dimensions should be used at the KPI stage when employing empty data point rules to handle missing data.

Tip: watch the how to video: Dimensions

Types of dimensions

Dundas Dashboard supports two types of dimensions: standard and time. The time dimension is treated as a special case because it can have more than one hierarchy and the levels for a time dimension hierarchy are well-known, being based on calendar standards such as Gregorian, Fiscal, and ISO 8601 (an international standard based on week numbers).

Tip: A standard dimension is also referred to as a full or regular dimension.

A standard dimension with two levels: Product Category and Product Item.

A standard dimension with
two levels: Product Category
and Product Item.

A time dimension hierarchy based on a Gregorian calendar.

A time dimension hierarchy
based on a Gregorian calendar.

(All) and (Unknown) members

In Dundas Dashboard, there exist the following special members or categories of a dimension:

  • (All) - The (All) member is used to represent the entire set of categories defined by a dimension.
  • (Unknown) - The (Unknown) member is used to categorize data that does not belong to any of the level members defined by your dimension.

When you create a standard dimension in Dundas Dashboard, you have the option of renaming the (All) and (Unknown) members.

As an example of unknown members, consider a Geography dimension that has a level called States. The States level consists of members representing the continental U.S. states only. Now, suppose you are working with sales data that actually includes sales from an offshore state such as Hawaii. With &dw;, you can choose to omit such data or group the data as part of the (Unknown) member category.


The following figure illustrates how dimensions fit into the overall &dw; workflow.

Workflow for dimensions.

Workflow for dimensions.

Related topics

Click to return to: Documentation | Defining Dimensions ]]>
miket@dundas.com (miket@dundas.com)Tue, 15 Oct 2013 14:51:40 GMTCCA3287C8BF5D210ABC84CE97F9F7E44