HYPERION 11.1.1
ESSBASE
PLANNING 
HYPERION FINANCIAL MANAGEMENT
DATA WAREHOUSE CONCEPTS
•	Business Intelligence
•	Data Warehouse
•	Data Mart
•	Business Requirement gathering
•	Star Schema Design
•	MDDB
•	OLAP vs. OLTP
•	Snowflake Schema
•	Normalization vs. Renormalization
•	Data& Metadata
•	Dimensional Table
•	Fact Table
•	Fact less Table
•	Surrogate Key
•	Slowly changed Dimensions
•	Confirmed Dimensions
•	Write-back
HYPERION ESSBASE 11.1.1
•	Hyperion Analytic Solutions
•	Hyperion Architecture
•	Hyperion Essbase Architecture
•	Hyperion  Essbase  Analytical   Architecture
•	Hyperion  Essbase  Administration Server Architecture
•	Configuring   Essbase   Server
•	Configuring Essbase Administration Console
•	Creating Essbase  Analytic application and database
•	Explanation of  essbase components like Database Outline , calc  script 
        Rule File  &  report Script  
•	Dimensions
o	Standard Dimensions
o	Attribute Dimension
o	Dense & Sparse Dimensions
•	Dimension Properties
o	Dimension  Properties
o	Storage Properties
•	Members
•	Member Properties
o	Consolidation Properties
o	Storage Properties
•	Time balance Properties
•	Variance Expenses
•	Skip Options
•	Dynamic Time Series (DTS members)
•	Building Outline
o	Using manually
o	Using rule file with dynamic dimension build methods
•	User Defined Attributes (UDA ‘s)
o	Building manually dynamic dimension build methods using rule file
•	Shared members
o	Building  Manually , dynamic dimension build methods using  rule file
•	Two-pass
•	Building dimensions using Rule file with dynamic dimension Build Methods
o	Generation Reference
o	Level Reference
o	Parent\child Reference
•	Loading    Data  into  Outline With Rule (with   realtime Scenarios)
•	Loading  Data  into Outline without Rule file (freedom data loading)
•	Types  of   Free form data loading
o	Loading data from excel
o	Loading data using import from export data file
•	Explanation Excel Add-in  recover
•	Building  Reports  with  Excel  Add-in
•	Creating Formulas with Real time scenarios
•	Building Reports with Report scripts
•	ESSCMD & MAXL
•	Interactive.
•	Batch process
•	Differences between BSO&ASO
•	Outline back & Recovery 
•	Data Backup & Recovery
•	Creative Users/Groups
•	Creative Filters
•	Migration Process
•	Partitions
•	Creative MDX formulas
•	Optimization Techniques
•	Outline optimization
o	Data load Optimization
o	Data Script Optimization
o	Database Optimization using Attribute Dimensions
o	Database Optimization using  Data settings 
WEB-ANALYSIS 11.1.1
•	Hyperion Web-analysis
•	Hyperion Web-analysis Architecture
•	Design  new  reports
•	Discussion & functionality of Different Hyperion Web-analysis objects to
•	Design Reports
•	Cube Navigator , panel  ,split panel ,Combo Box ,Service Button,
        Selection ,Subscription ,Image , Label, Text area etc.
•	Advanced web-analysis Tools
•	Customized column calculations
•	Design of Header &Footer Sections
•	Design new reports with real time reports 
HYPERION PLANING 11.1.1
Hyperion Planning Overview
•	Hyperion Planning Architecture
•	Hyperion Essbase Analytical Server 
•	Hyperion planning   Server
•	Web server(Tomcat server)
•	Hyperion planning  Application Objectives
Setup Steps For New Application
•	Hyperion Planning Application setup
•	Hyperion Planning Configuration with
•	Hyperion ESSBASE
•	Oracle
•	Planning server
•	Tomcat server with Hyperion planning web based  Application
o	Create New Hyperion planning Web Based Application
o	Create  New Hyperion planning Database (plan type) 

MANAGE WEBFORMS
o	Create new Web form  folders
o	Create  new  Web forms
o	Add ,Edit ,Delete Web forms
o	Design new data Web forms with Wizard with Row , Column ,POV  
        &page layout
o	Load data into planning applications
o	Dimensions members selections with functions
o	Supporting   Details
Dimensions
o	Open Existing Dimensions
o	 new dimensions
o	Add,Edit,Move,Delete members under dimensions
          Users/Groups.
o	Create New Users
o	Create New Groups
o	Assign Users under Groups
Security  Permissions.
o	None
o	Read
o	Write
o	Assign   Security   permissions   to   Dimension  members
o	Assign    Security   permissions to web forms
Alias Tables
o	Create new Alias Tables.
o	Clear data from Alias tables
o	Copy Alias Tables  from  SOURCE  to TARGET


MANAGE TASK LIST
o	Creating task lists
o	Tasks lists overview
o	Navigating Task Lists
o	Working   with task list folders
o	Building task lists
o	Assigning   access to task lists
o	Validating task lists
o	Reporting on task lists
Manage Process.
o	Planning units
o	Plan cycle  
o	Annotations
Copy Version.
o	Copying   versions.
Set Versions.
•	setting up E-mail from Workflow notification
o	Managing the budgeting process
o	Managing rules from   Hyperion  planning   web
o	Business rules from  Hyperion  planning web
o	Creating global variables
o	Setting up  audit  trails
o	Hyperion application link (HAL) process.
Setting Up Exchange Rates.
o	Currencies and exchange rates
o	Exchange   rated tables overview
o	Creating exchange rate tables
o	HSP_Rates Dimensions
o	Generating currency conversion Calculation scripts
HYPERION FINANCIAL REPORTS
o	Hyperion reports feature
o	Hyperion reports architecture
o	Hyperion reports design  objects
o	Create data base connection
o	Design new report
o	Design report with real-time reports 
o	Change database connection.

•	Explanation of Essbase components like Database Outline,calc script
        Rule file &report Script