Course Content

Create block and Aggregate storage databases

Create dimensions using rules files

Load data using rules files

Analyze data with Smart View

Describe multidimensional calculation

Create basic database calculations

Analyze dimension attributes

Hyperion Essbase Infra

Hyperion Essbase Security

ESSBASE Course Topics

• Production Environment Components
• Designing Applications and Databases
• Block Storage Implementation Process
• Aggregate storage Implementation Process
• Analyzing and Planning Implementations
• Creating Applications and Databases
• Creating Outline Structures
• Modifying Member Properties 

Designing Data Descriptor Dimensions

• Data Descriptor Dimensions Overview
• Designing Time Dimensions
• Designing Scenario Dimensions
• Outline Calculations
• Designing Accounts Dimensions
• Testing Outline Calculations 

Optimizing Data Descriptor Dimensions

• Creating Member Aliases
• Dimension Types
• Creating Period-to-Date Totals
• Dynamic Calc Members
• Enhancing Accounts Dimensions
• Optimizing Data Storage 

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 

Loading Data

• Data Load Overview
• Creating Data Load Rules Files
• Selecting and Rejecting Records
• Capturing New Members 

Getting Started with Smart View

• Smart View Overview
• Configuring Data Sources
• Creating Ad Hoc Reports
• Setting the Point of View 

Creating Reports with Smart View

• Manipulating Multidimensional Data
• Updating Essbase Data
• Integrating Essbase Data with Microsoft Office
• Customizing the User Experience 

Data Storage and Calculation

• Calculation Overview
• Database Calculation Order
• Data Block Fundamentals
• Data Blocks and the Index System
• Database Statistics
• Data Block Creation
• Database Calculation Process 

Creating Calculation Scripts

1. Calculation Script Organization
2. Returning Correct Calculation Results 

Controlling the Calculation Process

• Focusing Calculations with FIX Statements
• Calculating Conditionally with IF Statements
• Comparing FIX and IF Calculation Processes 

Referencing Members in Calculations

• Referencing Members Explicitly
• Referencing Members Dynamically
• Creating Calculation Variables

Partitions

• Report Scripts
• Maxl Scripts
• Hyperion essbase infra

FAQ’S

What if I miss one (or) more class?

No need to worry about the classes you missed. We will definitely guide you by having optional classes or by having classes with other batches with the same topic you missed previous classes.

Who is my instructor?

IT professionals who have strong knowledge in technical know how to convey things with the real-time example. Even a layman could understand the concepts which given by our experts.

What are the modes of training offered for this course?

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

What are the system requirements to work?

Minimum 2GB RAM and i3 processor is required

Can I attend a demo session?

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

How about group discounts (or) corporate training for our team?

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Where do Our Online learners and Trainer’s come from

We are providing online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

I have more queries?

If you want to know More Details about Online Training Please Contact us. Or you can share your quires through info@monstercourses.com. Estimated turnaround time will be 24 hours for mails.

Contact us