Levels are the basis of dimension hierarchies. A level belongs to one or more hierarchies. These objects support level definitions:
A levellist dimension stores the names of all levels for all hierarchies defined for a particular dimension. The information is acquired from the OLAP Catalog. This text dimension typically has the name dimdef_LEVELLIST.
Contents of a Levellist Dimension
Example shows the CUSTOMER levellist dimension in GLOBAL, which contains the levels for both the SHIPMENTS and MARKET_SEGMENT hierarchies.
CUSTOMER Levellist Dimension in GLOBAL
Properties of a Levellist Dimension
Table describes the properties of a levellist dimension.
Levellist Dimension Properties
A member_levelrel relation identifies the level of each dimension member. It facilitates the selection of dimension members by level. The information is acquired from the relational fact tables. This text dimension typically has the name dimdef_LEVELREL.
Contents of a Level Relation
Example shows the CUSTOMER member_levelrel relation in GLOBAL.
CUSTOMER Member_Levelrel Relation in GLOBAL
Properties of a Member_Levelrel Relation
Table describes the OLAP DML properties of a member_levelrel relation.
Member_Levelrel Relation Properties
Member_familyrel relations improve the performance of views for Oracle Discoverer. It provides a crosstab with the full parentage of each dimension member within a single row. The standard name for a family relation is dimdef_FAMILYREL.
Contents of a Family Relation
Example shows the CUSTOMER family relation in GLOBAL.
CUSTOMER Family Relation in GLOBAL
Properties of a Member_Familyrel Relation
Table describes the OLAP DML properties of a member_familyrel relation.
Standard Form Metadata for Levels
Standard form metadata for levels is stored in these objects:
Member_Familyrel Relation Properties
The ALL_LEVELS dimension contains the names of all levels in this format:workspace.dimension.level.LEVEL
For example: GLOBAL_AW.TIME.Quarter.LEVEL
ALL_LEVELS is a base dimension of the ALL_OBJECTS concat dimension.
ALL_OBJECTS dimensions ALL_DESCRIPTIONS and AW_NAMES.
ALL_DESCRIPTIONS provides values for the levels, but AW_NAMES does not.
ALL_DESCRIPTIONS Variable for Levels
The ALL_DESCRIPTIONS variable contains short, long, and plural names for the levels. All levels have a short name acquired from the metadata, but may or may not have long and plural names.
The DIM_LEVELS valueset identifies the levels defined 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.