The following objects support dimension hierarchies:
The values of the member_parentrel relation, member_gid variable, and member_inhier variable can be different for different hierarchies, so the hierlist dimension is used to define these objects.
A hierlist dimension stores the names of the hierarchies defined for a particular dimension. The names of the hierarchies are acquired from the OLAP Catalog. This text dimension typically has a name of dimdef_HIERLIST.
Contents of a Hierlist Dimension
Example shows the contents of CUSTOMER_HIERLIST in the GLOBAL analytic workspace.
Example GLOBAL Hierlist Dimension for CUSTOMER
Properties of a Hierlist Dimension
Table describes the OLAP DML properties of a hierlist dimension.
Hierlist Dimension Properties
A member_parentrel relation defines the hierarchical relationship among dimension members by identifying the parent of each member. This relation provides the essential hierarchical support for the dimension. This information is acquired from the relational dimension table. The parent relation is named dimdef_PARENTREL.
Contents of a Member_Parentrel Relation
A member_parentrel relation is a type of self-relation, in which the only valid values are dimension members. Example shows the member_parentrel relation for the CHANNEL dimension in the GLOBAL analytic workspace. The relation defines a two-level hierarchy in which 1 is the parent of 2, 3, and 4.
CHANNEL Member_Parentrel Relation in GLOBAL
Properties of a Member_Parentrel Relation
Table describes the OLAP DML properties of a member_parentrel relation.
Member_Parentrel Relation Properties
Member_gid variables improve the performance of views for the OLAP API. This integer variable identifies the depth in the hierarchy of each dimension member. This information is generated by the GROUPINGID command in the OLAP DML; refer to its entry in the Oracle OLAP DML Reference for information about its contents. The standard name for a member_gid variable is dimdef_GID.
Contents of a Member_GID Variable
Example shows the member_gid variable for the CHANNEL dimension in the GLOBAL analytic workspace. It shows that channels 2, 3, and 4 are at the base level (0) and channel 1 is one level deep (1).
CHANNEL Member_Gid in Global
Properties of a Member_Gid Variable
Table describes the OLAP DML properties of a member_gid variable.
Member_inhier variables are used to improve the performance of views for the OLAP API. This Boolean variable identifies whether a dimension member belongs to a level that is included in a particular hierarchy. The information is acquired from the OLAP Catalog metadata, and typically is useful only for dimensions with multiple hierarchies. The standard name for a member_inhier variable is dimension_INHIER.
Member_GID Variable Properties
Contents of a Member_Inhier Variable
Example shows the contents of the member_inhier variable for the CUSTOMER dimension of the GLOBAL analytic workspace. YES indicates that the dimension member is in the hierarchy; NA indicates that it is not in the hierarchy.
CUSTOMER Member_Inhier Variable in GLOBAL
Properties of a Member_Inhier Variable
Table describes the OLAP DML properties of a member_inhier variable.
Member_Inhier Variable Properties
Standard Form Metadata for Hierarchies
Standard form metadata for hierarchies is stored in these objects:
The ALL_HIERARCHIES dimension contains the names of all hierarchies in this format:workspace.dimension.hierarchy.HIERARCHY
For example: GLOBAL_AW.CUSTOMER.SHIPMENTS.HIERARCHY
ALL_HIERARCHIES is a base dimension of the ALL_OBJECTS concat dimension.
ALL_OBJECTS dimensions ALL_DESCRIPTIONS and AW_NAMES.
ALL_DESCRIPTIONS provides values for the hierarchies, but AW_NAMES does not.
ALL_DESCRIPTIONS Variable for Hierarchies
The ALL_DESCRIPTIONS variable contains short, long, and plural names for the hierarchies. All objects have a short name acquired from the metadata, but may or may not have long and plural names.
The DIM_HIERARCHIES valueset identifies the hierarchies defined for each dimension.
The DEFAULT_HIER relation identifies the default hierarchy for each dimension.
OLAP Related Interview Questions
|Informatica Interview Questions||Data Warehouse ETL Toolkit Interview Questions|
|PL/SQL Interview Questions||Data Warehousing Interview Questions|
|Testing Tools Interview Questions||SQL Database Interview Questions|
|MySQL Interview Questions||ERP Tools Interview Questions|
|Oracle 11g Interview Questions||Hyperion Financial Management Interview Questions|
|Hyperion Essbase 5 Interview Questions||Database Design Interview Questions|
|Data modeling Interview Questions||Oracle Hyperion Planning Interview Questions|
|Biztalk Esb Toolkit Interview Questions|
OLAP Related Practice Tests
|Informatica Practice Tests||PL/SQL Practice Tests|
|Data Warehousing Practice Tests||Testing Tools Practice Tests|
|SQL Database Practice Tests||MySQL Practice Tests|
|ERP Tools Practice Tests||Oracle 11g Practice Tests|
|Hyperion Financial Management Practice Tests||Hyperion Essbase 5 Practice Tests|
|Database Design Practice Tests|
The Multidimensional Data Model
The Sample Schema
Developing Java Applications For Olap
Defining A Logical Multidimensional Model
Creating An Analytic Workspace
Sql Access To Analytic Workspaces
Exploring A Standard Form Analytic Workspace
Adding Measures To A Standard Form Analytic Workspace
Predicting Future Performance
Acquiring Data From Other Sources
Administering Oracle Olap
Materialized Views For The Olap Api
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.