
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.
- Parent Topic
- Child Topics
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. |
- Parent Topic