Business Intelligence should not be Hype, use it to answer these 4 golden rules, I included an explanation of the OBIEE Design Architecture with step by step approach to building Reports.

on Wednesday, 03 April 2013. Posted in Blog, Business Intelligence

Business Intelligence should not be Hype, use it to answer these 4 golden rules, I included an explanation of the OBIEE Design Architecture with step by step approach to building Reports.













BI should provide users the data and tools to answer questions that are important to running the part of the business you are responsible for

  1. Determine if the business is on track
  2. Identify where things are going wrong
  3. Take and monitor corrective actions
  4. Spot trends


Below is the OBIEE Standalone Architecture and an overview of its components

 OBIEE Architecture

  • Data Source --Contain the business data, users want to analyze. OBI supports Relational Database, OLAP databases, Flat Files, Spreadsheets, XML files etc .
  • OBI Web Server-- Provides the processing to visualize the information for client consumption.
  • Clients
    • Answers--Provides a self-service analysis platform for analytical needs.
    • Dashboards—Provides a way to organize related information for easy access.
    • Delivers---Used to create Ibots. Delivers alerts to subscribed users. It is integrated with dashboards and answers.
    • BI Analytical Server--- Provides efficient processing , generates dynamic SQL to query data base iin the data sources, structures results to satisfy requests.
    • BI Scheduler---Manages and executes jobs requesting data analytics. Schedules reports to be delivered to users at specified times.

Last week received the following support email

From: **********************************
Sent: March 25, 2013 2:29 PM
To: Alex Antonatos
Subject: OBIEE reports with Answers

Hi Alex,

I am a regular reader of your blog, great website and thank you for sharing your experiences.

We have installed OBIEE and new to BI Answers trying to understand how to create reports with Answers. Can you help us understand the steps required in deploying procurement spent report with Oracle Answers.                                                    




Step by Step approach in building BI reports using Answers

Oracle BI Answers is the Oracle BI interface used to query the organization’s data. They provide answers to business questions. It allows you to explore and interact with information, and present and visualize information using different views.

Answers can be accessed by using URL default area http://OBIServer/analytics/saw.dll?Answers

Step 1: Arrow mark indicates the subject areas accessed by the current user. In my current example I am using Purchasing to respond to the support email above.

 Step 1- BI Answers

Step 2: Once click on the subject area displays the related tables and columns in left side pane

 Step 2- Bi Answers

Step 3: Select the columns from the left side pane.

Step 3- Bi Answers

Step 4: Select the columns from the left side pane.

 Step 4- Bi Answers

Step 5: Save the results in the required folders

 Step 5 - Bi Answers

Then you can view reports in various formats. By selecting the type of report from the drop down, then it will generate the report in that view.

 Sample BI Output

Like always, don’t hesitate to share your experiences/tips with me and the website readers on OBIEE

Comments (26)

  • Bernard Pritchard

    Bernard Pritchard

    03 April 2013 at 01:03 |
    Good site you have here.. It's hard to find excellent writing like yours these days. I honestly appreciate individuals like you! Take care!!
    • Alex Antonatos

      Alex Antonatos

      04 April 2013 at 01:16 |
      Hi Bernard thank you for your kind words
  • Luis Mendoza

    Luis Mendoza

    03 April 2013 at 01:08 |
    Good article, nicely written, we just finished our OBIEE implementation went well some tips install all the recommended patches and test multi-languages we had some issues with Spanish that took some time to resolve.
    • Alex Antonatos

      Alex Antonatos

      04 April 2013 at 01:17 |
      Hi Luis, thank you for sharing your experience, very good point on the recommended patches!
  • Lula


    03 April 2013 at 01:14 |
    Very nice article, just what I wanted to find.
  • Richard


    03 April 2013 at 01:52 |
    Went live last month we used a rapid deployment approach with OUM. Look and feel is great, we faced challenges in testing and reconciling the data.
    Alex, on another topic what do you think of Big data, we started looking at it, it looks like more hype than concrete, I think it will dissapear in less than two years.
    • Alex Antonatos

      Alex Antonatos

      04 April 2013 at 01:28 |
      Hi Richard,
      Thank you for sharing your experience with OBIEE.
      My view Big data is already all around us and will be increasing exponentially, The amount of data in our world has been exploding, and analyzing large data sets will become a key basis of competition.
      I see the pattern of moving away from one-size-fits-all stacks, and toward building for your needs. Distributed systems are hard to get right, so when something like Hadoop gets a lot of momentum,
      it retains that momentum until alternatives have the time to mature enough to solve the hard problems with fault tolerance, performance, and so forth.

      Another point , most large technology companies have a dedicated big-data section on their websites, and there are blogs and communities set up around big data and associated hardware and software.
  • Matt Clark

    Matt Clark

    03 April 2013 at 02:23 |
    We had a bad experience, the issue was more organizational we hired consultants that were yes type consultants and always agreed with their hiring manager. Three general problems seem to be at work: overestimation of group power and morality, closed mindedness, and pressures toward uniformity. , and always agree with your boss to pass the message and hire friends to accentuate groupthink. We were conditioned as a group too good about ourselfs. The group felt both invulnerable and optimistic. The group felt morally right all the time. Linked to this attitude of perfection is a correlative close mindedness. Warnings were ignored. Messengers of difference were dismissed or thrown of the project. Negative, stereotypical views of opponents were created and used, when it didnt go the managers direction.
    At the end this was my first failed project they stopped the project because of all the money spent the only winners were the consultants.
    I dont work theyre anymore i switched jobs, it was a great lesson learned the hard way with a failed project under my belt.
    • Alex Antonatos

      Alex Antonatos

      04 April 2013 at 01:34 |
      Hi Matt, thank you for sharing your experience, three lessons learned overconfidence, playing games and ignoring new evidence are usually signs of a project in trouble.
  • shanna


    03 April 2013 at 02:58 |
    Pretty nice post. I just stumbled upon your web-site and wanted
    to say that I have really enjoyed browsing your blog posts.
    In any case I will be subscribing to your feed and I hope you
    write again soon!
  • Duy Lam Sam

    Duy Lam Sam

    03 April 2013 at 03:08 |
    Nice summary!
  • Bob Dipak

    Bob Dipak

    03 April 2013 at 07:58 |
    Great info, thank you for sharing
  • Fran


    03 April 2013 at 10:45 |
    I do not know if it's just me or if perhaps everyone else encountering issues with your site. It looks like some of the content in your posts are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them as well? This may be a issue with my web browser because I've had this happen previously.
    • Alex Antonatos

      Alex Antonatos

      04 April 2013 at 01:36 |
      Hi Fran, It does not seem that anyone else has reported any issues can you share with me your setup.
  • Nina


    03 April 2013 at 20:55 |
    I drop a comment whenever I like a article on a site or I have something to valuable
    to contribute to the discussion. It is caused by the fire displayed in the article I looked at.
    And on this article Business Intelligence
    should not be Hype, use it to answer these 4 golden rules, I
    included an explanation of the OBIEE Design Architecture with
    step by step approach to building Reports.. I was actually excited enough to drop a comment
    :-) I actually do have some questions for you if it's okay. Could it be simply me or does it seem like a few of these remarks look like they are left by brain dead visitors? :-P And, if you are posting on other online social sites, I'd like to
    follow everything new you have to post. Could
    you list every one of all your shared pages like your twitter feed,
    Facebook page or linkedin profile?
    • Alex Antonatos

      Alex Antonatos

      04 April 2013 at 01:39 |
      Hi Nina,
      Thank you for your kind words, no issues you can send me a connection and will gladly connect.
      Your comment on some of the readers of the blog, don't forget the website is accessed in 100 countries, English is not the first language for everyone
  • Bernice


    04 April 2013 at 00:12 |
    Heya i'm for the primary time here. I came across this board and I find It truly helpful & it helped me out much on OBIEE. I'm hoping to provide something again
    and aid others like you aided me.
  • Lyle


    04 April 2013 at 00:39 |
    Hi there, I found your web site via Google, you appear on the first page even as looking for a
    similar matter BI, your site got here up, it appears great.
    I have bookmarked it in my google bookmarks.
    • Alex Antonatos

      Alex Antonatos

      04 April 2013 at 01:44 |
      Hi Lyle, great and thank you, yes the website is getting great reviews and alexa has ranked globally at 1 million, i think it is a great accomplishment when we know globally more than 700 million websites exist.
      I am grateful and thank you to all my visitors.
  • Becky


    04 April 2013 at 02:22 |
    Does your blog have a contact page? I'm having trouble locating it but, I'd like to send you an e-mail.
    I've got some creative ideas for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it grow over time.
  • alexia Kefalas

    alexia Kefalas

    04 April 2013 at 10:56 |
    Cool, ca passe en favoris, ca tombe bien je cherchais justement des infos sur ce sujet pour mes recherches perso :p
  • Hyman


    04 April 2013 at 11:16 |
    Hi there! This is my first comment here so I just wanted to give a
    quick shout out and say I genuinely enjoy reading your articles.

    Can you recommend any other blogs/websites/forums that cover
    the same topics? Many thanks!
  • Melodie


    04 April 2013 at 22:24 |
    excellent points altogether, you simply received a new reader.
    What could you recommend about EBS upgrade? Any traps to avoid?
  • Marc


    04 April 2013 at 23:22 |
    many thanks for this article on OBIEE and keep up your valuable contribution to help others, I found your website by a google search you came up on the first page of google!
  • Olivia


    05 April 2013 at 02:02 |
    bookmarked!!, I like your blog!
  • Michaela


    05 April 2013 at 15:06 |
    Valuable informatio on OBIEE. Fortunate me I found your
    website accidentally by a google search, and I am surprised why this twist of fate did not came about in advance!

    I bookmarked it.

Copyright 2018 All rights reserved.