_Cubes

The _Cubes table describes metadata relating to cubes. One row contains data for one cube at cube level.

This table describes _Cubes:

Column Type Description
CubeName String(50) Name of cube.
CubeDescription String(150) Description of the cube.
Param1 String(150) Reserved
Param2 String(250) Reserved
AccessControl Boolean Flags whether the cube’s data access permissions are controlled by #TABACC or not:
  • True = Cube’s data access is controlled by #TABACC.
  • False = Cube’s data access is not controlled by #TABACC.
TransactionLog Boolean Flag for whether the cube has an associated transaction log:
  • True = Has a transaction log.
  • False = Has no transaction log.
CubeType String(1) The cube type. Enumerator. The values are:
  • U = User cube.
  • D = DAC or MDAC.
  • NULL value means U.
ExtendedProps Text Extended properties of the cube expressed as an XML document string. NULL means the cube has no extended properties.
CubeRules Text The rules of the cube expressed as an XML document string. NULL means the cube has no rules. NULL does not remove any existing rules.
Comment Text User defined comment.

General information

The rows of the _Cubes table are read into memory. These are those rows for which there is a cube creation or loading operation to carry out indicated by a row in the _Jobs table. These _Cubes rows are linked from the _Jobs table either:

  • For cube creation or property loading through the JobObject column via CubeName of the _Cubes table.
  • For fact loading via the CubeId column of the _FactLoad table.