You use the Copy Filter dialog box to copy security filters from one database to another:
Boxes in which you enter information:
Essbase Server—Target server (same or different server, according to your permissions)
Application—Target application
Database—Target database or <all dbs> (to copy the filter to all databases within the application)
Filter—Name for the filter copy (can contain letters, numbers, and spaces; for length limitations, see the Oracle Essbase Database Administrator's Guide)
If you want to replace any filter that has the name of the copied filter, select the “Replace existing filter” option.
alter object (MaxL) in the Oracle Essbase Technical Reference
create filter as (MaxL) in the Oracle Essbase Technical Reference
copyfilter (ESSCMD) in the Oracle Essbase Technical Reference