MicroStrategy ONE

List MDX cubes statement

Lists the MDX cubes for a database instance and project.

Copy
LIST [ALL] MDXCUBES FOR DBINSTANCE "database instance" PROJECT "project 
 name";

where:

  • DBINSTANCE "database instance" is the name of the database instance you are listing the MDX cubes for, of type string.

  • PROJECT "project name" is the name of the project you are listing the MDX cubes for, of type string.

Example

Copy
LIST MDXCUBES FOR DBINSTANCE 
 "MDX Source" PROJECT "MicroStrategy Tutorial";

ResultSet columns

GUID: The object  ID of the MicroStrategy MDX cube.

DSS_TABLE_NAME: The name of the MDX cube, returned as a string.