Home > Data Modeler Dialog Boxes > Level Properties
This dialog box is displayed when you view the properties of a level in a multidimensional model.
For business analysis, data is typically summarized by level. For example, the database may contain daily snapshots of a transactional database. Days are the base level. You might summarize this data at the weekly, quarterly, and yearly levels. Thus, levels provide a convenient way of identifying the dimension members at a particular distance from the detail data.
For more information about working with multidimensional data, see Oracle OLAP User's Guide and the online help for Analytic Workspace Manager.
General
Name: Name of the level. Examples: customer, product
Level Entity: Entity associated with this level. Example: customers in customers.customer
Value Based Hierarchy: Controls whether the hierarchy is value-based or level-based. (the latter being more common). If this option is enabled, a value-based hierarchy is used, in which the parent-child relations do not have named levels. If this option is disabled, a value-based hierarchy is used.
Root Identification: For a value-based hierarchy, specify one of the following: Parent is Null, Root has Value, or Parent has Value.
Default Attribute: Default descriptive attribute (if required).
Selection Criteria
Selection criteria for this level.
Selection Criteria Description
Description of the selection criteria for this level.
Level Key
Displays any attributes that are keys for the level. To add a level key object, click the Add (+) icon; to remove a level key object from the level definition, select it and click the Remove (X) icon. To edit a level key object, double-click its item, or click its item and click the Properties icon.
Descriptive Attributes
Name: Name of the attribute.
Attribute: Fully qualified name of the attribute.
Indexed: Controls whether the attribute is indexed.
Slow Changing: Indicates whether this is a Slowly Changing Attribute; and if so, what type. None means it is not a Slowly Changing Attribute; and Type 1, Type 2, or Type 3 means it is a Slowly Changing Attribute of the specified type.
Parent Key
For a level with a value-based hierarchy, lists the attributes of the parent entity.
Calculated Attributes
Lets you add calculated attributes to the level definition and remove them from the definition. For each calculated attribute, you can specify the associated expression.
Oracle AW Attributes
Displays attributes of the level for Oracle Analytic Workspaces.
Oracle Names
Short Name: Short descriptive name that can be used by applications instead of the long name.
Long Name: Long descriptive name, typically used for display.
Plural Name: Plural name (for reporting purposes). For example: Mylevels if the Short Short Name is Mylevel
MS Olap
Lets you specify the name and value columns for use with Microsoft OLAP.
Description
Description of the level.
Partitioning Description
Description of the partitioning for the level.
Comments, Notes, Responsible Parties, Documents, Summary