Dimension

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%]]