Hyperion Essbase Online Training

HYPERION ESSBASE ONLINE TRAINING

Course Contents:
Hyperion Essbase 11.X Version (System 11)
Understanding multidimensional databases OLAP
Multidimensional databases Dimensions and Members
Hyperion Essbase Architecture
Hyperion Essbase Analytical Server Architecture
Hyperion Essbase Administrative Server Architecture
Hyperion Essbase Functional Flow
Creating Essbase Applications
Creating Essbase Databases
Explanation about Essbase Application Types
Explanation about Essbase Database outline
Rules File
Dimensions
Standard Dimensions
Attribute Dimensions
Dense and Sparse Dimensions
Dimension Properties
Dimension Type Properties
Dimension Storage Properties
Dimension Members
Member Consolidation Properties
Member Storage Properties
Time Balance Properties
DTS Properties
Building Outlines
Using Manually
Using Rules Files with Dynamic Dimension build methods
UDAs
Shared Members
Building Manually
Building Dynamically
Two-Pass
Outline Build Methods
Generation Reference
Level Reference
Parent Child Reference
Loading Data into outline without Rules File
Types Data Loading
Spread Sheets
Planning
Creating Reports with Report Scripts
Creating Reports with Excel Add-Ins
Calc Scripts
Understanding Intelligence Calculation
Report Scripts
MaxL
Editor
Shell
Batch Mode
Difference between ASO and BSO
Security (Shared Services)
Creating Users
Creating Groups
Refreshing Admin
Filters
Introduction to Partitions
Replicated
Transparent
Linked
Source and Target Information
Some Optimization Techniques
Hyperion Essbase Spreadsheet Add-in
Setting Essbase options
Retrieving Data
Connecting to the database.
Changing the Password
Retrieving data from a Database
Cancelling data Retrieval Request
Restoring Previous data database view
Drilling down to more Details
Drilling up to less Detail
Customizing Drill-Down
Drill-Up behaviours
Pivoting, Retaining, and Suppressing Data.
Pivoting Rows and columns.
Retrieving a data subset
Removing a Data Subset
Navigating Through the worksheet without retrieving data Suppressing missing values
Navigating Through the worksheet without retrieving data Zero Values
Navigating Through the worksheet without retrieving data underscores characters
Customising Dimensions and Members view in report
Running Calc Scripts
Using Linked Reporting Objects.
Linking a file to data cell
Linking a Cell note to a Data cell
Linking a URL to a data cell
Assessing and editing LRO
Updating Data on the Server

Hyperion Essbase Online Training, Hyperion Essbase Training, Hyperion Essbase Online Courses