What Is OBIEE And It's Advantages
What is OBIEE?
Oracle Business Intelligence Enterprise Edition is a complete analytics tool including server, administration tool, answers and dashboards. The tool was acquired by Oracle when they purchased Siebel analytics. The product itself has not changed much with the change to Oracle. I believe there are other aquisitions that were involved but I don't think that has any relevance here.
Something I have learned along the way is that simply telling people what the different components of OBIEE are isn't enough for them to truly understand what it is, so I am going to give a brief breakdown of what each component is used for.
Oracle BI Server
o Is the core behind Oracle Business Intelligence
o Provides access to physical data sources effieciently and intelligently
o Transparent to both end users and query tools, functions as the integrating component of a complex decision support system by acting as a layer of abstraction and unification over the underlying databases.
o This allows users to ask business questions that span information sources across the enterprise and beyond
Oracle BI Repositoryo The Oracle BI Repository is built and managed with the Oracle BI Administration tool and provides the information and measures to the clients used in creating reports.
o Import metadata from databases and other data sources
o Simplify and reorganize the metadata into business models
o Structure business models for presentation to users.
Oracle BI Presentation Services
o Presentation services handle the communication between the Administation tool and the Oracle BI Client.
o Provides the processing to visualize the information for client consumption
o Is implemented as an extension to a web server
o Uses a catalog to store saved content such as dashboards and requests
o
Receives data from an Oracle BI client,
retrieves data from Oracle BI Server and provides it to the client that
requested it
o
Is run as a service on the Oracle BI Server with BI server service
o The client is a webbased tool that allows users to create Answers or Reports using the data exposed from the BI Administation tool. Users can then take these Reports and add them to dashboards with filters and prompts.
Physical Data Sourceso OBIEE supports multiple connections to almost any type of data source such as Oracle, SQL Server, Microsoft Access, ODBC, XML, etc.
It is important to know that OBIEE is a complete analytics tool as I mentioned before. It should be given it's own server to run the BI server and host the repository. If you are working with very large amounts of data then a data warehouse is generally best practices but the BI Administration tool can create direct connections to the physical datasources as well.
One other topic I do want to touch on because I feel it is important for people who are trying to make the decision as to whether or not OBIEE is for them or thier organization, is what are the advantages of OBIEE over what I currently have?
This question is better answered by asking the question, what is the advantage of an analytics tool vs a standard reporting tool? I will try to give a few points that may help you in deciding.
Analytics (OBIEE) Vs. Standard Reporting (Discoverer, Actuate, etc)
·
Analytics tools offer a way to interac with the data and
ask questions without needing any knowledge of SQL or database programming. The need for knowing the data is taken away from the report writer.
·
Standard reporting is simply a snapshot of a certain set
of data and one report generally only answers one question.
· One Answer or Report in OBIEE or an analytics tool can answer the sames questions as multiple Discoverer or SQL reports
·
With standard reporting tools you need to have IT resources available to create
new reports when users need them or the users need to wait. This causes a delay in productivity. With OBIEE Answers users can easily create new reports or modify existing ones without needing deep technical skills.
· Users see and intuitive way to buid Answers and Reports. Do not need to have any knowledge of SQL or databases. Drag and drop capabilities allow them to create and modify reports and answers quickly and easily
· More complete dashboard capabilities that are simple for the user to manipulate
· More robust customizations and filtering capabilities.
· User based web interface. The ability to have multi language reports and dynamic data based on server variables such as locations and time zones.
These are just a few of the advantages that came to mind while writing this blog but hopefully this will help give people a deeper understanding of what OBIEE is and what it can give you as a reporting and analysis tool.
Categories: Consulting,OBIEE,Reports,Reporting,Oracle Businsess Intelligence Enterprise Edition,Oracle,Database
Tags: Reports Oracle Developing Reporting OBI EE SQL Consultant OBIEE Consulting Oracle Business Intelligence
Excellent coverage of all the components of Oracle's BI toolset!
Reply to this
Hi,
First time i visited the site and iam starting OBIEE so it is good start to me.You kept it simple as novice like me will understand basics of it.
You rock!!
Regards,
Kranthi.
Reply to this
Bilaroo.com: Register & collect Bilaroo Coins & Win Lowest and Unique bid with our daily auctions, Free Online mobile recharge & Send Free SMS to any mobile in India.
Reply to this
Hi Mac,
This a wonderful explanation of the basics. However my requirement is to integrate OBI with Adobe Flex. Using Flex as a front-end, it should execute reports using the OBI suite and display the results on a Flex dashboard. Can you provide any inputs on how to achieve this integration?
Reply to this
Hi,
This is really a nice post. Thanks Mac..for your effort in explaining the basic which is useful for beginners like me..
Reply to this
Hi ... I just stumbled upon your post.. a gud view point.. Hey ur post left me quenching for more Your post really gives out useful knowledge.. thanks
Reply to this
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I will be subscribing to your feed and I hope you post again soon.
Reply to this
Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which we all need, thanks for all the enthusiasm to offer such helpful information here.
Reply to this
That is when I learned to depend on myself and yet yearn for a family that was mad and inspiring at the same time replica handbags The realization that family was extremely important and someone you could count on time and time again replica gucci handbags That is what I got from my new family GUCCI Wallets 3130 unconditional love in dollops lv handbags My family lets me know all the time that we are in it together for the long haul and will help one another out come what mayI was so very nervous as I clutched on to the Fendi Spangle Bag Brown and I am sure so was the case with David louis vuitton wallets 935745 This was
Reply to this
Small Gucci replica handbags come in a lot of beautiful designs and are thus an ideal accessory for women to flaunt in their officeEvery place has its own specialty in fashion accessories It represents their culture louis vuitton their tradition around them and many more Their products come from that particular place Such as western purses The best louis vuitton made American West purses are available in America because they are made in America and maintain the exclusivity and uniqueness of their line gucci wallets These purses are made from all fake lv fake handbags natural rawhide and cured
Reply to this
the bag should be wiped dry with a paper towel louisvuitton Fold the top of the bag over loosely to seal out air Do not use twist ties or seal the bags tightly louis vuitton CautionsSome consumers are dissatisfied with Debbie Meyers Green Bags They have more than one reason to complain For example taste of the food changes even if food was stored inside the Debbie Meyers Green Bag The bags can not work on all produce in the same way Bananas go bad soon replica Some fruits and vegetables become moldy due to the exist of trapped moisture louis vuitton Washing the bags are not an easy job designer handbags When it comes
Reply to this
must say, as very much as I enjoyed reading what you had to express, I couldnt help but lose interest after a although. Its as should you had a excellent grasp on the topic matter, but you forgot to consist of your readers. Possibly you ought to consider this from far more than a single angle. Or possibly you shouldnt generalise so significantly. Its greater in case you think about what others might have to express instead of just going for any gut reaction on the topic. Think about adjusting your own believed method and giving other people who might read this the benefit with the doubt.
Reply to this
it seems to be nice collection of plus size clothes since many of my friends are plus size and she didn’t find there choice of clothes so i think it would be nice option for them.
Reply to this
A good article and so nice to read it very interesting one to read thanks for sharing this article.........
Reply to this
Why didn’t I find this post earlier? Keep up the good work!
Reply to this
Great article. I now feel like I have more knowledge having read what you wrote.
Reply to this
Your blog provides us a very great information. Its really very helpful to me to find result on search engine. Hope to hear more good information related to searching from your side.
Singapore
Reply to this
i was too bit confused about What is OBIEE?but through your site it cleared and i came to know about the advantages of oracle too
Reply to this
It is now not at all a problem to find a torrent file if you use http://www.torrentbasket.com/van-helsing-in-hindi torrent files search engine, earlier you needed to look through dozens of torrent shares to find the file in question.
Reply to this
I appreciate the work that you have put into this page. Genuinely good,and informative. Thank You
Reply to this
This is so cool..thanks so much for the info. Love it!
Reply to this
Really interesting articles. I enjoyed reading it. Thanks for sharing a nice info
Reply to this