Dimension
A Dimension is a collection of hierarchies. There are two kinds: a public dimension belongs to a Schema, and be used by several cubes; a private dimension belongs to a Cube. The foreignKey field is only applicable to private dimensions.
Attributes
| Attribute | Data Type | Definition |
|---|---|---|
| name | String |
The name of this dimension |
| type | String |
The dimension's type may be one of "Standard" or "Time". A time dimension will allow the use of the MDX time functions (WTD, YTD, QTD, etc.). Use a standard dimension if the dimension is not a time-related dimension. The default value is "Standard". |
| caption | String |
A string being displayed instead of the dimensions's name. Can be localized from Properties file using #{propertyname}. |
| usagePrefix | String |
If present, then this is prepended to the Dimension column names during the building of collapse dimension aggregates allowing 1) different dimensions to be disambiguated during aggregate table recognition. This should only be set for private dimensions. |
Constituent Elements
| Element | Definition |
|---|---|
| Hierarchy | The hierarchies (pre-defined drill-downs) for this dimension |