}DimensionProperties
The }DimensionProperties dimension contains the following string elements that correspond to the properties that can be defined for dimensions on the Planning Analytics database.
|
Element |
Description |
|---|---|
|
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. |
|
Lock |
When a dimension is locked, this property stores the name of the Planning Analytics client that has locked 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 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 left blank, 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. |