eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.ZPB_OS_MEASURES_V

Object Details

Object Name:	ZPB_OS_MEASURES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view returns information for one or more measures of a business area. The information includes measure name, measure type, currency type, and name of the olap fact-table that stores the data for a particular measure. The user should bind the instance_id column to see all measures associated with a particular instance_id. Binding either the measure_name or measure_id column will result in information for one particular measure. Before executing this query the following two environment variables should be initialized:sys_context('ZPB_CONTEXT', 'business_area_id') and userenv('Lang').

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MEASURE_ID	NUMBER		Yes	Primary key of this table
INSTANCE_ID	NUMBER			Instance id of measure. Each instance may have more than one measure associated with it (Data, Format, Annotation, Write Security)
MEASURE_NAME	VARCHAR2	(255)		Name of measure
MEASURE_TYPE	VARCHAR2	(64)		Type of measure (SHARED_DATA, SHARED_CALC, SHARED_WRITE_SECURITY etc)
CURRENCY_TYPE	VARCHAR2	(30)		Currency type of measure (Local, Selected, or Functional)
SELECTED_CURRENCY	VARCHAR2	(30)		If the currency_type column is set to Selected, this column specified the selected currency
OLAP_FACT_TABLE	VARCHAR2	(60)	Yes	Cube name, same as olap fact-table name
OLAP_FACT_TABLE_COLUMN	VARCHAR2	(60)	Yes	Name of column corresponding to this measure in the olap table function that exposes its data

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MEASURE_ID
,      INSTANCE_ID
,      MEASURE_NAME
,      MEASURE_TYPE
,      CURRENCY_TYPE
,      SELECTED_CURRENCY
,      OLAP_FACT_TABLE
,      OLAP_FACT_TABLE_COLUMN
FROM APPS.ZPB_OS_MEASURES_V;

Dependencies

[top of page]

APPS.ZPB_OS_MEASURES_V references the following:

APPS: ZPB_COLUMNS; ZPB_CUBES; ZPB_MEASURES

APPS.ZPB_OS_MEASURES_V is not referenced by any database object