Hyperion Financial Reporting

The final goal of Hyperion Financial Reporting Studio is to analysis data and information and publish report on the basis of analysis, be it Actual , Forecast or Budget report.
Financial Reporting, can graphically design and present analytic data. Designing of traditional financial report formats such as cash management reports, profit and loss statements, and balance sheets.

Open Financial Reporting Studio

All Program > Oracle EPM System > Reporting and Analysis > Financial Reporting Studio

 

Connecting Financial Reporting  

Enter UserID , Password and Server name for login in to Hyperion Financial Reporting.

 

Financial Reporting  

You can create a new folder for keeping reports.

File > New > Report

 

Template for New report

 

Creating Database Connection with Essbase

You required one Grid to view report. When insert grid in to report, you need to build database connection.  

Click “New Database connection”

Select database type “Essbase”

 

Enter Database connection name and search for the application you want to use.

Once all settings complete click ok.

 

 Once connection build successfully click ok...

 

Creating Simple Report

Once Grid is connected with the database. You will have all available Dimensions in POV and attribute dimensions in separate group box. You can create MDX query by using all available dimension.

 

Drag and Drop the dimensions in the required fields.

Select pages, columns and rows fields.

 

Sample Product Sales Report Web Preview

Essbase Configuration File

 

With the essbase.cfg configuration file, you can customize your Essbase Server configuration. Settings specified in the essbase.cfg file usually apply to the entire Essbase Server. These settings override the Essbase defaults and apply to all databases within all applications on the Essbase Server.

You can create one essbase.cfg file for server settings, and another for client settings. Assume settings are for the server unless otherwise noted.

 

Original Essbase configuration file

Essbase Backup and Recovery

Backup

To prevent data loss we use backup and recovery. You take of backup of data base so that when any miss happening accord. You can get back your data. There are many type of database backup.

Types of backup

  

1)     Hot Backup: - Perform backup while server is up and running mode.

      2)     Cold Backup: - Perform backup while server is not in running mode.

File System Backup Types

A complete file system backup includes an entire system directory. For example, backing up the Hyperion home directory backs up all installed EOM system Products. You can also perform file system backup of these types and frequencies:

1. Post installation - Directories created or modified if you reconfigure products
2. Daily incremental - New directories or files or those modified those modified since the previous day
3. Weekly full- All files in the directories for which you perform daily incremental backups
4. As needed - Data that is modified infrequently

Common Backup

1. Preparing for Backup: - Server required to be prepared for performing backup. Server should be in read only mode or it should be in idle mode.

2. Database Backup: - First take backup of database files. You must take database backup in form of text file or other database form.

3. File System Backup: - Secondary you should have backup of all supporting files. It is difficult to recover database without supporting files like outline files. Rule files or index file.

Steps for taking backup

You should fallow fallowing steps for performing backup operation.

Step -> 1     Server should be in Read-Only mode.

Step -> 2     Perform backup operation.

Step -> 3     Revert Back server in to Read-Write mode.

Hot Backup: -

When you take hot backup your server should be in Read-Only mode.

Advantage of hot backup:-

1)     No server down time

2)     Analysis can be performed during backup

Disadvantage of hot backup:-

1)     Clint can’t modify value or insert data during backup

Caution: When you take backup of database, then your server should be in read only mode.

Enter in to Essbase server through command mode.

 Logged in successfully…..

 

 Command for changing mode of database in read only mode.
Maxl  “alter database begin archive”.
Syntax -> alter database Bsp.BspBD begin archive to file “c:\\BspBK”;

 

One file creates in the given path “C:\\BspBK”. 

 When you open this file into notepad, it will show you list of files to be backed up.

 

 Open Bsp folder from the fallowing path “F:\Hyperion\products\Essbase\EssbaseServer\app\Bsp”  

 

 These are the files to be backed up.

 

For checking that data base is read only mode try to insert data from client side.

You can see database can’t be updated from the client side.

 

Important Backup files

You have to take backup of fallowing files.

When performing a file system backup use the file system backup software of your choice.

1. essxxxxx.ind
2. essxxxxx.pag
3. databasename.eam
4. databasename.ind
5. databasename.otl
6. x.lro

Essbase files that you must manually backup

1.      essbase.sec

2.      essbase.bak

3.      essbase.cfg

4.      databasename.app

Database artifact files

1.      *.otl

2.      *.csc

3.      *.rul

4.      *.rep

5.      *.eqd

6.      *.sep

There are some more supporting file needs to be backed up. Copy all files and keep in a common folder. When any misshaping occurs you can recover from this folder. “BspBK” notepad shows necessary backup files but not complete backup files like “*.csc”,”*.rul”,”*.mdx”,”*.mxl”,”*.rep” and other.
Copy all below files and keep in to another folder.

 

 Backup folder: -

Create one backup folder and keep all supporting files into it.

 

Essbase Recovery

To restore a database, replace the files on disk with the corresponding files from backup. The application should be stopped, unless you are restoring from an export file. In that case, ensure the application is not accepting client connections.

Restoring Corrupted Databases

If there is a problem with any one of these essential database files, the entire database becomes corrupted and Essbase server cannot start the database.

1)     essn.pag

2)     essn.ind

3)     databasename.esm

4)     databasename.tct

5)     databasename.ind

Back Server in normal mode

Once backup done, you can change Essbase server mode into read write mode.
Command for changing read only mode to read write mode.
Maxl  “alter database end archive”.
Syntax - alter database Bsp.BspBD end archive;

 

 Now client can update data because now data base is in read write mode.