Oracle教程 2023-02-23

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

本站中文解释

是Oracle高级分析中OLAP Option模型架构中定义的层维度粒度类型属性视图。它存储了每种维度粒度类型的属性列表，例如：表中定义的维度、柱状图定义的层、细胞定义的度量等。这些属性可以动态更改，并且视图将其更新。它拥有所有这些维度属性的完整列表，可以查看和分析任何维度的粒度类型的属性，进而发现潜在的可视化趋势。
要使用ALL_ATTRIBUTE_DIM_LEVELS视图，可以使用以下查询语句：
SELECT * FROM ALL_ATTRIBUTE_DIM_LEVELS WHERE OWNER= ‘OWNER_NAME’ AND LEVEL_NAME= ‘LEVEL_NAME‘;
其中，OWNER_NAME是创建维度层粒度类型的用户名，LEVEL_NAME是查询的维度属性名称。
该视图在维度模型设计时很有用，从而找到维度之间的关系。它还可以用于找出与维度层类型有关的属性，以便进行分析和数据可视化。

官方英文解释

ALL_ATTRIBUTE_DIM_LEVELS describes the levels of the attribute dimensions accessible to the current user.

Related Views

DBA_ATTRIBUTE_DIM_LEVELS describes the levels of all attribute dimensions in the database.
USER_ATTRIBUTE_DIM_LEVELS describes the levels of the attribute dimensions owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the attribute dimension
`DIMENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the attribute dimension
`LEVEL_NAME`	`VARCHAR2(128)`		Name of the attribute dimension level
`SKIP_WHEN_NULL`	`VARCHAR2(1)`		Indicates whether to skip the level when the key is NULL; the value can be `Y` or `N`.
`LEVEL_TYPE`	`VARCHAR2(10)`		Type of attribute dimension level
`MEMBER_NAME_EXPR`	`CLOB`	`NOT NULL`	Expression representing the level member name
`MEMBER_CAPTION_EXPR`	`CLOB`		Expression representing the level member caption, or NULL if not specified
`MEMBER_DESCRIPTION_EXPR`	`CLOB`		Expression representing the level member description, or NULL if not specified
`ORDER_NUM`	`NUMBER`	`NOT NULL`	Order of the level in the list of attribute dimension levels
`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).

本站中文解释

官方英文解释

相关推荐