Essbase: Bootcamp BSO (5 days)
- Parent Category: Oracle Essbase
Essbase: Bootcamp BSO (5 days)
Audience: Essbase Developers and Hyperion Planning Administrators
Learn about the design of Essbase block storage databases and gain an understanding of Essbase multidimensionality, the loading and manipulation of data through calculation scripts and how to maintain and optimise Essbase databases.
This course covers everything you will need to know in order to design and maintain Essbase Block Storage (BSO) databases. No prior knowledge is assumed.
Learn the primary methods for the design of Essbase block storage databases. Understand Essbase multidimensionality, dense and sparse settings, building outlines with load rules, maintaining the Essbase environment, creation and calculation of data blocks, storage types, dynamic calc shared members, the order of operations, member formulas, dynamic calculations, two-pass calcs and sparse rollups. The course also covers detailed information about database outlines, loading data and analysis within a spreadsheet environment. Focus is also given to the creation and optimisation of calculation scripts and the backup and system administration of the system.
Day 1: Overview, Navigation, Outline creation and Dimension loading
Day 2: Enhanced reporting capabilities, data loading and Spreadsheet analysis
Day 3: Essbase optimisation, task automation and security
Day 4: Calculation methodologies and calculation scope control
Day 5: Relationship, mathematical and range calculations
Scheduled Course Dates
Register: Scheduled Course Dates - Select Course Title to Register
CPE Credits (North America)
Essbase Bootcamp BSO
Essbase Developers and Hyperion Planning Administrators
Recommended CPE Credits:
35 Credits -Specialized Knowledge and Applications
Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of
continuing professional education on the National Registry of CPE Sponsors.
Registration ID No 115820.
State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit.
Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors
through its website: www.learningmarket.org
Onsite Training at Your Premises
We can arrange dedicated training at your premises or at 3rd party locations on dates to fit with your project deadlines.
In addition to our published schedule of courses, we can also bring the classroom to your premises, delivering a
combination of administrator courses to meet your exact requirements or the customised delivery of end user
training to match your application and business processes. Onsite courses tend to be cost effective with four or
You will need to provide a room with a data projector, we will ship pre-configured laptops and courseware including the
manuals, pads, pens and an instructor! As an alternative to shipping laptops we can provide access to cloud-based
configured hardware over the internet if required.
Use the following link to request onsite training: