eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.QPR_CUBES_V

Object Details

Object Name:	QPR_CUBES_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 is a view on qpr_cubes table which contains the cube definitions of the price plan.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUBE_ID	NUMBER		Yes	Unique Identifier for a price plan cube.
CUBE_CODE	VARCHAR2	(60)	Yes	Unique code for a price plan cube.
PRICE_PLAN_ID	NUMBER		Yes	Identifies the price plan.
CUBE_PPA_CODE	VARCHAR2	(30)	Yes	Unique code to identify a cube. This value is same across plans for a given cube value.
CUBE_SHORT_NAME	VARCHAR2	(30)		Short name of the cube.
CUBE_LONG_NAME	VARCHAR2	(240)		Long name of the cube.
CUBE_PLURAL_NAME	VARCHAR2	(240)		Plural name of the cube.
CUBE_AUTO_SOLVE_FLAG	VARCHAR2	(1)		Indicates if the aggregation solving must be run automatically when building the cube or not. Takes values 'Y'/'N'.
DEFAULT_DATA_TYPE	VARCHAR2	(30)		Indicates the default data type for the measures of the cube.
PARTITION_HIER	VARCHAR2	(30)		Indicates the hierarchy that will be used for partitioning the cube data. All the dimension members belonging to the hierarchy will be saved to same partition.
PARTITION_LEVEL	VARCHAR2	(30)		Identifies the level code of the mentioned hierarchy that will be used to partition the cube. All the dimension members of this level and the dimension members of its sublevels will also tbe stroed in a partition.
SPARSE_TYPE_CODE	VARCHAR2	(3)		Specifies the type of composite to manage sparsity.
USE_GLOBAL_INDEX_FLAG	VARCHAR2	(1)		Indicates if a single composite/index is used for all measures of the cube or not. Takes values 'Y'/'N'. Select 'Y' only when the measures share the same sparsity and regular composites are used.
AGGMAP_NAME	VARCHAR2	(30)		Name of the aggregation map for the measures, 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.

Query Text

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


SELECT CUBE_ID
,      CUBE_CODE
,      PRICE_PLAN_ID
,      CUBE_PPA_CODE
,      CUBE_SHORT_NAME
,      CUBE_LONG_NAME
,      CUBE_PLURAL_NAME
,      CUBE_AUTO_SOLVE_FLAG
,      DEFAULT_DATA_TYPE
,      PARTITION_HIER
,      PARTITION_LEVEL
,      SPARSE_TYPE_CODE
,      USE_GLOBAL_INDEX_FLAG
,      AGGMAP_NAME
,      AGGMAP_CACHE_STORE
,      AGGMAP_CACHE_NA
FROM APPS.QPR_CUBES_V;

Dependencies

[top of page]

APPS.QPR_CUBES_V references the following:

APPS: QPR_CUBES

APPS.QPR_CUBES_V is not referenced by any database object