Chapter 3 DBMS Reference Guide

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

 

Copyright (C) 2007. Sybase Inc. All rights reserved.