Oracle 视图 ALL_ATTRIBUTE_DIM_LVL_ATRS_AE 官方解释，作用，如何使用详细说明
本站中文解释
视图？
ALL_ATTRIBUTE_DIM_LVL_ATRS_AE视图是Oracle Essbase视图，它显示了使用数据集架构造维度层次结构的要素的属性信息。不同类型的要素具有不同的属性。这个视图包含每个属性的元数据，如名称、类型和默认值，以及视图中的每种属性的属性集的名称。
这个视图的用途是它可以为构建复杂数据及查询中视图之间的关系提供便利。它可以帮助用户了解表结构以及属性和属性集之间的关系，这些属性在创建数据集架构造的要素时也可以使用。
使用ALL_ATTRIBUTE_DIM_LVL_ATRS_AE视图的典型查询示例如下：
SELECT lvl_id, atr_id, name, type, default_val, set_name
FROM all_attribute_dim_lvl_atrs_ae
WHERE app_id = ‘My_App_ID’
AND dim_id = ‘My_Dim_ID’
AND lvl_id = ‘My_Level_ID’;
这个查询可以获取给定应用、维度和维度层次上指定要素的属性及其默认值和名称。
官方英文解释
ALL_ATTRIBUTE_DIM_LVL_ATRS_AE describes the attributes of the levels of the attribute dimensions (across all editions) accessible to the current user.
Related Views
-
DBA_ATTRIBUTE_DIM_LVL_ATRS_AEdescribes the attributes of the levels of all attribute dimensions (across all editions) in the database. -
USER_ATTRIBUTE_DIM_LVL_ATRS_AEdescribes the attributes of the levels of the attribute dimensions (across all editions) owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the attribute dimension |
|
|
|
|
Name of the attribute dimension |
|
|
|
|
Name of the attribute dimension level |
|
|
|
|
Name of the attribute determined by the level |
|
|
|
|
Role of the attribute determined by the level |
|
|
|
|
Indicates whether the attribute is minimally determined ( |
|
|
|
|
Order of the attribute in the list of attributes determined by the level |
|
|
|
|
The ID of the container where the data originates. Possible values include:
|
|
|
|
|
Name of the application edition where the attribute dimension is defined |
Note:
This view is available starting with Oracle Database release 21c, version 21.5.
See Also:
-
“DBA_ATTRIBUTE_DIM_LVL_ATRS_AE”
-
“USER_ATTRIBUTE_DIM_LVL_ATRS_AE”
