Beginners in the Oracle Business Intelligence Enterprise Edition often struggle with some fundamental questions and doubts about its function and applications. We have compiled a quick list of some of the most frequently asked questions about the OBIEE
- The basic function of an OBIEE:
OBIEE administers a web based platform for all your content and also provides reports about data, from a database. It is however NOT a database itself
- The advantages of using OBIEE:
When compared to other products in the same category, with OBIEE you can have mass deployment across all platforms with the help of intranet. Not only this, OBIEE is a based on open standards and is scalable.
Reports have no redundancies and are faster as well as easier to prepare – giving you allot more time on report analysis rather than report preparation. OBIEE also highlights areas where action is required.
- The databases OBIEE reports from:
The following OBIEE databases are typically used for reporting;
Oracle, SQL Anywhere, SQL Server, MySQL, DB2, DB2 AS400, Times Ten, Informix, Redbrick, MS Access, Netezza, ODBC Sources, SAP BW, and SyBase.
- The external sources OBIEE connects to:
With OBIEE you can connect to several other popular sources like the Oracle Essbase, the Oracle OLAP, XML, Excel, Ms Analysis Services, etc.
When using OBIEE another important thing to be clear about is what component to use with what requirement. The BI Publisher for example should be used for creating daily reports of the same format, like the task of sending the same to your senior management. The Delivers option can be used to send the reports by email. BI Publisher is also used in creating documents that are pixel perfect as well as maintaining daily invoice runs.
To improve the quality of your data, display as much data as possible on your OBIEE dashboard, even the odd data, and ensure that all senior management reports are arriving from the OBIEE system. Ensuring this also proves to be helpful in user adoption.Please Share This Knowledge With Others!