}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.

VMM

For each cube, this property determines the amount of RAM reserved on the server for the storage of stargate views. The more memory made available for stargate views, the better performance will be. You must, however, make sure sufficient memory is available for the Planning Analytics database to load all cubes.

The value of VMM is expressed in kilobytes. If no VMM value is specified the default value is 128 kilobytes.

The valid range for VMM is 0 - 2,147,483,647 KB. The actual upper limit of VMM is determined by the amount of RAM available on your system.

VMT

For each cube, this property defines the time threshold, in seconds, beyond which the algorithm that stores stargate views is triggered.

If the time required to calculate a cube view surpasses the specified threshold, Planning Analytics attempts to store a stargate view. If there is not enough memory available to store the stargate view, Planning Analytics purges the oldest stargate view that is not currently in use, and continues to purge views in this manner until sufficient memory is made available.

If no VMM value is specified the default value is five seconds. The valid range is 1 - 259,200 seconds.

For details on stargate views, see About Stargate views.