Launch the Administration Console by selecting Start > Programs > Hyperion > Administration Services > Start Administration Services Console.
In the Analytic Administration Services Login dialog box enter a server name and your user name and password to log on to Administration Services.
In the left navigation frame of Administration Services, expand the Business Rules node. Then expand the Repository View node.
Right-click the Macros node and select New Macro.
The cursor is positioned on the first line of the Source tab.
On the Source tab, write the macro. You can insert global variables, other macros, and parameters into the macro by right clicking inside the Source tab. You can also insert functions and commands.
For more information on creating global variables, see Creating Global Variables.
For more information on creating macros, see Creating Macros.
For more information on inserting parameters, see Inserting Parameters into Macros.
For more information on inserting Essbase commands, see Using Essbase Calculation Commands.
For more information on inserting Essbase functions, see Inserting Functions with the Function Editor.
On the Parameters tab, you can view a list of the parameters that are being used in the macro and enter definitions for them.
On the Usages tab, you can see which business rules and other macros are using this macro. If you are creating the macro, the tab is empty until you begin using the macro in business rules and other macros.
On the Doc tab, you can enter a description of the macro for other users.
On the Properties tab, you can enter the name of the macro owner, specify whether or not the macro should be locked so that other users cannot see it or edit it, and view other information about the macro.
On the Access Privileges tab, if you are an administrator, you can grant and/or delete access to this macro. If you are the owner, or you were granted modify access to the macro, you can assign users edit/no edit privileges for the macro. See Adding or Editing Access Privileges for a Macro and Deleting Access Privileges for a Macro.
Click Save to save the new macro.
Optional: Validate the macro after selecting the associated outline.