Oracle 视图 ALL_ATTRIBUTE_DIM_LVL_ATRS_AE 官方解释,作用,如何使用详细说明
  iDU31ygkXmx7 2023年11月21日 17 0

本站中文解释

视图?

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_AE describes the attributes of the levels of all attribute dimensions (across all editions) in the database.

  • USER_ATTRIBUTE_DIM_LVL_ATRS_AE describes the attributes of the levels of the attribute dimensions (across all editions) owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the attribute dimension

DIMENSION_NAME

VARCHAR2(128)

Name of the attribute dimension

LEVEL_NAME

VARCHAR2(128)

Name of the attribute dimension level

ATTRIBUTE_NAME

VARCHAR2(128)

Name of the attribute determined by the level

ROLE

VARCHAR2(4)

Role of the attribute determined by the level

IS_MINIMAL_DTM

VARCHAR2(1)

Indicates whether the attribute is minimally determined (Y) or not (N)

ORDER_NUM

NUMBER

Order of the attribute in the list of attributes determined by the level

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 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”

【版权声明】本文内容来自摩杜云社区用户原创、第三方投稿、转载,内容版权归原作者所有。本网站的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@moduyun.com

  1. 分享:
最后一次编辑于 2023年11月21日 0

暂无评论

iDU31ygkXmx7