*** 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
Now I am Fluent German Language, Thanks to Elegant IT Services
I completed DevOps Training in Bangalore from Elegant IT Services recently, Really an amazing place to start off. Learned a lot in such a short span of time.The faculty is experienced and management is pretty good.
Elegant IT Services gives the Best Teaching of the German language. This Training helps me a lot Thanks to my Trainers.
This Institute has a very good faculty. I really like the methodology that the faculty follows in order enhance the aspiring students. They not only enhance the students, but also provide Training
I had joined Elegant IT services for Microsoft Dynamics AX. I feel this is the better institute as compared to others