Oracle教程 2023-02-27

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

本站中文解释

视图

ALL_CUBE_ATTRIBUTES 视图是Oracle的一个数据字典视图，用于查询”维度属性”的信息。它可以用来描述Cube中的维度及其属性，以及在指定Cube中查看每个属性的属性信息。

使用方法如下：

SELECT A.CUBE_NAME, A.ATTRIB_NAME, B.ATTRIB_TYPE
FROM ALL_CUBE_ATTRIBUTES A
JOIN ALL_CUBE_ATTRIB_TYPES B
ON (A.ATTRIB_TYPE_ID = B.ATTRIB_TYPE_ID)
WHERE A.CUBE_NAME = ‘你的Cube名称’;

上述查询将返回以下内容：Cube名称、属性名称、属性类型。因此，可以查看要查询的Cube中的维度及其属性信息。

官方英文解释

ALL_CUBE_ATTRIBUTES describes the attributes for the OLAP cube dimensions accessible to the current user.

Related Views

DBA_CUBE_ATTRIBUTES describes the attributes for all OLAP cube dimensions in the database.
USER_CUBE_ATTRIBUTES describes the attributes for the OLAP cube 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 cube dimension
`DIMENSION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of a cube dimension (such as `TIME`)
`ATTRIBUTE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of an attribute of the dimension (such as `LONG_DESCRIPTION` or `END_DATE`)
`ATTRIBUTE_ID`	`NUMBER`	`NOT NULL`	ID of the attribute of the dimension
`TARGET_DIMENSION_NAME`	`VARCHAR2(128)`		Name of the target dimension of the attribute
`ATTRIBUTE_ROLE`	`VARCHAR2(17)`		Special role this attribute plays; NULL if none: `SHORT_DESCRIPTION` `LONG_DESCRIPTION` `DESCRIPTION` `TIME_SPAN` `END_DATE`
`DESCRIPTION`	`NVARCHAR2(300)`		Description of the attribute in the session language
`ATTRIBUTE_GROUP_NAME`	`VARCHAR2(200)`		Name of the attribute group
`DATA_TYPE`	`VARCHAR2(106)`		Data type of the attribute, (such as `VARCHAR2` or `FLOAT`)
`DATA_LENGTH`	`NUMBER`	`NOT NULL`	Length of a text data type
`DATA_PRECISION`	`NUMBER`		Precision of a numeric data type
`DATA_SCALE`	`NUMBER`		Scale of a numeric data type
`CREATE_INDEX`	`VARCHAR2(3)`		Create index flag of the OLAP attribute. Possible values: `YES`: The attribute is represented in the AW as a relation. Setting `CreateIndex="True"` in the metadata guarantees that it will be represented in the AW as a relation. `NO`: The attribute is not represented in the AW as a relation. Setting `CreateIndex="False"` in the metadata does not guarantee that it will be represented in the AW a a variable; the system will make that determination.
`IS_MULTI_LINGUAL`	`VARCHAR2(3)`		Shows the setting for the `IsMultiLingual` flag of the OLAP Atttribute. Possible values: `YES`: The attribute is set as multilingual. Setting `IsMultiLingual` to `True` in the metadata means that the attribute can have a value per language instead of a single value. `NO`: The attribute is not set as multilingual. Setting `IsMultiLingual` to `False` in the metadata means that the attribute has only one value, independent of language.

本站中文解释

官方英文解释

相关推荐