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:
MAXL to export "essbase.sec" file:
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
MAXL to export "essbase.sec" file:
- export security_file to data_file "e:\khoonks\essbase_security_file.txt"
No comments:
Post a Comment