Oracle 视图 ALL_ANALYTIC_VIEW_LVLGRPS_AE 官方解释，作用，如何使用详细说明

本站中文解释

ALL_ANALYTIC_VIEW_LVLGRPS_AE是一个只读视图，用于查询用户所拥有的每个分析视图等级分组中的属性。它由所有ALL_ANALYTIC_VIEW_LVLGRPS_AE列组成：

VIEW_LEVEL_GROUP：分析视图级别组的名称
ATTRIBUTE_ORDINAL：属性序号（从1开始）
ATTRIBUTE_NAME：属性的名称
ATTRIBUTE_LABEL：在UI/展示中用于显示属性的标签
ATTRIBUTE_DESC：关于属性的可读性描述
DATATYPE：属性类型
ATTRIBUTE_ORDER：应用于每个属性的定义排序顺序号（从1）

可以通过以下查询使用ALL_ANALYTIC_VIEW_LVLGRPS_AE：

SELECT * FROM ALL_ANALYTIC_VIEW_LVLGRPS_AE view where view.VIEW_LEVEL_GROUP = ‘某等级组’;

此查询用于查询具有指定等级组的所有属性。

官方英文解释

ALL_ANALYTIC_VIEW_LVLGRPS_AE describes the analytic view measure and level groups of the analytic views (across all editions) accessible to the current user.

Related Views

DBA_ANALYTIC_VIEW_LVLGRPS_AE describes the analytic view measure and level groups of all analytic views (across all editions) in the database.
USER_ANALYTIC_VIEW_LVLGRPS_AE describes the analytic view measure and level groups of the analytic views (across all editions) owned by the current user. This view does not display the OWNER column.

Column	Datatype	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).
`EDITION_NAME`	`VARCHAR2(128)`	Name of the application edition where the analytic view is defined

Note:

This view is available starting with Oracle Database release 21c, version 21.5.