Oracle 视图 ALL_ANALYTIC_VIEW_LVLGRPS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_ANALYTIC_VIEW_LVLGRPS 是 Oracle 中的一个视图，它的用途是，通过每个用户的权限，来查询analytic view的等级分组定义，最多支持8组分组，即可提供多种查询维度，可以方便调整约束以及对某维度进行抽取，以及关联和多维查询中的结果改变等。
即，可通过 ALL_ANALYTIC_VIEW_LVLGRPS 视图来查询和管理用户拥有的 视图分组等级权限。
要使用此视图，可以执行如下查询：
SELECT *
FROM ALL_ANALYTIC_VIEW_LVLGRPS
WHERE USERNAME=’用户名’;
此查询将返回用户的视图分组等级的详细信息。
官方英文解释
ALL_ANALYTIC_VIEW_LVLGRPS describes the analytic view measure and level groups of the analytic views accessible to the current user.
Related Views
DBA_ANALYTIC_VIEW_LVLGRPSdescribes the analytic view measure and level groups of all analytic views in the database.USER_ANALYTIC_VIEW_LVLGRPSdescribes the analytic view measure and level groups of the analytic views owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
| Owner of the analytic view | |
|
| Name of the analytic view | |
|
| Type of the materialized view; one of the following:
| |
|
| Alias of the attribute dimension in the group | |
|
| Alias of the hierarchy associated with the attribute dimension in the group | |
|
| Name of the level in the hierarchy in the group | |
|
| Names of the measures in the group | |
MAT_TABLE_OWNERFoot 1 | VARCHAR2(128) | If the schema for an aggregation table is specified for the analytic view, then the schema owner; otherwise NULL | |
MAT_TABLE_NAMEFoot 1 | VARCHAR2(128) | If an aggregation table is specified for an analytic view, then the name of the materialized table; otherwise NULL | |
|
| Order of the groups in the analytic view | |
|
| Order of the levels and measures in the group | |
|
| The ID of the container where the data originates. Possible values include:
|
Footnote 1 This column is available starting with Oracle Database 21c.
See Also:
“DBA_ANALYTIC_VIEW_LVLGRPS”
“USER_ANALYTIC_VIEW_LVLGRPS”
编辑：568数据
标签：视图,维度,等级,用户,多维