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

dbms_aw_utilities

Functions/Procedures

create_custom_measure

dbms_aw_utilities.create_custom_measure(
  'schema.aw_name',
  aw_formula_name,
  aw_forumla_expression,
  'PERMANENT', -- or 'TEMPORARY'
  'schema.view_name');
CWM2$_AW_TEMP_CUST_MEAS_MAP lists temporary custom measures for the current user, CWM2$_AW_PERM_CUST_MEAS_MAP lists permanent custom measures for users with the DBA role.