Session : 1 – Overview of Oracle Essbase
- Describe multidimensional analysis
- Describe Oracle Essbase
- Describe Smart View
- Retrieve Data using Smart View
- Perform manual outline creation
- Build dimensions from sources
- Perform initial data loads
- Use calculations and aggregations
- Assign security
- Describe when to deploy aggregate storage, block storage, or a combined solution
- Convert block storage to aggregate storage
- Create, load, and pre-aggregate aggregate storage databases
- Employ database partitioning in combined block/aggregate storage solutions
- Write member formulas using MDX
- Perform management tasks for aggregate storage databases
- Partition block and aggregate storage databases
- Describe and implement aggregate storage design best practices
- Describe multiple hierarchies and the use of Shared Members
- Describe block storage calculations
- Describe the default database calculation order
- Describe data blocks
- Interpret database statistics
- Describe when data blocks are created
- Describe the block storage database calculation process
- Tune and optimize block storage databases
- Describe and implement block storage design best practices
- Describe BSO load techniques Working with Calculation Scripts
- Identify correct and incorrect calculation script syntax
- Describe calculation script behaviour for various ASO data structures
- Describe calculation script behaviour for various BSO data structures
- Design calculation scripts to meet specified requirements
- Describe the file Essbase.cfg and its settings
- Describe the file Essbase.sec and its settings
- Identify and interpret Essbase log files
- Manage Essbase security via Administration Services
- Manage Essbase security via Shared Services
- Back up and recover Block Storage Databases
- Automate database processes with MaxL
- Describe and use substitution variables and location aliases
- Describe functionality of Essbase studio
- Add and delete joins between tables
- Create drill through reports
Smart View
Session : 2 – Essbase Application Creation Fundamentals
Session : 3 – Aggregate Storage Databases
Session : 4 – Block Storage Databases
Session : 5 – Describe how data blocks are indexed
Session : 6 – Essbase Administration
Session : 7 – Essbase Studio
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.