Updating Custom-Defined Macros

  To update a custom-defined macro:

  1. Determine whether the macro is registered locally or globally.

    See Viewing Custom-Defined Macros.

  2. To update the macro definition; use a tool:

Tool

Topic

Location

Administration Services

Editing Custom-Defined Macros

Oracle Essbase Administration Services Online Help

MaxL

create macro or replace macro

Oracle Essbase Technical Reference

The following MaxL statement changes the local macro @COUNTRANGE, which is used only in the Sample application:

create or replace macro Sample.'@COUNTRANGE'(Any)
as '@COUNT(SKIPMISSING, @RANGE(@@S))';

The following MaxL statement changes the global macro @COUNTRANGE:

create or replace macro '@COUNTRANGE'(Any)
as '@COUNT(SKIPMISSING, @RANGE(@@S))';