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

VIEW: APPS.ZPB_OS_MEAS_DIMS_V

Object Details
Object Name: ZPB_OS_MEAS_DIMS_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 dimensionality information for one or more measures of a business area. Each dimension in the set of the measure's dimensionality will have two records in the result set : one specifying the dimension's member_column name and the other specifying the dimension's short name column in the olap dimension table. The user may bind the measure_name or instance_id columns to limit the number of measures displayed. To return only one row per dimension, bind the column_type column to either 'MEMBER_COLUMN' or 'SNAME_COLUMN'. 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
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
DIMENSION_NAME VARCHAR2 (240)
Dimension name
DIM_TABLE_NAME VARCHAR2 (60)
Name of the olap dimension table
MEASURE_ID NUMBER
Yes Primary key of this table
Query Text

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


SELECT INSTANCE_ID
,      MEASURE_NAME
,      DIMENSION_NAME
,      DIM_TABLE_NAME
,      MEASURE_ID
FROM APPS.ZPB_OS_MEAS_DIMS_V;

Dependencies

[top of page]

APPS.ZPB_OS_MEAS_DIMS_V references the following:

SchemaAPPS
SynonymZPB_CUBES
SynonymZPB_CUBE_DIMS
ViewZPB_DIMENSIONS_VL
SynonymZPB_MEASURES
SynonymZPB_TABLES

APPS.ZPB_OS_MEAS_DIMS_V is not referenced by any database object