Filter Security

Essbase security filters give you control over security at the most detailed level. Filters let you control access to individual data within a database, by defining what kind of access is allowed to which parts of the database, and to whom these settings apply. Any cells that are not specified in the filter definition inherit the database access level.

 

None - No data can be retrieved or updated for the specified member list.

Read - Data can be retrieved but not updated for the specified member list.

Write - Data can be retrieved and updated for the specified member list.

Metadata - Metadata (Dimension and member names) can be retrieved and updated for the corresponding member specification.

Examples:-

Simple Example: create filter 'GauravCP'.Demo'.' filter1'  read on '"New York"';

Member Selection:  create filter 'GauravCP'.Demo'.'Filter2' read on '@ICHILDREN ("100")' ;

Multiple Selection :create filter sample.basic.filt1 read on 'Jan, sales', no_access on '@CHILDREN(Qtr2)';

Attribute Members : create or replace filter sample.basic.filt1 read on 'Sales, @ATTRIBUTE(Bottle)';
Compound Filter : create or replace filter 'GauravCP'.Demo'.'Filter4' read on '@IDESCENDANTS ("East"),"100-20“’,write on '@IDESCENDANTS ("West")';

Definition Specific : create or replace filter sample.basic.filter6 read on 'Jan,Feb sales', no_access on '@CHILDREN(Qtr2)' definition_only;