Page 22 - DCAP606_BUSINESS_INTELLIGENCE

Unit 2: Multidimensional Analysis

Notes
parent-child hierarchy has been defined. The available options are as
follows:
• Non-leaf Data Hidden Non-leaf data is hidden.
• Non-leaf Data Visible Non-leaf data is visible.

Members with Data Provides a template string that is used by parent attributes to create captions
Caption for system-generated data members in the parent attribute. This property
value is only used when the value of the Usage property is set to Parent. This
means that a parent-child hierarchy has been defined.
Name Contains the user-friendly name of the attribute.
Name Column Identifies the column that provides the name of the attribute that is
displayed to users, instead of the value in the key column for the attribute.
This column is used when the key column value for an attribute member is
cryptic or not otherwise useful to the user, or when the key column is based
on a composite key. The Name Column property is not used in parent-child
hierarchies; instead, the Name Column property for child members is used
as the member names in a parent-child hierarchy.
Naming Template Defines how levels are named in a parent-child hierarchy constructed from
the parent attribute. This property value is only used when the value of the
Usage property is set to Parent. This means that a parent-child hierarchy has
been defined.

Order By Describes how to order the members that are contained in the attribute
hierarchy. The default value is Name, which specifies that ordering of the
attribute members is based on the value of the Name Column property, if
any. Otherwise, members are ordered by the value of the key column. The
available options are as follows:
• Name Column Order by the value of the Name Column property.
• Key Order by the value of the key column of the attribute member.
• Attribute Key Order by the value of the member key of a specified
attribute, which must have an attribute relationship to the attribute.
• Attribute Name Order by the value of the member name of a specified
attribute, which must have an attribute relationship to the attribute.
Order By Attribute Identifies the attribute by which to order the members of the attribute
hierarchy.
Root Member If Determines how the root or topmost members of a parent-child hierarchy
are identified. This property value is only used when the value of the Usage
property is set to Parent. This means that a parent-child hierarchy has been
defined. The default value is Parent Is Blank Self Or Missing, which means
that only members that meet one or more of the conditions described for
Parent Is Blank, Parent Is Self, or Parent Is Missing are treated as root
members. The following values are also available:
• Parent Is Blank Only members with a null, a zero, or an empty string in
the key column or columns are treated as root members.
• Parent Is Self Only members with themselves as parents are treated as
root members.
• Parent Is Missing Only members with parents that cannot be found are
treated as root members.
Type Contains the type of the attribute.
Unary Operator Specifies the column that provides unary operators. It is a binding of Data
Column Item type that defines the details of a column providing a unary operator.

Contd....

LOVELY PROFESSIONAL UNIVERSITY 17