[Home] [Help] [Dependency Information]
Object Name: | QPR_CUBE_DIMS |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table details the dimensions that are linked to a price plan cube.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_CUBE_DIMS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CUBE_DIM_ID |
QPR_CUBE_DIMS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PRICE_PLAN_ID
CUBE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUBE_DIM_ID | NUMBER | Yes | Unique Identifier for cube dimensions of a price plan. | |
CUBE_ID | NUMBER | Yes | Identifies the price plan cube id with which the dimension is associated. | |
PRICE_PLAN_ID | NUMBER | Yes | Identifies the price plan. | |
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 a seeded data or not. Takes values 'Y'/'N'. | |
PRICE_PLAN_DIM_ID | NUMBER | Yes | Identifies the price plan dimension. | |
DIM_SEQ_NUM | NUMBER | Indicates the order of dimension in the cube. | ||
MAPPING_VIEW_NAME | VARCHAR2 | (30) | Identifies the seeded source table or view name from which the cube dimension values are obtained. | |
MAP_COLUMN | VARCHAR2 | (30) | Identifies the seeded source table or view column name from which the cube dimension values are obtained. | |
USER_MAPPING_VIEW_NAME | VARCHAR2 | (30) | Identifies the user defined source table or view name from which the cube dimension values are obtained. | |
USER_MAP_COLUMN | VARCHAR2 | (30) | Identifies the user defined source table or view column name from which the cube dimension values are obtained. | |
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. | |
SET_LEVEL_FLAG | VARCHAR2 | (1) | Identifies if the dimension member expression is to be specified for the dimension or its level. Takes values 'Y'/'N'. If 'Y', then member expression for calculating the measure aggregation specifies Level members for inclusion or exclusion. If 'N' then member expression specifies dimension members. | |
DIM_EXPRESSION_TYPE | VARCHAR2 | (30) | Identifies if the dimension members will be included or excluded during the aggregate presummarization. | |
DIM_EXPRESSION | VARCHAR2 | (240) | Expression to identify the dimension members by value or a set by attribute value or all members, which will either be included or excluded based on the expression type. | |
DIM_OPCODE | VARCHAR2 | (30) | Specifies the default aggregation operator used to aggregate the measure against the specified cube dimension. | |
WEIGHTED_MEASURE_FLAG | VARCHAR2 | (1) | Indicates if the aggregation operator specified includes application of weight values in the calculation or not. Takes values 'Y'/'N'. Example, when aggregation operator is Weighted average, this field has 'Y' value. | |
WEIGHT_MEASURE_NAME | VARCHAR2 | (30) | Identifies the object/measure that will be used as weight values in calculations involving weighted aggregation operators like Weighted average. | |
WNAFILL | VARCHAR2 | (10) | Indicates the value that is used to replace the 'NA' weight values, which is used in weighted aggregation calculation. Takes values between 0.0 to 1.0. | |
DIVIDE_BY_ZERO_FLAG | VARCHAR2 | (1) | Indicates if a division by zero is permitted or not in the aggregation calculation. Takes values 'Y'/'N'.If 'Y' then division by zero results in an 'NA' value. If 'N' then it results in an error. | |
DECIMAL_OVERFLOW_FLAG | VARCHAR2 | (1) | Indicates if a decimal overflow is permitted or not during aggregation calculations. Takes values 'Y'/ 'N'. If 'Y', then a decimal overflow results in an 'NA' value. If 'N' then a decimal overflow results in an error. | |
NASKIP_FLAG | VARCHAR2 | (1) | Indicates if 'NA' values must be considered for aggregation or not. Takes values 'Y'/'N'. | |
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 CUBE_DIM_ID
, CUBE_ID
, PRICE_PLAN_ID
, TEMPLATE_FLAG
, SEEDED_FLAG
, PRICE_PLAN_DIM_ID
, DIM_SEQ_NUM
, MAPPING_VIEW_NAME
, MAP_COLUMN
, USER_MAPPING_VIEW_NAME
, USER_MAP_COLUMN
, AGGMAP_NAME
, SET_LEVEL_FLAG
, DIM_EXPRESSION_TYPE
, DIM_EXPRESSION
, DIM_OPCODE
, WEIGHTED_MEASURE_FLAG
, WEIGHT_MEASURE_NAME
, WNAFILL
, DIVIDE_BY_ZERO_FLAG
, DECIMAL_OVERFLOW_FLAG
, NASKIP_FLAG
, 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_CUBE_DIMS;
QPR.QPR_CUBE_DIMS does not reference any database object
QPR.QPR_CUBE_DIMS is referenced by following:
|
|
|