Thursday, September 4, 2008

Hyperion Interactive Reporting Disadvantages

Hi,

You may want to read my earlier post Qlikview Vs Others


You may also be interested in similar posts.
Hyperion Interactive Reporting Enhancements-Charts

Hyperion Interactive Reporting Enhancements- Live Charts

Hyperion Interactive Reporting Tutorial

Hyperion Interactive Reporting Disadvantages

There are some points which I found Interactive reporting lacks as compared to Qlikview.
This would help users who are evaluating IR and Qlikview.

1. To create a selection box (or LOV) and link it to report objects in the dashboard, we need to write some script and cannot be done with drag and drop features. You can do this using Dashboard studio using wizards but the way you do it in Qlikview is just amaging and even users without having any knowledge of the tool can do it in few seconds. Though in version 11, Oracle has introduced some charts and slider which can be interlinked to see the data changing but needs lots of improvements. Hyperion Web Analysis has this feature present.

2. The way we can do what-if analysis in qlikview with the help of slider and variables is really quick and effective. Nothing of that sort can be done in Interactive Reporting. But the concept is IR is not made for that purpose. The way to do this is Essbase to which we cannot just compare Qlikview.

3. To create pivot reports with member showing(+) sign to further drill down and (-) sign representing the last member is not possible in IR. Qlikview can do this very well.

Manohar Rana

9 comments:

Gata said...

Hi Manohar,

I need to know Few things about hyperion.My requirement is like this. I need use a tool which can genarate report using client web page.Will it be possible with Hyperion? I need to know how this can be Done? What are all the Hyperion products i need to install to achive this?

Now i know to create report on Hyperion IR. I have installed hyperion Shared services as well.
Kindly Help.

I would like to know about hyperion architecture as well.


please help me out.

If you have any documents send it to me @gatha86@gmail.com

Manohar Singh Rana said...

You can create reports in Hyperion IR client studio which is a windows client component. Then you can publish these reports in Hyperion Workspace which is a pure web client.
You can also create reports in Hyperion Webanalysis which is also a web client.
You need to install foundation (includes shared services)components of version 11 and Hyperion IR client.
You have not provided any details of your version.
Search the blog to know the architectre.

Regards

Manohar Rana

kamran said...

HI,
How much SQR does one need to know to develop reports in IR? What can you do in IR with SQR ?
Excellent blog by the way.

Kamran

Manohar Singh Rana said...

Hi Kamran,

I dont think IR has anything to do with SQR. I think in IR you can create hyperlinks to call sqr reports. I never thought on this. But surely to know IR, SQR is not required.

bammidi said...

Hello Rana,

I want to learn HFM and HIR tools from you. Is it possible to come and train our team in mumbai. we despirately need of a traineer who teach us at intermediate level. plz let me know asap. plz provide your contact number or emailid so that we can reach you...

Regards,

hariprasad

sara said...

Dear Manohar
any reporting tool has two sections
one for administration and one for making reports
I want to know which type is this?
is this similar to discoverer tool?
Can this be hooked up with SSO?
Can we get reports from BPEL using this?
What is the advantage of this over the discoverer tool?
In advance I appreciate your help
All the best,
Sara Sharifi Sedeh

Soumitra said...

Hi Manohar,
I having a question.Can I extract the results comupted column definition through script?If I right click on computed columns of results,then through modify column property I can get the definition.Can I achieve the same thing using dashboard script?Please guide me.My email id is
soumitra.chakraborty@gmail.com

Redspark said...

IR 11 can do sliders and other features that Qlikview has but it requires scripting and it is not pretty nor necessarily easy to do.

Keep in mind that IR11 is more of an Adhoc reporting tool. You can build one-off queries with IR11 much faster than Qlikview.

Redspark said...

IR 11 can do sliders and other features that Qlikview has but it requires scripting and it is not pretty nor necessarily easy to do.

Keep in mind that IR11 is more of an Adhoc reporting tool. You can build one-off queries with IR11 much faster than Qlikview. In fact, I like to use IR11 to develop the SQL queries that I fuel Qlikview with. It balances the two apps out.