You can copy custom-defined macros to any Essbase Server and application to which you have appropriate access.
To copy a custom-defined macro, use a tool:
Tool
Topic
Location
Administration Services
Copying Custom-Defined Macros
Oracle Essbase Administration Services Online Help
MaxL
create macro
Oracle Essbase Technical Reference