Friday, April 18, 2014

Essbase Quick Reference

Essbase: Extended Spreadsheet - a multi-dimensional OLAP system.

Essbase database structure:
   Application
       Database
           Outline
Outline is created when database is created. Includes dimensions, members, aliases, properties, types, consolidation, and mathematical operators.

Following files are created when a database is created.
.db, .dbb, .otl, .esm, .tct

Following files are created when an application is created.
.instance, .app, .log


Intelligent Calculation: With this, Essbas calculates only update members and their dependent parents (dirty blocks) making calculation efficient. After full calculation, all data blocks are marked clean. We can turn the Intelligent Calculation feature on or off through calculation script or essbase.cfg file.

Keyword - UPDATECALC

Syntax (calc script) - SET UPDATECALC ON/OFF;
Syntax (essbase.cfg file) - UPDATECALC TRUE/FALSE

SET UPDATECALC ON;      Calculates only dirty blocks
SET UPDATE CALC OFF;    Calculates all data blocks


Essbase Security File - essbase.sec
Location - Arborpath/bin directory - eg: (\\EssbaseServer\d$\Hyperion\Essbase\bin)

Information stored in secfile:
  • Filter Access
  • Application Access type
  • Application and database properties, substitution variables
  • CalcScript access
essbase.sec file contents are encrypted. We can export it to a .TXT file and view the contents.
MAXL to export "essbase.sec" file:
  • export security_file to data_file "e:\khoonks\essbase_security_file.txt"


No comments: