Sunday, July 13, 2008

Hyperion Reporting and Analysis Architecture

Lets understand the various components of Hyperion:
Workspace is a common window to view the contents of all Hyperion components.
Hyperion Reporting and Analysis:
One zero-footprint Web-based thin client provides users with access to content:
● Financial reporting for scheduled or on-demand highly formatted financial and operational reporting from most data sources including Hyperion Planning – System 9 and Hyperion Financial Management – System 9
● Interactive reporting for ad hoc relational queries, self-service reporting and dashboards against ODBC data sources
● SQR Production reporting for high volume enterprise-wide production reporting.
● Web analysis for interactive ad hoc analysis, presentation, and reporting of multidimensional data.
Hyperion Reporting and Analysis Architecture:(This diagram is taken from some Hyperion Document)

Client: The client tools consist of
Workspace: It is a DHTML Zero footprint web client and provide the user interface for viewing and interacting with the reports created using Authoring studios.
Authoring Studios: These are the client interfaces to create the reports and includes-
(a) Hyperion Interactive Reporting Studio: Windows client where you can connect to different data sources including the flat files and build very interactive presentation reports like reports in simple tabular format, pivot reports, graphs and charts with drill anywhere feature which means that you don’t have to define the hierarchy or drill path and slicing and dicing and Dashboards with many features like hyperlinks to the details reports and embedded browser which can be used to view any other web application to open within the Dashboards.
(b) Hyperion Financial Reporting Studio: Windows client where you can connect to the multidimentional data sources and create highly formatted financial reports by simply dragging and dropping rows and columns and defining page breaks.
(c) Hyperion SQR Reporting Studio: Windows client where you can connect to wide range of data sources and produce high volume pixel perfect operational reports and can be scheduled.
(d) Hyperion Web Analysis: Java applet where you can connect to different data sources using JDBC and build interactive reports and dashboards.
Smart view for office: This is a tight integration with Microsoft Office tools where ou can do analysis like drill downs, keep only and remove only options, POV manager, data refresh, copying data cells and pasting to MS Word and Powerpoint which automatically gets refreshed if the data changes in the source etc. There is one more component in smart wiew which is Hyperion Visual Explorer(HVE), where again you can view the data in presentable interactive graphs and charts.
Application Layer: It consists of two parts :
Web Tier: It consists of two parts (a) Web server- to send and receives content from the web clients. (b) Application server- it is a J2EE application server.
Web server and application server are connected using an HTTP connector.
The web Tier hosts the web applications like workspace, web analysis, interactive , SQR and financial reporting applications.
2. Services Tier: It contains services and servers that controls the functionality of the web applications and clients. Core services handles repository information, authorization, session information, documents publication.


Anonymous said...

I am new to hyperion. Our client want us to use Interatice reporting. I would like to know how to install and what other hyperion products i need.

krishna said...


I have one doubt in HFR is

I want to disply the row numbers in workspace

pls let me know the answer for this.


Baskar said...

Hi Raina,
Need help. Installed and configured Oracle EPM, it has Foundation services,Essbase & planning

But lot of issues.
1. Planning is not enabled, it is disabled.
2. Trying to login to Hyperion, it says applications are not running.

Please help.

venkat said...

what is the difference between range and xrange

venkat said...

iam new to hyperion daily iam studying ur bogs it is vvvery helpfull thanks in advance my question is what is @xref

prem said...

Hi Venkat,

An XRef in 3ds Max is an externally referenced file or object. XRefs allow multiple animators and modelers to work on one scene at the same time without interfering with each other's work.

There are two ways to XRef another scene:

1.XRef Scene

The File > XRef Scene command XRefs an entire scene. For example, a classic use of this command is to bring in a scene that appears as a “set” for an animation you create.
2.XRef Objects

The File > XRef Objects command XRefs individual objects or materials. For example, you might be working on the model of a building, and fill it with furniture created by other artists.

You can also XRef the manipulators and modifiers associated with the objects you XRef.

Refer the link for more information on this:

Roopa said...


Do we still have "authorising studios" in oracle hyperion 11.1.3?


Chinmay said...

I wanted to implement obiee with Universites and through bi-apps which subject areas or module to be implement,if not what is the prebuilt or any other solution for the same

MANISH said...

Hi Rana,

Need your help.

while querying on hyperion cube from obiee interface, query is not returning the records and I am getting the error message "Fri Sep 9 08:07:46 2011]Local/USOLDDD/USOLDDD/USOL/Error(1200646)
Internal error: Set is too large to be processed. Set size exceeds 2^32 tuples."

This is a production problem,need to resolve quickly but I am not able to do so.


Vanita Sharma said...

i am able to view snapshot