Business Intelligence – Oracle

Archive for June 7th, 2008

Hyperion Financial Reporting – Getting Started

Posted by Venkatakrishnan J on June 7, 2008

Though BI EE has connectivity to Essbase, there are still quite a few gaps that would have to be addressed before it can be used for creating financial reports out of Essbase. I hope 11g can bridge that gap. So, lets look at another tool today called Hyperion Financial Reporting. Hyperion Financial Reporting (HFR) is a component similar to BI Publisher. The major difference between these 2 products is that, BI Publisher can create financial reports only out of relational databases. But HFR can report out of Multi-dimensional data sources like Essbase, MSAS., SAP-BW and also on Hyperion Financial Management (HFM). Also, HFR provides drill down, drill backs etc out of the box which BI Publisher currently does not. I hope BI Publisher roadmap covers integrating features of HFR in the long run. In order to install and configure HFR there are 4 components that one would have to download. They are

1. Shared Services
2. BI Plus Services
3. BI Plus UI Services
4. BI Plus Client

HFR reports are generally created out of a client component called as Reporting Studio. All the reports created out of this studio are then published into the Hyperion BI Plus Workspace so that users can access the reports through a URL. Once the installation is done, we would have to create an user in the shared services and provision it to access BI Plus services.

     

     

The reporting studio connects to the Financial Reporting Server through the user created above.

     

Now, lets start with creating a simple report. As you see below, the reporting studio interface looks very simple and uncomplicated. But the features of this product are so good that you cannot think of using any other tool for doing Multi Dimensional financial reporting.

     

Lets start with creating a simple report on the Basic cube of the Sample application. We start with creating a grid in the report which would in turn ask us to provide the connection details.

     

     

Once this is done, lets choose Year in the Rows and Market in the Columns and see what happens.

     

Now, lets choose some dimension members for the Year and market dimension.

     

As you see we can choose any specific level for reporting (which is a major drawback currently in BI EE).

     

In order to enable drills, choose the member for which you want to drill and enable “Allow Expansion”.

     

Now, save this report and view the report from workspace (Since in my case there is no data in the cube you would see only #Missing in the report. )

     

As you see you can also drill down/drill back on all the levels.

     

In a future blog entry we shall be looking at some complex reports and how those can be created in HFR.

Posted in All Posts, Hyperion Financial Reporting | 36 Comments »