[Home] [Help] [Dependency Information]
Object Name: | QPR_MEAS_AGGRS_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_meas_aggrs which details measure aggregation rules that can override cube default.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEAS_AGG_ID | NUMBER | Yes | Unique Identifier for cube measure aggregation calculation. | |
CUBE_DIM_ID | NUMBER | Yes | Identifies the cube dimension for which aggregation rule applies. | |
MEASURE_ID | NUMBER | Yes | Identifies the cube measure for which the aggregation calculation is specified. | |
PRICE_PLAN_ID | NUMBER | Yes | Identifies the price plan. | |
CUBE_ID | NUMBER | Yes | Identifies the price plan cube id with which the measure is associated. | |
DIM_CODE | VARCHAR2 | (60) | Yes | Code to identify the cube dimension. |
DIM_SEQ_NUM | NUMBER | Yes | Indicates the solve sequence of dimensions in the cube. | |
OVERRIDE_FLAG | VARCHAR2 | (1) | Specifies that the Measure will override the parent cube's default aggregation | |
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. | |
AGGMAP_CACHE_STORE | VARCHAR2 | (10) | Indicates if the aggregated values are cached or not. Takes values 'STORE'/ 'NOSTORE' indicating caching and no caching respectively. | |
AGGMAP_CACHE_NA | VARCHAR2 | (5) | Indicates if 'NA' values resulting from aggregation operation are cached or not. Takes values 'NA'/'NONA' indicating caching and nocaching respectively. | |
DIM_OPCODE | VARCHAR2 | (30) | Specifies the aggregation operator used to aggregate the measure against the specified cube dimension. | |
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) | Aggregation 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. | |
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 MEAS_AGG_ID
, CUBE_DIM_ID
, MEASURE_ID
, PRICE_PLAN_ID
, CUBE_ID
, DIM_CODE
, DIM_SEQ_NUM
, OVERRIDE_FLAG
, AGGMAP_NAME
, AGGMAP_CACHE_STORE
, AGGMAP_CACHE_NA
, DIM_OPCODE
, SET_LEVEL_FLAG
, DIM_EXPRESSION_TYPE
, DIM_EXPRESSION
, WEIGHTED_MEASURE_FLAG
, WEIGHT_MEASURE_NAME
, WNAFILL
, DIVIDE_BY_ZERO_FLAG
, DECIMAL_OVERFLOW_FLAG
, NASKIP_FLAG
FROM APPS.QPR_MEAS_AGGRS_V;
APPS.QPR_MEAS_AGGRS_V is not referenced by any database object
|
|
|