Each measure is defined by two workspace objects: a variable and a formula.
A measure variable initially contains only base-level data, which is typically acquired from a relational fact table. If you deploy an aggregation plan, then the variable also contains precalculated aggregate levels.
A measure variable has a DECIMAL data type unless you redefined it before loading data during the initial build. The standard name for a measure variable is measuredef_VARIABLE. Table describes its properties.
A measuredef formula calculates the aggregate data using a set of aggregation rules stored in an aggmap. Its standard name is the name of the measure. Table describes its properties.
Measuredef Formula Properties
Standard Form Metadata for Measures
Standard form metadata for measures is stored in these objects:
The ALL_MEASURES dimension contains the names of all measures in this format:workspace.cube.measure.MEASURE
For example: GLOBAL_AW.UNITS_CUBE.UNITS.MEASURE
ALL_MEASURES is a base dimension of the ALL_OBJECTS concat dimension.
ALL_OBJECTS dimensions ALL_DESCRIPTIONS and AW_NAMES, so these catalogs have an entry for each measure.
ALL_DESCRIPTIONS Variable for Measures
The ALL_DESCRIPTIONS variable contains short, long, and plural names for the measures. All objects have a short name acquired from the metadata, but may or may not have long and plural names.
AW_NAMES Variable for Measures
The AW_NAMES measure provides a name for each measure in this format:schema.workspace!measure
For example: GLOBAL_AW.GLOBAL!UNITS
The CUBE_MEASURES valueset identifies the measures for each cube.
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.