MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 22: OLE DB for OLAP Objects and Schema Rowsets
The CUBES rowset contains information about the available cubes in a schema (or the catalog, if the provider does not support schemas). It has the structure described in the following table.
The default sort order is CATALOG_NAME, SCHEMA_NAME, and CUBE_NAME.
| Column name | Type indicator | Description |
| CATALOG_NAME | DBTYPE_WSTR | Optional. The name of the catalog to which this cube belongs. NULL if the provider does not support catalogs. |
| SCHEMA_NAME | DBTYPE_WSTR | Optional. The name of the schema to which this cube belongs. NULL if the provider does not support schemas. |
| CUBE_NAME | DBTYPE_WSTR | Required. Name of the cube. |
| CUBE_TYPE | DBTYPE_WSTR | Required. Cube type. One of the following, or a provider-specific value:
|
| CUBE_GUID | DBTYPE_GUID | Optional. Cube GUID. NULL if no GUID exists. |
| CREATED_ON | DBTYPE_DBTIMESTAMP | Optional. Date and time of cube creation. NULL if unknown. |
| LAST_SCHEMA_UPDATE | DBTYPE_DBTIMESTAMP | Optional. Date and time of last schema update. NULL if unknown. |
| SCHEMA_UPDATED_BY | DBTYPE_WSTR | Optional. User ID of the person who last updated the schema. NULL if unknown. |
| LAST_DATA_UPDATE | DBTYPE_DBTIMESTAMP | Optional. Date and time of last data update. NULL if unknown. |
| DATA_UPDATED_BY | DBTYPE_WSTR | Optional. User ID of the person who last updated the data. NULL if unknown. |
| DESCRIPTION | DBTYPE_WSTR | Optional. A human-readable description of the cube. If no description exists, this column is NULL. |