Example: Creating a Dimension Attribute

The following statement creates a dimension attribute, PRODUCT_DIM_BRAND, for the PRODUCT_DIM dimension in the JSMITH schema. The display name is Brand. The short description is Brand Name, and the description is Product Brand Name.

execute cwm2_olap_dimension_attribute.create_dimension_attribute 
     ('JSMITH', 'PRODUCT_DIM', 'PRODUCT_DIM_BRAND', 
      'Brand', 'Brand Name', 'Product Brand Name');

The following statement creates a dimension attribute, 'Short Description', for the PRODUCT_DIM dimension in the JSMITH schema. Short Description is a reserved dimension attribute.

execute cwm2_olap_dimension_attribute.create_dimension_attribute 
     ('JSMITH', 'PRODUCT_DIM', 'Short Description', 
      'Short Product Names', 'Short Desc Product', 
      'Short Name of Products', TRUE);