Page 23 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes
Usage Describes how an attribute is used.
The available options are as follows:
• Regular The attribute is a regular attribute. This is the default value.
• Key The attribute is a key attribute.
• Parent The attribute is a parent attribute.

Value Column Identifies the column that provides the value of the attribute. If the Name
Column element of the attribute is specified, the same Data Item values are
used as default values for the Value Column element. If the Name Column
element of the attribute is not specified and the Key Columns collection of
the attribute contains a single Key Column element representing a key
column with a string data type, the same Data Item values are used as
default values for the Value Column element.

Source: http://msdn.microsoft.com/en-us/library/ms174919.aspx

Self Assessment

Fill in the blanks:
1. .............................. is an Informational analysis on data which takes into account numerous
distinct connections, each of which comprises a dimension.
2. Information about each dimension is stored in one or more ...................................
3. The key attribute represents the ................................. in the dimension table.
4. An ................................... can also be bound to one or more additional columns for a specific
task.

2.2 Dimension Hierarchy

A hierarchy is a set of parent-child relationships between attributes within a dimension. These
hierarchy attributes are also known as levels. Example, the Time Dimension can have Total,
Year, Quarter, Month and Date as its levels as shown in Figure 2.1:

Figure 2.1: Time Dimension Example

Source: http://oracle-bi.siebelunleashed.com/wp-content/uploads/2011/11/Time-Dim-Hierarchy.jpg

18 LOVELY PROFESSIONAL UNIVERSITY