Group Discounts available for 3+ students and Corporate Clients

Database Level Permission & FILTER In Hyperion EssBase

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.

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Database Level Permission & FILTER In Hyperion EssBase"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6