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



20 comments:

Unknown 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.

Anonymous 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

Unknown 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

gowthunan said...

It’s always so sweet and also full of a lot of fun for me personally and my office colleagues to search you blog a minimum of thrice in a week to see the new guidance you have got.
industrial course in chennai

pragyachitra said...

I really like the dear information you offer in your articles. I’m able to bookmark your site and show the kids check out up here generally. Im fairly positive theyre likely to be informed a great deal of new stuff here than anyone
angularjs-Training in sholinganallur

angularjs-Training in velachery

angularjs-Training in pune

angularjs Training in bangalore

angularjs Training in bangalore

angularjs Training in btm

afiah b said...

Thank you for taking the time and sharing this information with us. It was indeed very helpful and insightful while being straight forward and to the point.

Selenium training in Chennai | Selenium training institute in Chennai | Selenium course in Chennai

Selenium training in Bangalore | Selenium training institute in Bangalore | Selenium course in Bangalore

Selenium interview questions and answers

Selenium training in Pune | Selenium training institute in Pune | Selenium course in Pune

sheela said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging.
Devops online Training
Online DevOps Certification Course - Gangboard

easylearn said...

Hi,
Good job & thank you very much for the new information, i learned something new. Very well written. It was sooo good to read and usefull to improve knowledge. Who want to learn this information most helpful. One who wanted to learn this technology IT employees will always suggest you take hadoop training in bangalore. Because data science course in pune is one of the best that one can do while choosing the course.

Janardhan said...

I Got Job in my dream company with decent 12 Lacks Per Annum salary, I have learned this world most demanding course out there in the current IT Market from the Hkbk group of institutions experts who helped me a lot to achieve my dreams comes true. Really worth trying

Vijiaajith said...

very nice, keep sharing
interview-

questions/aptitude/permutation-and-

combination/how-many-groups-of-6-persons-can-be-

formed


tutorials/oracle/or

acle-delete


technology/chrom

e-flags-complete-guide-enhance-browsing-

experience/


interview-

questions/aptitude/time-and-work/a-alone-can-do-1-

4-of-the-work-in-2-days


interview-

questions/programming/recursion-and-

iteration/integer-a-40-b-35-c-20-d-10-comment-about-

the-output-of-the-following-two-statements


eTechno Soft Solutions said...

This is also a very good post which I really enjoyed reading. It is not every day that I have the possibility to see something like this,

Best Microsoft Training in Bangalore for Microsoft, we provide the Microsoft training project with trainers having more than 5 Years of Microsoft training experience, we also provide 100% placement support.

Trishana said...

Hi...
Nice Blog. Its very important to get a knowledge about all the features of the tool which we are using. You provide a comparison chart which is the best. In one shot you can choose a suitable tool as per your business requirement.

Master Blogers said...

jackpot win18bola
win18bola
judi cmd368

Jayalakshmi said...

Wonderful article! It was very superb and I really appreciate the admin in your valuable post. This is very interesting and I gain myself from your post.
hardware and networking training in chennai

hardware and networking training in tambaram

xamarin training in chennai

xamarin training in tambaram

ios training in chennai

ios training in tambaram

iot training in chennai

iot training in tambaram

praveen said...

First i got a great blog .I will be interested in more similar topics. i see you got really very useful topics, i will be always checking your blog thanks.
data science training in chennai

data science training in porur

android training in chennai

android training in porur

devops training in chennai

devops training in porur

artificial intelligence training in chennai

artificial intelligence training in porur

shiny said...

The strategy you have posted on this technology helped me to get into the next level and had lot of information in it



hardware and networking training in chennai

hardware and networking training in annanagar

xamarin training in chennai

xamarin training in annanagar

ios training in chennai

ios training in annanagar

iot training in chennai

iot training in annanagar

deiva 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....
java training in chennai

java training in omr

aws training in chennai

aws training in omr

python training in chennai

python training in omr

selenium training in chennai

selenium training in omr




CoolKids said...

orang sakit togel

CoolKids said...

primbon-angka This book will meet your expectations of direct sources so that you have a justifiable basis for argument. How complex is the dream interpretation written in this book, including its strengths and weaknesses.