ALL_ANALYTIC_VIEW_LVLGRPS

ALL_ANALYTIC_VIEW_LVLGRPS describes the analytic view measure and level groups of the analytic views accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the analytic view
ANALYTIC_VIEW_NAME VARCHAR2(128)   Name of the analytic view
CACHE_TYPE VARCHAR2(128)  

Type of the materialized view; one of the following:

  • DYNAMIC

  • MATERIALIZED (the default value)

DIMENSION_ALIAS VARCHAR2(128)   Alias of the attribute dimension in the group
HIER_ALIAS VARCHAR2(128)   Alias of the hierarchy associated with the attribute dimension in the group
LEVEL_NAME VARCHAR2(128)   Name of the level in the hierarchy in the group
MEASURE_NAME VARCHAR2(128)   Names of the measures in the group
MAT_TABLE_OWNER VARCHAR2(128)   If the schema for an aggregation table is specified for the analytic view, then the schema owner; otherwise NULL
MAT_TABLE_NAME VARCHAR2(128)   If an aggregation table is specified for an analytic view, then the name of the materialized table; otherwise NULL
AV_LVLGRP_ORDER NUMBER   Order of the groups in the analytic view
LEVEL_MEAS_ORDER NUMBER   Order of the levels and measures in the group
ORIGIN_CON_ID NUMBER  

The ID of the container where the data originates. Possible values include:

  • 0: This value is used for rows in non-CDBs. This value is not used for CDBs.

  • n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root).

See Also: