[Home] [Help] [Dependency Information]
Object Name: | QPR_MEASURES |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table details the cube measures and its folder information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_MEASURES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | MEASURE_ID |
QPR_MEASURES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PRICE_PLAN_ID
CUBE_ID MEASURE_PPA_CODE |
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. |
TEMPLATE_FLAG | VARCHAR2 | (1) | Indicates if the rows belong to plan template. Takes values 'Y'/'N'. | |
SEEDED_FLAG | VARCHAR2 | (1) | Indicates if the value is seeded data or not.Takes values 'Y'/'N'. | |
INCLUDE_FLAG | VARCHAR2 | (1) | Indicates if a measure is included in the plan template or not. Takes values 'Y'/'N'. | |
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. | |
USER_MAPPING_VIEW_NAME | VARCHAR2 | (30) | Identifies the user defined source table or view name from which the measure values are obtained. | |
USER_MAP_COLUMN | VARCHAR2 | (30) | Identifies the user defined source table or view column name from which the measure 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. | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | Identifies the concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the Oracle Applicaitons Consurrent Program Login ID | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the consurrent program | ||
REQUEST_ID | NUMBER | Identifies the concurrent request instance that spawned the concurrent program |
Cut, paste (and edit) the following text to query this object:
SELECT MEASURE_ID
, CUBE_ID
, PRICE_PLAN_ID
, MEASURE_PPA_CODE
, TEMPLATE_FLAG
, SEEDED_FLAG
, INCLUDE_FLAG
, 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
, USER_MAPPING_VIEW_NAME
, USER_MAP_COLUMN
, AGGMAP_NAME
, MEAS_FOLD_SHORT_NAME
, MEAS_FOLD_LONG_NAME
, MEAS_FOLD_PLURAL_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM QPR.QPR_MEASURES;
QPR.QPR_MEASURES does not reference any database object
QPR.QPR_MEASURES is referenced by following:
|
|
|