Why this blog?

Finding information from Oracle/Hyperion can be difficult as you search the thousands of pages of documentation. So I'm creating this blog with all of my tables and matrices for the Oracle Hyperion products. Questions like - How does Smart View compare to the Excel add-in? When should I use Financial Reporting or Web Analysis? I thought I would share this information with you in the simple format of tables and maybe a few bullet points. So no lengthy paragraphs on this blog... but hopefully some helpful Oracle Hyperion information.

Sunday, October 12, 2008

UFC: Web Analysis vs. Interactive Reporting

Pretty exciting matchup, right? At a high level review, you'll note that Web Analysis and Interactive Reporting overlap on a number of key features. So which tool is the right tool? Historically, IR was good at relational reporting and analysis. WA was good at Essbase reporting and analysis. With version 9.3.1, Interactive Reporting introduced a new CubeQuery feature that now allows it to better report against Essbase (prior to 9.3.1, there were many frustrations when trying to use IR with Essbase). CubeQuery closely models the functionality that is provided with Web Analysis. What is really cool? You can now easily combine Essbase and relational data very easily in IR dashboards and reports.

Let's look in a bit more detail, comparing the advanced analytic capabilities between IR CubeQuery and WA:


WA Studio

WA Workspace

IR Studio

IR Web Client

IR HTML

Basic Drilling

Yes

Yes

Yes

Yes

Yes

Swap Rows and Columns

Yes

Yes

Yes

Yes

No

Client install

Required first the first time

No install necessary

Client application

Required the first time

No install necessary

Adhoc Query

Yes

Yes

Yes

Yes

No

Member Selection

High

High

Medium

Medium

None

Traffic Lighting

Yes

Yes

Yes – Called Spotlighter

Yes – Called Spotlighter

No

Formatting / Presentation

Yes

Yes

Yes

Yes

No

Save Personal Queries

Yes

Yes

Yes

Yes

No




Next let's compare the dashboarding capabilities between the two:


Web Analysis

Interactive Reporting

Complexity to Create

Medium

Medium - Complex

Requires Programming

None

Yes – Java scripting

Flexibility

High

Very high

Drillable within the Dashboard (Essbase sources)

Yes

No (but in future versions)

Present Essbase Data with Relational Data

Yes – but not well

Yes

Data Controls

Yes

Yes

Risk (when using Essbase as data source)

Low

Medium-High (new)

Time to Implement (when using Essbase as a data source)

Lower

Higher (new)




So in summary, what is the best tool?

It depends…

  • Technically you could use both but …
  • IR requires Java Scripting knowledge for creating and maintaining dashboards
  • Learning curve for both products (similar concepts but steps and design considerations are completely different)

  • Web Analysis if you are only reporting on Essbase
  • Interactive Reporting if you report against relational sources
  • Interactive Reporting if you report against Essbase and relational sources in the same report or dashboard with considerations*
    *Java scripting
    *New (available in 9.3.1); Some fixes and enhancements in 11.1.1
  • Web Analysis if you don’t have any technical resources available / programmers (Web Analysis is easier to learn for administrators and no Java Scripting or “coding” required)
  • From an basic end user perspective using Essbase, IR and WA have the same functionality for the most part (there may be a few more features in WA)
    - Keep only, remove only
    - Navigation is different between the 2 tools – training consideration
  • From a power end user perspective, Web Analysis provides more adhoc advanced analytic features against Essbase



16 comments:

David Williams said...

Thanks for Information Our Online-Training-Informatica proven expert in all Hyperion Modules like Hyperion Financial Management, Hyperion Financial Data Quality, Hyperion Financial Reporting, Hyperion Essbase, Hyperion Planning, Smart view and Data Relationship management.Hyperion Essbase Online Training

Qa Tools said...


This information which you provided is very much useful for us.It was very interesting and useful for qa online training.We also providing qa online training institute in USA.

Kathiresan Muthu said...

Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

Thanks,
kathiresan

Kathiresan Muthu said...

Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??

Thanks,
kathiresan

Martina Christy said...

Thanks for sharing this excellent post. Its really very informative and interesting. Keep update your blog. For a best Android training in Chennai please refer this site.
Regards....
Android Training in Chennai

Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,packaged applications,business applications, Web services, data migration
Business intelligence, Business Development, Software Development etc.


Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp

Amirtha rao said...

I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
Regards,
Salesforce training |Salesforce course in Chennai

Abina Ragav said...

Wonderful article, very useful and well explanation. Your post is extremely incredible. I will refer this to my candidates...

android training in Chennai

Aamala Ahona said...


A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you. Helpful as always. Every post you write produce a massive value to your readers that is the only reason it is so popular and has great authority.

Peridot Systems Chennai Reviews

Ridhima said...





That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.

SAP training in Chennai

Ridhima said...

That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.


PHP training in Adyar

rakesh said...

nice posts..
SAS Institute introduced the SAS Certified Professional Program,training proper understanding of how the SAS software works. Among the five certification programs that SAS Institute has come up with, SAS training can be considered as the entry point into the big data and the data analytics industry.
SAS online training in hyderabad

Geetha said...

Very attarctive information.great to know about this new methods.The points are really motivable for the readers.Great and useful article.
SEO training in chennai adyar

Shalini said...

Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
Digital Marketing Company in India

Sathya G said...

I read this content and this was really awesome.You provided a very article.I hope this information may change my business carrier.I can remember these things whenever taking the decision.
SAS Training in Chennai

janu3vj said...

Thanks for the awesome share
We at Colan Infotech Private Limited best web design company in chennai,is Situated in US and India,
will provide you best service in qa testing services
Design Services and Colan Infotech has a group of exceedingly dedicated, inventive and creative experts with an energy for delivering exciting ,
helpful and stylish Web and Mobile Applications, We are one of the best software testing services company
and of course we stepped in bangalore too we are best qa and testing services
can provide quality assurance and testing services,
we are the best among the software testing company india