Oracle 视图 ALL_ANALYTIC_VIEW_DIM_CLS_AE 官方解释，作用，如何使用详细说明
本站中文解释
ALL_ANALYTIC_VIEW_DIM_CLS_AE是Oracle视图，即Oracle中的维度及分类分析视图，它主要用于数据仓库中的维度及分类的视图的清晰度及业务意义的概括，以及基于视图收集的数据做出业务决策。
它主要用于数据仓库中的维度及分类视图定义维度属性，比如类别、地区、尺寸等，以及建立分层结构来存储数据，以便在视图中统一查看关联的维度及分类信息，也便于分析视图中数据间的关系，例如地区与类别、尺寸之间的关系等。
使用ALL_ANALYTIC_VIEW_DIM_CLS_AE时，可以对视图中的维度及分类属性做一个全面的描述，同时还可以进行业务分析和关联，例如可以分析不同地区的销售额和利润，以及多个维度属性如地区、类别、尺寸之间的关系等。
官方英文解释
ALL_ANALYTIC_VIEW_DIM_CLS_AE describes the classifications of the attribute dimensions in the analytic views (across all editions) accessible to the current user.
Related Views
-
DBA_ANALYTIC_VIEW_DIM_CLS_AEdescribes the classifications of the attribute dimensions in all analytic views (across all editions) in the database. -
USER_ANALYTIC_VIEW_DIM_CLS_AEdescribes the classifications of the attribute dimensions in the analytic views (across all editions) 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 |
|
|
|
Alias of the attribute dimension in the analytic view |
|
|
|
|
Classification associated with the attribute dimension |
|
|
|
|
Value of the classification or NULL if not specified |
|
|
|
|
|
|
|
|
|
|
Order of the classification in the list of classifications associated with the attribute dimension |
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
|
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.
See Also:
-
“DBA_ANALYTIC_VIEW_DIM_CLS_AE”
-
“USER_ANALYTIC_VIEW_DIM_CLS_AE”
