[Home] [Help] [Dependency Information]
Object Name: | QPR_SET_LEVELS |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table lists dimension levels eligible for the stored aggregates precalculation. The measure aggregation values are pre calculated and stored as part of the cube build process there by improving the query time.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_SET_LEVELS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SET_DIM_LEVEL_ID |
QPR_SET_LEVELS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRICE_PLAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_DIM_LEVEL_ID | NUMBER | Yes | Unique Identifier for the set level values. | |
CUBE_DIM_ID | NUMBER | Yes | Identifies the cube dimension whose level is selected for presummarization. | |
PRICE_PLAN_ID | NUMBER | Yes | Unique identifier of the price plan. | |
MEASURE_ID | NUMBER | Identifies the cube measure that is precomputed. | ||
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'. | |
AGGMAP_NAME | VARCHAR2 | (30) | Name of the aggregation map, 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. | |
LEVEL_SHORT_NAME | VARCHAR2 | (30) | Short name of the dimension level selected for presummarization. | |
DIM_EXPRESSION_TYPE | VARCHAR2 | (30) | Identifies if the level members will be included or excluded during the presummarization. | |
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 SET_DIM_LEVEL_ID
, CUBE_DIM_ID
, PRICE_PLAN_ID
, MEASURE_ID
, TEMPLATE_FLAG
, SEEDED_FLAG
, AGGMAP_NAME
, LEVEL_SHORT_NAME
, DIM_EXPRESSION_TYPE
, 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_SET_LEVELS;
QPR.QPR_SET_LEVELS does not reference any database object
QPR.QPR_SET_LEVELS is referenced by following:
|
|
|