Database Level Permission & FILTER In Hyperion EssBase

21 September, 2018


Related Blogs

Database Level Permission :-

at database level we have below permissions available. They are

  • None
  • Filter
  • Read
  • Write
  • Calculation
  • DB designer

None is the lowest permission and DB designer has all rights for particular DB.


FILTER control the security down to a cell level. Filters should be created under the DB. Only one filter can be assigned to a user at a time . The filter information and the security information are stored in ESSBASE.SEC file.


  • The members must be separated by comma, there are 4 types of access levels parent. Those are none, read, write and meta read.
  • If there is any conflicting access level will take the priority
  • The detailed member specification gets highest priority.



With this filter , user will get READ access for all measures for AP market , except for AP, SALES combination.


report scripts are used to create formatted reports. The output of the report cannot be edited and there are no drill down/up features available.

  • To create report scripts : right click o9n the report script , report script editor opens. Enter all the commands , validate and save the report with .REP extent ion
  • Click execute button , another screen appears it has 3 options. When we select console the report will be displayed on t6he screen. When we select printer , then report will be printed to a printer
  • When we select the output option , we need to give the path of the report . the extension of the file script we can open this text editor . the report writer consist of 3 main components .

Report script editor : Where we write the report writer commands Reporter extractor : Which connects to the ESSBASE d/b , which retrieves the data . Report viewer : Where the reports get displayed .

<Page Time

<Children “Q1 2007”

<Column (geography, products)

<UDA(geography, products)


<ROW (measures )


  • Increasing the retrieval buffer size , default it is set to 10 KB . we can set this up to 100 KB

CACHES: They are 5 types of caches . those are

  • index cache
  • data file cache
  • data cache
  • calculator cache
  • dynamic calculator cache

INDEX CACHE:- index cache is a buffer in memory that holds index pages it can hold depends upon the index file cache settings . default size is 102 KB

DATA FILE CACHE:- this is a buffer in memory that holds compressed data file caches .pagfile. default size is 32768 KB

DATA CACHE :- this is a buffer in memory that holds uncompressed data blocks . default size is 3072 KB

CALCULATOR :-   this memory is used to hold blocks that are equal to calculate the blocks

DYNAMIC CALCULATOR CACHE :- this memory holds block while calculating dynamic calc members during retrieval.

Double click on properties and click cache to see the caches.

About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .