Custom Business Views for Oracle BI
Still, data warehouses are valuable and important for many customers. They solve requirements that cannot be addressed through reporting directly against the transaction database. However, some customers mistakenly lean toward a pure data warehouse approach, believing that they need to do so in order to achieve adequate performance from their systems.
Another option is to use a real-time solution (such as NoetixViews.) This is a viable alternative to launching a full-blown data warehouse project. Through such a real-time solution, performance impacts are tremendously reduced, while the speed with which organizations can gain access to their data increases dramatically. With this approach, the cost to develop each report is reduced substantially at the same time. In the case of NoetixViews, the business views have been designed and optimized to minimize impact on the transaction system. When used with a modern BI platform (such as OBI EE) they provide a compelling framework for extremely efficient reporting from the transaction system.
Tools for Managing Report Execution
All major BI platforms (including OBI EE) provide tools to manage report execution, including scheduling and caching. These tools allow the administrator to control who runs reports, when they run, for how long they are allowed to run and a variety of other controls.
Oracle Business Intelligence provides a powerful, flexible, robust BI platform. It is suitable as the foundation for meeting virtually all of an organization’s BI needs, spanning operational, tactical and strategic reporting requirements. At its center, the Oracle BI Server provides access to both operational systems and data warehouses.
Because of the power in the BI server, customers don’t need to wait until they’ve completed a data warehouse implementation before they begin to realize value from their BI investments. Instead, they can adopt an approach that addresses operational and tactical reporting requirements by directly accessing the data in their transactional systems.
Using Noetix Technology with OBI EE
Oracle E-Business Suite (like other enterprise applications) is designed and optimized to process transactions, resulting in complex data structures that are not conducive to reporting. As a result, end users typically rely upon specialized IT staff to meet their ad hoc and operational reporting needs.
Noetix provides software, NoetixViews®, that deciphers the maze of tables for you, joins them properly and conducts the necessary data transformations. With NoetixViews, technical knowledge of the underlying database is not necessary to be able to create ad hoc and operational reports.
Noetix technology has a patented auto-discovery capability that automatically picks up the site-specific setups in the database and includes this information in the Noetix business views. Key and descriptive flexfields and lookup values are included automatically. The result is easy-to-understand, intuitive business content.
Reports developed directly against the base tables risk expensive rework after an application upgrade. Noetix protects reports from these database changes by automatically remapping to the new database structures. This unprecedented feature reduces costly maintenance and development time, freeing a customer’s technical resources to focus on other critical tasks.
In 1996, Noetix launched Noetix Generator for Oracle Discoverer. This generator automatically creates business areas for Discoverer’s end user layer (EUL), simplifying setup and ad hoc retrieval of database information from Oracle E-Business Suite. Administrators and users are presented with pre-built and customized business areas within the end-user layer that enhance their ability to view their data in an intuitive format. Noetix Generator for Oracle Discoverer automatically generates predefined drills, predefined joins, lookup values and folder and item descriptions.
Noetix Generator for Oracle Business Intelligence will automatically generate a repository model for OBI EE and/or Oracle BI SE One. This repository model includes metadata for the physical layer, the logical model and the presentation layer. It replicates the key capabilities of Noetix Generator for Oracle Discoverer: predefined drills (achieved through the creation of dimensions in the logical model); predefined joins; lookup values; and folder and item descriptions.
By using NoetixViews together with Noetix Generator for Oracle Business Intelligence, users can rapidly create a reporting environment that provides access to their Oracle E-Business Suite information. This is achieved within days, without the need to create or implement a data warehouse. As a result, customers can quickly deliver success in operational and tactical reporting and immediately realize value from their BI investments.
Noetix provides software that enables direct access to data within Oracle E-Business Suite, Siebel CRM and PeopleSoft Enterprise. Noetix accelerates the deployment of an enterprise-wide BI initiative by pre-populating BI tools with essential business intelligence content for use in query, reporting and analysis.