DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QPR_SET_LEVELS_V

Object Details
Object Name: QPR_SET_LEVELS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is on table qpr_set_levels which lists dimension levels eligible for stored aggregates precalculation.


[View Source]

Columns
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.
CUBE_CODE VARCHAR2 (60) Yes Identifies the price plan cube to which the dimension level and measure belong.
DIM_CODE VARCHAR2 (60) Yes Identifies the plan cube dimension whose level is selected for presummarization.
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.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_DIM_LEVEL_ID
,      CUBE_DIM_ID
,      PRICE_PLAN_ID
,      MEASURE_ID
,      CUBE_CODE
,      DIM_CODE
,      AGGMAP_NAME
,      LEVEL_SHORT_NAME
,      DIM_EXPRESSION_TYPE
FROM APPS.QPR_SET_LEVELS_V;

Dependencies

[top of page]

APPS.QPR_SET_LEVELS_V references the following:

SchemaAPPS
SynonymQPR_CUBES
ViewQPR_CUBE_DIMS_V
SynonymQPR_SET_LEVELS

APPS.QPR_SET_LEVELS_V is not referenced by any database object