Hyperion Interactive Reports

OBIEE and Hyperion
Amit Sharma

Note : You can download the video tutorial for the same. Plz see the below link of video tutorial.


1) Hyperion Interactive Reports and exploring its features

2) Oracle Business Intelligence (OBIEE) and exploring its features.

3) Creating Essbase Cube using Essbase Studio and reports in Web Analysis.

4) Creating Essbase Cube using Essbase Studio and reports in OBIEE Answer

Step#1 Open IR Studio

Step#2 Creating a new Database connection is always the first step to retrive data from any database.The below screen shows how to connect to database I’m using MS Access to Create Sales Analysis Report

Step#3 IR has no propertory driver for MS-Access so you need to select ODBC-ODBC Connectivity type.(In another example will show you connecting with Oracle Database)

Step#4 Select the DSN the once you created to connect to your database. Slaes_Analysis_DSN in this example

Step#5 The connection is saved as seprate file with .OCE extention Open Database COnnectivity.
Step#6 The connection is created now its time to create the query.The query will be created based on the business requirement. Below is the list of reports needs to be created and corresponding datamodel is given.
Requirement #1 Revenue_by_quarter
Requirement #2 countable_by_quarter
Requirement #3 Revenue_by_store
Requirement #4 Countable_by_store_type
Requirement #5 Revenue_by_state
Requirement #6 Revenue_by_item

Note: See the attached sheet to understand the business requirment :http://www.box.net/shared/sfyrd26c5r
a) Requirement #1 Revenue_by_quarter Report Layout

b) Requirement #2 Revenue_by_quarter Report Layout

b) Requirement #6 Revenue_by_item
c) Hierarchy Model
d) Data Model
Note : Download the Database from http://www.box.net/shared/fl0liqn69v
Step#7 In order to build the report you need to have[ Below information must be given in High Level Documentation]

1) Report Layout
2) Data Model [
Dimensions/Member/Fact required to build report, Joining information
3) Data Mapping Document.[Which element maps to which table.column]
Once you have all the information, then you are ready to create report. The first step to create report is to build the Query. The IR query is equalent to SQL Query. The SQL query format is
Select Col1, COl2 from tablename where <condition> order by <col>
IR equalent Col1,Col2 = Request
Where Condition = Filter
Order By = Sort
Step#7 Drag and Drop the Dimension and fact tables from the Elements Tab and place in content pane as given below. Make sure you draw the correct joining. You’d better ask your datamodeler to provide you correct joining criteria.

Step9 Process the query the below output should be generated.

Step10. You can see the report layout, the business wants to see the report in cross tabular layout[Pivot] so we need to place one pivot rather than displaying the report in tabular format.So we need to insert Pivot.
Step#11 In order to design Pivot we need to specify its Column, Row and fact. Per business requirement we need to display the Quarter in Col and Fact in row. So whlie desiging Pivot we need to select Dimension and Fact appropriately.
Step#11 Business people want to see the graphical Chart besides the Pivot so we need to design the Chart as well based on the query.
Step#12 Now lets draw the chart and place all the Object togather.
Step#13 Its time to place all these objects togather so we need to place Pivot and Chart togather in Dashboard. First of all you need to add the dashboard Insert->Dashboard
Step#14 And Finally our Dashboard would look like this. So the one peice of report is ready. Similarly we need to create report for other requirements. And one more important thing is that we need to design the “Level Of View” or Dimension Hierarchy so people can drill down /up or analyze the requirement with different views.Step#14 The other peice of report is

Step#15 And complete Dashboard would look like this.

Step#16 Download the complete tutorial from

Download the video tutorial from

[use codec http://www.gotomeeting.com/codec to view the videos]

Amit Sharma

About Amit Sharma

BISP Solutions Inc. was founded in 2012 as a IT consulting and service provider, specializing in Oracle EPM/BI technologies. Our primary objective is to use our expertise to offer best EPM/BI solution and being cost effective. In a relatively short period of time, we have successfully become an information technology company having a long list of clients in North America. BISP Solutions has been providing solutions to unique customer requirements and has a proven track record and ability to deliver high end business EPM solutions that meet your business goals. BISP Solutions EPM solutions have helped various customers in EPM space and earning a reputation of consistently exceeding our customer expectations. We bring tremendous value to our customers due to ability to replicate with ease, deploy at a faster pace in a very flexible global delivery model with lowered costs. Our ultimate goal is to save time and money of our business partners by delivering a highest quality of solution/services. We believe that working closely with customer and having detailed understanding of the business domain is the key to success. Our iterative methodology has proven to be very successful in this regard. Our experts are Oracle certified and committed to specializing in EPM and BI services, providing the highest flexibility while designing your EPM solutions. BISP business methodology is based on 5C’s. 1. Commitment - As a wise man once said, “Commitment is what transforms a promise into reality”. We are committed in providing the best possible solution to you. 2. Collaboration - We collaborate and communicate with you to understand your business requirements and using our collective knowledge to provide a solution that not only follows cutting edge technology and best practices but is also simple to use. 3. Consistent - We guarantee our solutions and have been consistent in delivering cost effective solutions to our business partners. 4. Cost Effective – This is where we shine. We provide solutions that while being cutting edge are also financially feasible. Our Onsite / Offsite (consultants based in US) model provides the best in technology solution while keeping the cost significantly low of what leading consulting companies charge. 5. Customized – While we can implement out of the box solutions, we strive to provide a solution that works for you.
This entry was posted in Hyperion Interactive Reports. Bookmark the permalink.

3 Responses to Hyperion Interactive Reports

  1. Sailesh says:

    Hello Amit,

    Excellent Stuff. I appreciate your efforts in making those long and clear, in-depth presentation. Hats-off to you. I mailed you for more information.

    Thanks in Advance,


  2. ZAREMA says:

    Thanks the author for article. The main thing do not forget about users, and continue in the same spirit. http://odessacity.net/


  3. Ramesh says:

    Hi Amit,

    I really appreciate for the effort that you have put in making the videos,thanks a lot…

    Let me know if you any anymore videos on Dashboard desiging using Hyperion Reporting




Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s