dimopts

The dimopts options apply to the following MDL verbs: DimAdd, DimMake, and DimUpdate.

Association
The Association option specifies the associated column from the data source.
DaysInWeek
The DaysInWeek option specifies each day in the week as a unique, but non-sequential number.
DimDefaultCategory
The DimDefaultCategory option specifies a new default category, at a lower level in the cube, where a scenario dimension opens, to show report users meaningful data values.
DimInfo
The DimInfo option provides additional information about the dimension.
DimType
The DimType option specifies the dimension type. Note that time dimensions are defined as a specific type (Date) but scenario dimensions are not.
EarliestDate
The EarliestDate option specifies the earliest valid date for the model.
ExcludeAutoPartitioning
The ExcludeAutoPartitioning option specifies whether auto-partitioning will be used as a model optimization strategy.
LatestDate
The LatestDate option specifies the latest valid date for the model.
ManualPeriods
The ManualPeriods option specifies whether the current time period will be manually or automatically set.
NewCatsLock
The NewCatsLock option specifies whether new categories will be automatically created in the dimension as they are encountered in the data source.

Parent topic: MDL options