Home > OLAP Metadata in the Database > Data Dictionary Views for OLAP
![]() Previous |
![]() Next |
You can query the data dictionary for information about dimensional objects. Table: Static Data Dictionary Views for OLAP provides brief descriptions of the ALL
views. There are corresponding DBA
and USER
views.
Static Data Dictionary Views for OLAP
View | Description |
---|---|
Describes the visibility of the attributes for cube dimensions. |
|
Describes the attributes for cube dimensions. |
|
Describes the cube build processes and maintenance scripts. |
|
Describes the calculated members (keys) for cube dimensions. |
|
Describes the cube dimension levels. |
|
Describes the models for cube dimensions. |
|
Describes the columns of the system-generated relational views of cube dimensions. |
|
Describes the system-generated relational views of OLAP dimensions. |
|
Describes the dimension order of the OLAP cubes. |
|
Describes the cube dimensions. |
|
Describes the hierarchy levels for cube dimensions. |
|
Describes the columns of relational hierarchy views of cube dimensions. |
|
Describes the hierarchies for cube dimensions. |
|
Describes the OLAP dimension hierarchies. |
|
Describes the measures in the OLAP cubes. |
|
Describes the columns of the relational views of OLAP cubes. |
|
Describes the system-generated relational views of OLAP cubes. |
|
Describes the OLAP cubes. |
|
Describes the contents of OLAP measure folders. |
|
Describes the OLAP measure folders. |
Among the static views of the database data dictionary are several that provide information about analytic workspaces. Table: Static Data Dictionary Views for Analytic Workspaces provides brief descriptions of them. There are corresponding DBA
and USER
views.
Static Data Dictionary Views for Analytic Workspaces
View | Description |
---|---|
|
Describes all analytic workspaces accessible to the current user. |
|
Describes the current objects in all analytic workspaces accessible to the current user. |
|
Describes the properties defined in all analytic workspaces accessible to the current user. |
|
Describes the page spaces currently in use by all analytic workspaces accessible to the current user. |