The suites of Oracle Business Intelligence

Oracle, in addition to their famous manager database has a large catalog of software products, many developed internally and acquired through the purchase of other companies.  Within the environment of business intelligence that fact is even more remarkable as just more of Oracle's recent acquisitions were purchases of BI software vendors.
 
The result is that although each tool has some features and a more appropriate market, there are many overlaps, and costs a little lie when choosing what software or set of tools we could use for our business intelligence project.
To top it all must think also in terms of licensing and the software is usually sold in suites that bring together different tools on principles that can help or not.
 
I'm not an expert on the Oracle BI software, but I will make a summary of what I know and it is important to take account of the three suites for Oracle Business Intelligence markets.
 
We can say that this is not the only Oracle BI software, and that after the acquisition of Hyperroll still further complicate the picture, but I think it will analyze the solutions used.
 
The suites follow the nomenclature of the different editions of databases that already know, so it helps if we are already familiar with it. We have a BI Standard Edition 1 (BISE1), which is the more modest and targeted to SMEs. Then comes the BI Standard Edition (BISE), which in theory correspond to the intermediate version.

Oracle Business Intelligence Standard Edition (BISE)

Start with the Standard Edition because it differs greatly from the other two. his suite has the most history.  t is an evolution of classic reporting tools from Oracle, with Discoverer to the head.  It is the one with the lowest cost per user name but does not include the database. Use IAS to provide Web access to reports and dashboards.
 
You can fit in environments where they work almost exclusively with Oracle, and do not want to invest too large for the BI or reporting. Anyway, although Discoverer has improved somewhat, and now even OLAP can work in, I think it is still far from the level of BI tools and BI Answers or Hyperion, which Oracle provides in the other suites, and are a consequence of their acquisitions.
In fact, although it continues to market the suite is quite difficult to find on the website of Oracle, it appears that the intention is to bet on it for the future.
 
These are products that includes:

 

Oracle Discoverer de BISE

 

Oracle Business Intelligence Standard Edition 1 (BISE1)

This suite is more modest, very affordable for SMBs.  Includes everything you need to take a short time working in Business Intelligence system.  That's if everything has been installed on a server, and this must be a Windows Server. 
 The license does not allow using more than two CPU's the server and allows only other source of direct data apart from the BD includes. The compulsory licensing per user is nominal, and may be licensed between 5 and 50 users. 
 Installation is performed easily and in a single processor installed in the server database, ETL tool Oracle Warehouse Builder (basic version), the BI server and other applications.
The BI server allows access to web analytical reporting tool and dashboards, for design to operation. The whole environment is the acquisition of Siebel and Oracle made some time ago, and its previous name was Siebel Analytics.
 BI environment is a very complete and easy to use, but does not use structures of OLAP, works directly on the relational model of database.
 
 The suite includes tools that are:
  • Oracle BI Server: Centralized access to data and calculation engine that relies on a logical model of common enterprise information (level of abstraction of the metadata)
  • Oracle BI Server Administrator: Creation of metadata and levels of abstraction
  • Oracle BI Answers: Self-service ad-hoc that allows end users to easily create charts, pivot tables, reports and dashboards, and drill capabilities navigate up / down.
  • Oracle BI Interactive Dashboards:  interactive dashboards for testing environments.
  • Oracle BI Publisher (también conocido como XML Publisher): Reporting business operational and distribution of reports with great detail.
  • Oracle Database Standard Edition One: Database
  • Oracle Warehouse Builder (core ETL):  Design of database and extract, transform and load (ETL) that helps manage the lifecycle of data and metadata
 
The basic process in order to create analytical reports and dashboards with this suite would be:
  1. ETL Design and construction of structures on tables with OWB dimensional
  2. Definition of metadata and Physical layers, the Business and Introduction to Oracle BI Server Administrator
  3. Creating reports and dashboards with BI Answers and Interactive Dashboards

 To create and distribute operational reports can be used independently BI Publisher.

The reports are designed using Microsoft Word or Adobe Acrobat (installing an add-in) and then also can publish and edit web server through WebDav.
This software, although the portal is integrated with BI Dashboards for Oracle's own, and is a bit more cumbersome to use. It is rarely used unless there are specific needs that can not be solved with BI Answers.

 
You can learn more about BISE1 the sección del producto of the website of Oracle.
To learn how to quickly start working with this suite, with the support of such schemes are charged to install the product, I strongly recommend following theTutorial de Oracle Business Intelligence Edition One
 
Oracle BI Interactive Dashboards en BISE1

 

Oracle Business Intelligence Enterprise Edition Plus (BIEE)

This suite is geared to big business and work with multiple data sources.

Consists of all Oracle tools BISE1 (except database) plus some additional applicable to the same environment, and have additional functionality with the same CPM utilities, monitoring and alerts, or to use analytic functions in offline mode .

Plus What's coming for Hyperion software, which has been added to further expand the functionality available, especially as regards utilities Financial Reporting, one of his best assets. This software works very well in OLAP mode, although it needs based on a multidimensional engine, and Oracle BI Server is not, although it does the enterprise version can connect to OLAP engines and other data sources.

In any event, to take full advantage of the Hyperion applications is shown as having or acquiring also a MOLAP database and Essbase. You can also use other sources like SAP BW Multidimensional, or Microsoft OLAP.

 

 If the suite is licensed per user minimum is 50, and also can be licensed per processor. It is not limited in number of data sources, users, or CPU's rather than the budget available.
 Because it contains all BISE1 release applications, especially the BI server, the passage of more modest version of the Enterprise is immediate, but if you want to use Hyperion applications things get a little more complicated.
 
This is the list of applications that comprise: (gray frame that is also part of Oracle BISE1)
  • Oracle BI Server: Centralized access to data and calculation engine that relies on a logical model of common enterprise information (level of abstraction of the metadata)
  • Oracle BI Server Administrator: Creation of metadata and levels of abstraction
  • Oracle BI AnswersSelf-service ad-hoc that allows end users to easily create charts, pivot tables, reports and dashboards, and drill capabilities navigate up / down.
  • Oracle BI Interactive Dashboards: interactive dashboards for testing environments.
  • Oracle BI Publisher (también conocido como XML Publisher):  Reporting business operational and distribution of reports with great detail.

More information in the online documentation library BIEE.
 
Oracle Hyperion Web Analysis en BIEE Plus
 

 

Finally, to comment that in terms of ETL processes, to work with Oracle BIEE usual is also to acquire Oracle Data IntegratorETL as this is ready to work with different applications and data sources or destinations and in projects that use the version business this is often the case.

Oracle Warehouse Builder works well and  can be freely used if there is any license database, but is rather limited in terms of connectors with different enterprise data sources, and fate must always be an Oracle database.
OWB also references are also starting to disappear from the lists of products from Oracle's website.
In fact Weird things happen like that if you follow a link to Warehouse Builder ( http://www.oracle.com/solutions/business_intelligence/warehouse-builder.html) redirect you directly to the section of Oracle Data Integrator (http://www.oracle.com/products/middleware/odi/enterprise-edition.html), which gives us a good clue to the Oracle ETL will evolve more.
 

Comments at forum