[Home] [Help] [Dependency Information]
Object Name: | QPR_CUBE_DIMS_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_cube_dims which details the dimensions that are linked to a price plan cube.
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. | |
PRICE_PLAN_DIM_ID | NUMBER | Yes | Identifies the price plan dimension. | |
DIM_SEQ_NUM | NUMBER | Indicates the order of dimension in the cube. | ||
DIM_CODE | VARCHAR2 | (60) | Yes | Code to identify the dimension of a plan. |
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. | |
LOWEST_LVL | VARCHAR2 | (30) | Indicates the lowest level in the dimension hierarchy. | |
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'. |
Cut, paste (and edit) the following text to query this object:
SELECT CUBE_DIM_ID
, CUBE_ID
, PRICE_PLAN_ID
, PRICE_PLAN_DIM_ID
, DIM_SEQ_NUM
, DIM_CODE
, MAPPING_VIEW_NAME
, MAP_COLUMN
, LOWEST_LVL
, 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
FROM APPS.QPR_CUBE_DIMS_V;
|
|
|