COURSE CONTENT

• Hyperion Essbase Architecture

• Creating Essbase Application and Database

• Explanation of Essbase Objects like Outline,

• Calc Script, Rules file and Report Script,

• Dimensions:

• Standard dimension

• Attribute dimension

• Dense & Sparse dimension

• Dimension properties

• Dimension type properties

• Storage properties

• Members

• Consolidation properties

• Storage properties

• Time Balance properties

• Dynamic Time Series

• Building Outline

• Using manually

• Using rule file with dynamic dimension

• build method

• User defined attributes

• Shared members

• Two-Pass

• Using rule file with dynamic dimension

• build methods:

• Generation Reference

• Level Reference

• Parent Child Reference

• Loading data into outline with Rule file.

• Explanation of Excel Add-In

• Building reports using Excel Add-In

• Creating Calc Scripts

• Difference between ASO and BSO

• Outline Back up and Recovery

• Shared Services

• Creating users and groups

• Creating Filters

• Assigning Access to users and groups.

• Migrations

• Partitions

• Optimization Techniques

• Outline Optimization

• Data load Optimization

• Calc Script Optimization

• Data base Optimization

• Using data base settings

• Hyperion Analyzer Architecture

• Design Reports using Web Analyzer