}CubeProperties

The }CubeProperties dimension is used only in the }CubeProperties control cube.

The dimension contains the following string elements corresponding to the properties that can be defined for cubes on the Planning Analytics database.

Element

Description

CALCULATIONTHRESHOLD Sets the threshold for the calculation cache in terms of number of calculation steps. Setting the cube property overrides the global value CalculationThresholdForStorage that is defined in the tm1s.cfg file.

DemandLoad

Indicates if a cube is automatically loaded when the server starts or is loaded 'on demand' only when a cube value is requested.

When a cube is loaded on demand, the value of the DemandLoad property is YES, otherwise the property value is NO.

Lock

When a cube is locked, this property stores the name of the TM1® client that has locked the cube.

Logging

Indicates if logging is enabled for a given cube. When cube logging is enabled, the value of this property is YES, otherwise the value is NO.

Measures_Dimension

If a measures dimension has been defined for a given cube, this property stores the name of the dimension.

Replication

For replicated cubes, this property stores the name of the replication connection with which the replicated cube is associated.

RepSrcName

For replicated cubes, this property stores the name of the source cube.

RepStatus

If a cube is replicated on the server, the value of RepStatus is Copied, otherwise this property value is empty.

Rule_Stats

This property determines if performance statistics are collected for the rules associated with the cube.

To enable statistic collection, set the Rule_Stats property to YES. To disable statistic collection, set the property to NO (this is the default value).

Rules statistics are stored in the }StatsByRule control cube.

Rule_Stats is a dynamic property, meaning that it does not require a server restart to take effect. However, it can take up to 60 seconds for a dynamic property change to be applied on the TM1 server.

SyncRule

For replicated cubes, this property indicates whether rules are synchronized when the associated cube is synchronized.

SyncViews

For replicated cubes, this property indicates whether views are synchronized when the associated cube is synchronized.

Time_Dimension

If a time dimension has been defined for a given cube, this property stores the name of the dimension.