Manage dimension properties

You can view and edit dimension properties in the dimension editor.

Click the action icon Vertical ellipsis icon

Vertical ellipsis icon

next to the dimension name, then click Properties.

Some of these properties cannot be edited, they are updated by the system.

Property name	Description
ALLLEAVESHIERARCHYNAME	This property stores the name given to the all leaves hierarchy. The all leaves hierarchy is present in any dimension that contains more than one hierarchy.
DEFAULT_HIERARCHY	Not currently used.
DEMANDLOAD	Not currently used.
LAST_TIME_UPDATED	Time (GMT) at which a dimension was last updated. The time format is yyyymmddhhss.
LASTREPSYNCCHANGEDTIME
LOCK	Indicated when a dimension is locked.
REPLICATION	For replicated cubes, this property stores the name of the replication connection with which the replicated cube is associated.
REPSRCNAME	For replicated dimensions, this property stores the name of the source dimension.
REPSTATUS	If a dimension is replicated on the server, the value of REPSTATUS is Copied. Otherwise the REPSTATUS value is empty.
SORTCOMPONENTSSENSE	When the immediate components (children) of a consolidation are sorted, this property stores the sense applied to the sorting. Components can be sorted in either the ASCENDING or DESCENDING sense.
SORTCOMPONENTSTYPE	This property indicates the type of sorting that is applied to the immediate components (children) of a consolidation. There are two types of sorting: BYNAME and BYINPUT. The BYINPUT sort does not actually enforce any sorting, it leaves the components in the order they appeared the last time the dimension was saved.
SORTELEMENTSSENSE	When dimension elements are sorted automatically, this property stores the sense applied to the sorting. Elements can be sorted in either the ASCENDING or DESCENDING sense.
SORTELEMENTSTYPE	When dimension elements are sorted automatically, this property stores the type of sorting used. There are four types of element sorting: BYNAME, BYLEVEL, BYHIERARCHY, and BYINPUT. The BYINPUT sort does not actually enforce any sorting, it leaves the elements in the order they appeared the last time the dimension was saved. If a sorting is not specified, BYINPUT applies. SORTELEMENTSTYPE applies to all dimension elements, both consolidations and leaf elements.
SYNCATTRIBUTES	For replicated cubes, this property indicates whether element attributes are synchronized when the associated dimension is synchronized.
SYNCSUBSETS	For replicated cubes, this property indicates whether subsets are synchronized when the associated dimension is synchronized.
USESEPARATECONTROLCUBES	Not currently used.
VISIBILITY