Creating Essbase Artifacts

You must create filters and calculation scripts in the Oracle Essbase application database before artifact access controls can be imposed. Essbase uses filters to accommodate the security needs of specific parts of a database and to control security access to data values or cells by restricting access to database cells. Essbase Server stores filters in essbase.sec.

Calculation scripts are commands that define how a database is consolidated or aggregated. calculation scripts may also contain commands that specify allocation and other calculation rules separate from the consolidation process.

You can use the Oracle Essbase Administration Services Console or MaxL to create filters and calculation scripts. For information on creating and managing filters and calculation scripts, see the Oracle Essbase Administration Services Online Help or the Oracle Essbase Database Administrator's Guide.