CUBES Schema Rowset

Standard Mapping

The CUBES schema rowset returns metadata about the SAS cubes that can be accessed by the SAS OLAP Provider. Each row in the CUBES schema rowset corresponds to one cube that is available in the provider.
The following table describes the columns that are available in the CUBES schema rowset.
Standard Mapping
Column Name
Type Indicator
Mapped Value
Restrictions Supported?
CATALOG_NAME
DBTYPE_WSTR
Name of the catalog that contains this cube.
Yes
SCHEMA_NAME
DBTYPE_WSTR
Name of the schema that contains this cube.
Yes
CUBE_NAME
DBTYPE_WSTR
Name of this cube.
Yes
CUBE_GUID
DBTYPE_GUID
GUID of this cube.
No
CREATED_ON
DBTYPE_DBTIMESTAMP
Date and time that this cube was created.
No
LAST_SCHEMA_UPDATE
DBTYPE_DBTYPESTAMP
Date and time that this cube's schema was last updated.
No
SCHEMA_UPDATED_BY
DBTYPE_WSTR
User ID of the person who last updated this cube's schema.
No
LAST_DATA_UPDATE
DBTYPE_DBTIMESTAMP
Date and time that this cube was last updated.
No
DATA_UPDATED_BY
DBTYPE_WSTR
User ID of the person who last updated this cube.
No
DESCRIPTION
DBTYPE_WSTR
Description of this cube.
No
Note: For more information about restrictions, see How to Restrict the Rows That Are Returned.