About this course:

This Oracle Essbase (11.1.2) Bootcamp course provides you the knowledge and understanding of the theories and principal techniques for designing the block storage databases. Block storage databases are implemented separately for forecasting, planning, and budgeting, and as the basic analytic engine and data storage for Hyperion Planning applications.

Learn To:

• Create rules files.
• Build block storage databases.
• Increase analysis abilities.
• Data analytics with Smart View.
• Carryout advanced investigation on the database through implementing typed measures and varying attribute dimensions.
• Build basic calculations.
• Develop a database summary, analyze and load data into the database with Smart View.

Benefits to You:

This course will help you to enhance your company performance by good, well-informed decisions using Oracle Essbase, the industry-leading OLAP (Online Analytical Processing Server for Enterprise Performance Management. Improve the efficiency of variance analysis, forecasting, what-if modeling, scenario planning, and root cause identification for better lining up of your company’s resources and enhanced business results.

Calculation Scripts:

In this course, you will also learn to build calculation scripts (By calculating data in various scripts). Hands-on practice and design debates will assist you to exercise the new expertise you are studying.

Note: This course will also benefit those people who are using Oracle Essbase (11.1.1).

Course Objective:

• Utilize rules files to load data
• Develop fundamental database calculations
• Non-numeric data analysis
• Build block storage databases
• Analyze data through Smart View
• Build dimensions utilizing rules files
• Dimension attributes analysis
• Define multidimensional calculation

Audience:

• Developer
• Database Designers and Administrators
• Business Intelligence Developer
• Business Analysts

Prerequisite:

• There is no prerequisite required to appear in this course.