[Home] [Help] [Dependency Information]
Object Name: | QPR_MEASURES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is on table qpr_measures which details the cube measures and its folder information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEASURE_ID | NUMBER | Yes | Unique identifier for the price plan cube measure value. | |
CUBE_ID | NUMBER | Yes | Identifies the price plan cube to which the measure belongs. | |
PRICE_PLAN_ID | NUMBER | Yes | Unique identifier of the price plan. | |
MEASURE_PPA_CODE | VARCHAR2 | (30) | Yes | Unique code to identify the measure. This code will be same across plans for a given measure. |
MEAS_CREATION_SEQ_NUM | NUMBER | Defines the solve sequence of measure in a cube. This is same across price plans for a given cube. | ||
MEAS_TYPE | VARCHAR2 | (30) | Indicates if a measure is calculated or sourced directly from source table. | |
MEAS_SHORT_NAME | VARCHAR2 | (30) | Short name of the measure. | |
MEAS_LONG_NAME | VARCHAR2 | (240) | Long name of the measure. | |
MEAS_PLURAL_NAME | VARCHAR2 | (240) | Plural name of the measure. | |
MEAS_DATA_TYPE | VARCHAR2 | (30) | Indicates the data type of a measure. | |
MEAS_AUTO_SOLVE | VARCHAR2 | (20) | Indicates the solve method of a measure. Takes values 'AUTO_SOLVE'/'NO_AUTO_SOLVE'/'DEFAULT'. If method is AUTO_SOLVE then the aggregate value of the measure is calculated when the cube is built and the aggregation definition specified for the measure is used. If method is NO_AUTO_SOLVE then measure aggregation is not calculated when cube is built. If method is DEFAULT then aggregate value is calculated using the cube's aggregation definition. | |
CAL_MEAS_EXPRESSION_TEXT | VARCHAR2 | (1000) | Contains the expression to solve for calculated measures. | |
MAPPING_VIEW_NAME | VARCHAR2 | (30) | Identifies the source table or view name from which the level values are obtained. | |
MAP_COLUMN | VARCHAR2 | (30) | Identifies the source table or view column name from which the level values are obtained. | |
AGGMAP_NAME | VARCHAR2 | (30) | Name of the aggregation map for the measure, which contains a set of rules for distributing data throughout the levels of a dimension hierarchy. Aggmaps can be used either for aggregation or allocation. | |
MEAS_FOLD_SHORT_NAME | VARCHAR2 | (30) | Short name of the measure folder. Measure folder is a logical grouping of measures of cube so that they can be easily identified and accessed. | |
MEAS_FOLD_LONG_NAME | VARCHAR2 | (240) | Long name of the measure folder. | |
MEAS_FOLD_PLURAL_NAME | VARCHAR2 | (240) | Plural name of the measure folder. |
Cut, paste (and edit) the following text to query this object:
SELECT MEASURE_ID
, CUBE_ID
, PRICE_PLAN_ID
, MEASURE_PPA_CODE
, MEAS_CREATION_SEQ_NUM
, MEAS_TYPE
, MEAS_SHORT_NAME
, MEAS_LONG_NAME
, MEAS_PLURAL_NAME
, MEAS_DATA_TYPE
, MEAS_AUTO_SOLVE
, CAL_MEAS_EXPRESSION_TEXT
, MAPPING_VIEW_NAME
, MAP_COLUMN
, AGGMAP_NAME
, MEAS_FOLD_SHORT_NAME
, MEAS_FOLD_LONG_NAME
, MEAS_FOLD_PLURAL_NAME
FROM APPS.QPR_MEASURES_V;
APPS.QPR_MEASURES_V is not referenced by any database object
|
|
|