OMBALTER DIMENSION

Altering Dimensions to add a new attribute in OWB

 To add a new attribute to an existing dimension in OWB repository using OMB+, do the following.

1.  First alter the metadata of the underlying table to add the new required atttibute

OMBALTER TABLE 'tablename' ADD COLUMN 'column name' SET PROPERTIES(DATATYPE,LENGTH) VALUES ('datatype',length)

2. Next, alter the metadata of the dimension to add the new attribute

OMBALTER DIMENSION 'dimension name' ADD DIMENSION_ATTRIBUTE 'attribute name' SET PROPERTIES(DATATYPE,LENGTH) VALUES ('datatype',length)

3. Next, alter the dimension to associate the new attribute to the level

OMBALTER DIMENSION 'dimension name' ADD LEVEL_ATTRIBUTE 'attribute name' OF LEVEL 'level name' SET REF  DIMENSION_ATTRIBUTE 'dimension attribute name'

4.  Now alter the dimension to bind the dimension attribute to the table column.

OMBALTER DIMENSION 'dimension name' IMPLEMENTED BY STAR LEVEL_ATTRIBUTE 'attribute name' OF LEVEL 'level name' BOUND TO COLUMN 'column name'.

There you go!!! a new attribute is added and bound to the table.