DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_CUBE_ATTRIBUTES

Object Details
Object Name: ALL_CUBE_ATTRIBUTES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

OLAP Attributes in the database accessible by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of OLAP Attribute
DIMENSION_NAME VARCHAR2 (128) Yes Name of owning Cube Dimension of the OLAP Attribute
ATTRIBUTE_NAME VARCHAR2 (128) Yes Name of OLAP Attribute
ATTRIBUTE_ID NUMBER
Yes Dictionary Id of the OLAP Attribute
TARGET_DIMENSION_NAME VARCHAR2 (128)
Name of Target Dimension of the OLAP Attribute
ATTRIBUTE_ROLE VARCHAR2 (17)
Special role this attribute plays (e.g. ShortDescription), or null if none
DESCRIPTION NVARCHAR2 (600)
Long Description of the OLAP Attribute
ATTRIBUTE_GROUP_NAME VARCHAR2 (200)
Name of attribute group of the OLAP Attribute
DATA_TYPE VARCHAR2 (106)
Data Type of the OLAP Attribute
DATA_LENGTH NUMBER
Yes Data Length of the OLAP Attribute
DATA_PRECISION NUMBER

Data Precision of the OLAP Attribute
DATA_SCALE NUMBER

Data Scale of the OLAP Attribute
CREATE_INDEX VARCHAR2 (3)
Create Index flag of the OLAP Attribute
IS_MULTI_LINGUAL VARCHAR2 (3)
Is MultiLingual flag of the OLAP Attribute
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      DIMENSION_NAME
,      ATTRIBUTE_NAME
,      ATTRIBUTE_ID
,      TARGET_DIMENSION_NAME
,      ATTRIBUTE_ROLE
,      DESCRIPTION
,      ATTRIBUTE_GROUP_NAME
,      DATA_TYPE
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      CREATE_INDEX
,      IS_MULTI_LINGUAL
FROM SYS.ALL_CUBE_ATTRIBUTES;

Dependencies

[top of page]

SYS.ALL_CUBE_ATTRIBUTES references the following:

SchemaSYS
ViewNLS_SESSION_PARAMETERS
TableOBJ$
TableOBJAUTH$
TableOLAP_ATTRIBUTES$
TableOLAP_DESCRIPTIONS$
TableOLAP_IMPL_OPTIONS$
TableOLAP_SYNTAX$
TableUSER$
SYS.ALL_CUBE_ATTRIBUTES is referenced by following:

SchemaPUBLIC
SynonymALL_CUBE_ATTRIBUTES