ALL_ANALYTIC_VIEW_BASE_MEAS

ALL_ANALYTIC_VIEW_BASE_MEAS describes the base measures in the analytic views accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the analytic view
ANALYTIC_VIEW_NAME VARCHAR2(128) NOT NULL Name of the analytic view
MEASURE_NAME VARCHAR2(128)   Name of the analytic view base measure
TABLE_ALIAS VARCHAR2(128)   Alias of the table or view in the USING clause to which the column belongs
COLUMN_NAME VARCHAR2(128) NOT NULL Column name in the table or view on which this measure is defined
MEAS_EXPRESSION CLOB   Text of the expression for the measure
QUAL_MEAS_EXPRESSION CLOB   Fully-qualified text of the expression for the measure
AGGR_FUNCTION VARCHAR2(128)   Aggregation operator specified for this measure or NULL if not specified
AGGR_GROUP_NAME VARCHAR2(128)   Aggregation function group name specified for this measure or NULL if not specified
ORDER_NUM NUMBER NOT NULL Order number of the base measure in the list of measures in the analytic view
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: