Dimension Category (DBMS)

The Dimension category is located in the Root > Script > Objects category, and can contain the following items that define how dimensions are modeled for your DBMS.

Item	Description
[Common items]	The following common object items may be defined for dimensions: AfterCreate, AfterDrop, AfterModify Alter BeforeCreate, BeforeDrop, BeforeModify Create, Drop Enable Header, Footer Maxlen ReversedQueries SqlAttrQuery, SqlListQuery For a description of each of these common items, see Common object items.
AddAttr Hierarchy	Specifies the syntax for defining a list of hierarchy attributes. Example (Oracle 10g): child of %DIMNATTRHIER%
AddAttribute	Specifies the syntax for defining an attribute. Example (Oracle 10g): attribute %DIMNATTR% determines [.O:[(%DIMNDEPCOLNLIST%)][%DIMNDEPCOLN%]]
AddHierarchy	Specifies the syntax for defining a dimension hierarchy. Example (Oracle 10g): hierarchy %DIMNHIER% ( %DIMNATTRHIERFIRST% %DIMNATTRHIERLIST%)
AddJoin Hierarchy	Specifies the syntax for defining a list of joins for hierarchy attributes. Example (Oracle 10g): join key [.O:[(%DIMNKEYLIST%)][%DIMNKEYLIST%]] references %DIMNPARENTLEVEL%
AddLevel	Specifies the syntax for dimension level (attribute). Example (Oracle 10g): level %DIMNATTR% is [.O:[(%DIMNCOLNLIST%)][%DIMNTABL%.%DIMNCOLN%]]