Influx Software Solutions

HYPERION ESSBASE

Hyperion Essbase Projects

Hyperion Essbase support project activities (Real time scenarios)
Essbase administration in Windows
Hyperion Essbase Development project activities (Real time scenarios)

Data ware housing overview:

Multidimensional overview

OLAP vs., OTLP
Hyperion Project life cycle
Business Intelligence
Comparison between different data warehousing tools

Essbase 9.X

Understanding multidimensional databases
OLAP and Multidimensional databases
Dimensions ad Members

Data Storage

Essbase Architecture
Designing of Application and Database

Identifying business and user requirement, including security
Identifying source data and determining the scope of the essbase
Identifying Members
Member Properties (Storage & Consolidation)
Defining slandered dimensions and defining spare and dense dimensions
Defining attribute dimensions
Defining calculation needed for outline dimensions and members

Estimating the size of essbase database
Creating Applications and Databases

Creating Applications and databases
Creating and Changing Database outline
Creating UDA’s
Creating Shared Members
Two-pass calculations
Creating and working with Duplicate members outline
Assigning alias names to your members
Slandered dimensions and member Properties
Working with Attributes

Linking Objects to essbase data.
Designing Partitioned Applications.
Creating and Maintaining Partitions.

Transparent Partition.
Linked Partition.
Replicated Partition

Data loading and Dimension building.

Understanding Data load and Dimension Building.
Creating Rules Files.
Using a rules file to perform Operations on Records, Fields, and data.
Performing and Debugging Data Loads or Dimension Builds
Understanding Advanced Dimension Building concepts.
Loading data using Free-form
Loading data with a rules file.

Loading by generation.
Loading Parent-Child.
Loading by level

Calculating database.(Calculations scripts)

Developing Formulas.
Reviewing examples of formulas.
Defining calculation order.
Understanding Intelligence calculation.
Dynamically calculating data values.
Calculating Time series data.
Developing calculation scripts
Reviewing examples of Calculation scripts.

Creating reports using report script.

Understanding Reports Basics.
Developing reports scripts.

Difference between MAXL and ESSCMD.
Automate routine operations by Maxl or ESSCMD.
Designing security for Essbase database.

User Management and security.
Creating users and groups.
Assigning users under groups.
Security Permissions.
Controlling Access.
Creating Filters.
Assigning Filers to Users.

ASO vs BSO.

Caparison of ASO and BSO.

Maintaining Essbase Applications

Running Essbase servers, Applications and Databases.
Managing applications and Databases.
Understanding the Hyperion essbase real time issues.
Managing Database settings.
Backup and Recovery.
Allocating storage and compressing data.
Monitoring performance.
Optimizing data loads.
Optimizing Calculations.
Understanding intelligence calculation.
Optimizing reports and other types of retrievals

Introduction to Version migration.

Scheduling Jobs

Creating jobs for data load.
Creating jobs for dimension build.
Creating Automation Process.
Scheduling the jobs.
Configuring email alerts.
Introduction to monitoring tools.

Project: - Hyperion Essbase project with live data.

Hyperion Essbase Spreadsheet Add-in

Getting acquainted with spreadsheet Add-in.

Adding Spreadsheet Add-in
Starting Spreadsheet add-in
Installing the Essbase Toolbar for Excel.
Using the Essbase toolbar.
Setting Essbase options.

Retrieving Data

Connecting to the database.
Changing the Password
Retrieving data from a Database.
Canceling data Retrieval Request.
Restoring Previous data database view.
Drilling down to more Details.
Drilling up to less Detail.
Customizing Drill-Down and Drill-Up behaviors.

Pivoting, Retaining, and Suppressing Data.

Pivoting Rows and columns.
Retraining a data subset
Removing a Data Subset.
Navigating Through the worksheet without retrieving data
Suppressing missing values, Zero Values and underscore characters

Formatting the Worksheet:

Formatting Text and Cells.
Displacing Alias for member names.
Displacing both member names and Aliases.
Reputing Member Labels.

Creating Queries using Essbase Query Designer.

Creating Quires.
Saving Quires.
Applying Quires.
Deleting Quires.
Viewing Messages and Conformation

Selecting Members

Selecting Members.
Finding Members.

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.

Connecting To Multiple Databases.

Ways to view Active Database Connections.
Ways to access Linked Partitions

Updating Data on the Server.

Database Calculation

Creating Multiple Worksheets from data.

Saving and Disconnecting.