hyperion analyzer 31 july
TRANSCRIPT
![Page 1: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/1.jpg)
Hyperion Web Analysis
Amit SharmaHyperion Trainerlearnhyperion.wordpress.com
![Page 2: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/2.jpg)
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
![Page 3: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/3.jpg)
• The database connection is established using 4 steps.• 1) Specify Server info.• 2) Specify Database info.• 3) Appling formatting.• 4) Relation Drill-Through
•
Creating Database connection.. Step 1
Give Essbase server Name, username and password
![Page 4: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/4.jpg)
• Specify Application name and Database name. The list of Application/Databases given in the left.
Creating Database connection.. Step 2
![Page 5: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/5.jpg)
Creating Database connection.. Step 3
Specify measure Sales as currency format “$”
![Page 6: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/6.jpg)
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. We’ll 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
Creating Report using Report Wizard Step 1
![Page 7: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/7.jpg)
Sample Report
3D View Qtr1 Qtr2 Qtr3 Qtr4
John
New York 1000
California 23
Texas 63446
Ohio 6633
Illnois 3466
Qtr1 Qtr2 Qtr3 Qtr4
Mac
New York
California
Texas
Ohio
Illnois
Row Dimension
Row DimensionPage Dimension
![Page 8: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/8.jpg)
Creating Report using Report Wizard Step 2
Select dimension which will appear on Row Dimension
![Page 9: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/9.jpg)
Specify Column Dimension
Creating Report using Report Wizard Step 3
Specify Page Dimension
Customizing filters
![Page 10: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/10.jpg)
Creating Report using Report Wizard Step 3
Display top/bottom 5 bottomsDisplay only selected data
![Page 11: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/11.jpg)
Final Report
Row Dimension
Page Dimension Column Dimension
![Page 12: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/12.jpg)
Report Advance Analysis
The Browse option helps to add/remove Dimension/members
![Page 13: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/13.jpg)
Browse Option
Newly added member
![Page 14: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/14.jpg)
Creating New Report (Non-Wizard)
Selecting Report type
![Page 15: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/15.jpg)
Selecting the Data Source
Selecting the Data Source as Spreadsheet
![Page 16: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/16.jpg)
Cube NavigatorSelecting the ScenarioDimension under page
Selecting the PeriodDimension under Columns
Selecting the MarketDimension under Rows
![Page 17: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/17.jpg)
Sample Report
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
Object 2 Chart with City
as Dropdown selection
![Page 18: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/18.jpg)
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
![Page 19: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/19.jpg)
Sales for Florida May Month• Sales for Florida Jan Month
![Page 20: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/20.jpg)
Adding Service Button to Reports
![Page 21: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/21.jpg)
Using Sort operation Selecting of sort operation
![Page 22: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/22.jpg)
Sorting Sales data based on Qtr2
Sales Data Sort in inc order
![Page 23: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/23.jpg)
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
![Page 24: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/24.jpg)
Using Traffic Light
![Page 25: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/25.jpg)
Traffic Lighting
![Page 26: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/26.jpg)
Exporting Data to Excel
![Page 27: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/27.jpg)
Using Drill Options
![Page 28: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/28.jpg)
Additional Drill options
![Page 29: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/29.jpg)
Changing Year Members Dynamically
![Page 30: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/30.jpg)
Analyzing Data
![Page 31: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/31.jpg)
Column
![Page 32: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/32.jpg)
Exporting Data
![Page 33: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/33.jpg)
Selecting Data
![Page 34: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/34.jpg)
![Page 35: Hyperion analyzer 31 july](https://reader036.vdocuments.us/reader036/viewer/2022062405/555d863bd8b42a6c3d8b4ed0/html5/thumbnails/35.jpg)
Questions?