René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

cwm2_olap_dimension_attribute

cwm2_olap_dimension_attribute manages dimension attributes within an OLAP catalog. Generally, the dimension attributes long description and short description are defined.
The following attributes can be specified:
  • long description
  • short description
  • end date
    The last date in a time period (time dimensions only)
  • time span
    The number of dates in a time period (time dimensions only)
  • prior period
  • year ago period
  • et key
  • parent et key
  • grouping id
  • parent grouping id

Functions/Procedures

create_dimension_attribute_2

procedure create_dimension_attribute_2
  p_dimension_owner           in  varchar2,
  p_dimension_name            in  varchar2,
  p_dimension_attribute_name  in  varchar2,
  p_display_name              in  varchar2,
  p_short_description         in  varchar2,
  p_description               in  varchar2,
  p_use_name_as_type          in  number