After you create a filter, you can copy it to another database on any Essbase Server to which you have appropriate access. See Managing Filters for information about permissions needed to manage filters.
You can also migrate filters and filter associations across servers as part of application migration. See Migration Wizard.
To copy a filter to a new location:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, then Filters.
In the Filters window, select one or more filters.
Right-click and select Copy filter(s).
In the Copy Filter dialog box, select the Essbase Server, application, and database to which you want to copy the filters.
To copy the filters to all databases in the selected application, select (all dbs).
In the Filter name text box, enter the name for the filter copy.
Specify whether to replace an existing filter by selecting the Replace existing filter check box.
Click OK to return to the Filters window.
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