Hyperion

1
Hyperion Web Analysis
Created By Amit Sharma Hyperion
Trainer Contact Point learnhyperion.wordpress.com
2
Creating Database Connection
The first step before creating a report
is to create Database connection. The Database
connection is the direct link to access the data
from database and represent in form of reports.
The data source for analyzer can be
1) Essbase 2) Financial Management 3) Sap BW 4)
Relational DB
3
Creating Database connection.. Step 1
The database connection is established using 4
steps. 1) Specify Server info. 2) Specify
Database info. 3) Appling formatting. 4) Relation
Drill-Through
Give Essbase server Name, username and password
4
Creating Database connection.. Step 2
Specify Application name and Database name.
The list of Application/Databases given in the
left.
5
Creating Database connection.. Step 3
Specify measure Sales as currency format
6
Creating Report using Report Wizard Step 1

• Hyperion Analyzer report wizard
  provides an automated series of six dialog boxes
  that steps you through the process of creating a
  report.
• Specify Data Source. Well specify the Data
  Source the one which we created in previous
  slide.
• Select one of the following database
  connections
• Analyzer Essbase
• Analyzer Relational
• Analyzer SAP BW
• Analyzer HFM

7
Sample Report
Row Dimension
3D View 3D View 3D View 3D View 3D View
    Qtr1 Qtr2 Qtr3 Qtr4
John New York 1000      
John California 23      
John Texas 63446      
John Ohio 6633      
John Illnois 3466      
    Qtr1 Qtr2 Qtr3 Qtr4
Mac New York        
Mac California        
Mac Texas        
Mac Ohio        
Mac Illnois        
Page Dimension
Row Dimension
8
Creating Report using Report Wizard Step 2
Select dimension which will appear on Row
Dimension
9
Creating Report using Report Wizard Step 3
Specify Column Dimension
Specify Page Dimension
Customizing filters
10
Creating Report using Report Wizard Step 3
Display top/bottom 5 bottoms
Display only selected data
11
Final Report
Column Dimension
Page Dimension
Row Dimension
12
Report Advance Analysis
The Browse option helps to add/remove
Dimension/members
13
Browse Option
Newly added member
14
Creating New Report (Non-Wizard)
Selecting Report type
15
Selecting the Data Source
Selecting the Data Source as Spreadsheet
16
Cube Navigator
Selecting the Scenario Dimension under page
Selecting the Period Dimension under Columns
Selecting the Market Dimension under Rows
17
Sample Report
Object 2 Chart with City as Dropdown selection
Checkbox selection for scenario selection
Browse Year Dimension member dynamically
Implementation of Write back functionality
Implementation of Write back functionality
Object 1 Table with City as Dropdown selection
18
Adding cell Notes
Add Cell notes info
Double click on any cell to activate cell
note windows
Insert cell note. Some description about the the
given cell
19
Sales for Florida Jan Month
Sales for Florida May Month
20
Adding Service Button to Reports
21
Using Sort operation
Selecting of sort operation
22
Sorting Sales data based on Qtr2
Sales Data Sort in inc order
23
Print Option
Printing Object 2. There are two objects. Object
1 Table, Object 2 Chart. In the example given
below we are printing Dataobject2 based on
condition Florida
24
Using Traffic Light
25
Traffic Lighting
26
Exporting Data to Excel
27
Using Drill Options
After Drill up Month view
Before Drill up Quarterly view
28
Additional Drill options
29
Changing Year Members Dynamically
30
Analyzing Data
31
Column
32
Exporting Data
33
Selecting Data
34
(No Transcript)
35
Questions?
36

• THANK YOU
• To learn more about hyperion please visit
• http//learnhyperion.wordpress.com