21 September, 2018
at database level we have below permissions available. They are
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.
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.
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 .
<Children “Q1 2007”
<Column (geography, products)
<ROW (measures )
CACHES: They are 5 types of caches . those are
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.
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 .