*** New weekday/weekend batches Going to start - ***Hadoop,Java ,SalesForce ,Selenium , QlikView,Tableau ,Linux ,Python ,Perl,Shell,SAS ,MSBI ,SOA , AWS, Android ****
Training Curriculum for
Oracle Essbase 11.1.2.3
Course Objectives:
·
Create Block storage
databases
·
Create Aggregate storage
databases
·
Create dimensions using
rules files
·
Load data using rules
files
·
Analyze data with Smart
View
·
Describe
multidimensional calculation
·
Create basic &
advanced database calculations
·
Create basic &
advanced report scripts
·
Create & manage
partitions
·
Optimize & maintain
BSO/ASO cubes (System Administration)
·
Setup security using
Essbase stand-alone mode & Shared services mode (System Administration)
·
Analyze dimension
attributes
·
Analyze non-numeric data
Course Topics:
Essbase Overview
·
Multidimensional
Analysis/Understanding Multidimensional databases (OLAP Vs OLTP)
·
Oracle Enterprise Performance Management System
·
Essbase
·
Production
Environment Components.
Designing Applications and Databases
·
Essbase
Implementation Process
·
Analyzing
and Planning Implementations
·
Creating
Applications and Databases
·
Creating
Outlines
Designing Data Descriptor Dimensions
·
Data
Descriptor Dimensions Overview
·
Designing
Time Dimensions
·
Designing
Scenario Dimensions
·
Outline
Calculations
·
Designing
Accounts Dimensions
·
Testing
Outline Calculations
Creating Basic Dimension Build Rules Files
·
Rules
Files Overview
·
Creating
Dimension Build Rules Files
·
Configuring
Dimension Maintenance Settings
Creating Advanced Dimension Build Rules Files
·
Advanced
Dimension Build Rules Files Overview
·
Creating
Shared Members
·
Manipulating
Fields
·
Creating
User-Defined Attributes
·
Creating
Attribute Dimensions with Rules Files
Loading Data
·
Data
Load Overview
·
Creating
Data Load Rules Files
·
Selecting
and Rejecting Records
·
Capturing
New Members
·
Creating
Report scripts
Getting Started with Smart View
·
Navigating
Smart View
·
Connecting
to Data Sources
·
Creating
Ad Hoc Grids
·
Setting
the Point of View
·
Associating
Data Sources with Worksheets
·
Creating
Free-Form Grids
Creating Reports with Smart View
·
Updating
Essbase Data
·
Integrating
Essbase Data with Microsoft Office
·
Creating
Custom Reports
Data Storage and Calculation
·
Calculation
Overview
·
Database
Calculation Order
·
Data
Block Fundamentals
·
Data
Blocks and the Index System
·
Interpreting
Database Statistics
·
Data
Block Creation
·
Database
Calculation Process
Creating Calculation Scripts
·
Calculation
Script Organization (using both Essbase calculation script editor & EPMA
Calculation Manager)
·
Returning
Correct Calculation Results
·
Troubleshooting
CALC DIM Processes
Controlling the Calculation Process
·
Top-Down
Calculation
·
Focusing
Calculations with FIX Statements
·
Calculating
Conditionally with IF Statements
·
Performance
Considerations
Developing and Testing Complex Calculation
Scripts
·
Implementing
a Script Development Process
·
Upper-Level
Data Loads
·
Intelligent
Calculation
Normalizing Data
·
Allocating
Data
·
No Interview Questions Found..
Our Oracle Hyperion Training Trainers in our Elegant IT Services
Oracle Hyperion Training Placement through Elegant IT Services
A very good institute for learning DevOps Training in Bangalore, It was the best experience, friendly staff, always available for doubts clarification. My trainer taught with clear explanation of each and every concept thoroughly
I have done AngularJS course. They provide very good teaching. I have been part of this institute for 2 months. Highly recommended.
Its really been good to choose Elegant IT Services for Android Training. I am satisfied with the course. And I am thankful to my trainer who is always in favor of us.
It is a nice course with more focus on practicals with good guidance to learn Java.
I joined in Elegant IT Services for c++ Course in Bangalore .The way of teaching excellent it's a great future of every student .