Effectively Using 9i OLAP in Business Intelligence Applications

Oracle 9i OLAP enables all Oracle data warehouses and data marts to be analyzed with OLAP applications. In Oracle 9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. This eases the whole process of developing applications. More importantly, it opens up previously inaccessible data to new business applications. How do we now capitalize on these new capabilities?

Continue ReadingEffectively Using 9i OLAP in Business Intelligence Applications

Developing Applications with BI Beans and Oracle9i JDeveloper-Our Experience

This presentation will present how custom applications can be built using JDeveloper 9i, 9i OLAP and BI Beans. The attendees will be shown how to start developing applications using BI Beans and JDeveloper. We will also address the experiences we had developing our product VSS Business Analyzer and share with the attendees how they can also develop simple and complex applications. A comparison between thick and thin client applications will also be discussed.

Continue ReadingDeveloping Applications with BI Beans and Oracle9i JDeveloper-Our Experience

Building BI Portals, Using Oracle9i, 9i Developer, and BI Beans

This presentation details the developing and deploying of a Business Intelligence Portal for the Web using Oracle Portal 9i (9iAS 9i R2), Oracle 9i, JDeveloper 9i, BI Beans and other components of the 9i Developer Suite. An overview of the various architectural components with optional deployment considerations is given.

Continue ReadingBuilding BI Portals, Using Oracle9i, 9i Developer, and BI Beans

How To Develop Applications With BIBeans and JDeveloper

This class will present the new technologies that were introduced with Oracle 9i. These include analytical functions in the relational database, OLAP Services, Java OLAP API, and BI Beans. Attendees will see how to use Oracle 9i, OLAP Service, JDeveloper 9i and BI Beans to develop simple and complex applications. A comparison between thick and thin client applications will also be discussed.

Continue ReadingHow To Develop Applications With BIBeans and JDeveloper

OFA and GL Link Tips, Tricks and Traps

Attendees will learn the advantages and limitations of the three tools (OFA front-end, Express 4GL, and Express Administrator) used by a DBA for design and maintenance of OFA databases. Attendees will gain a detailed understanding of the properties of several catalogs critical to implementing, maintaining, and customizing OFA databases and GL Link.

Continue ReadingOFA and GL Link Tips, Tricks and Traps

Oracle Financial Analyzer (OFA) and the GL Link

This presentation will cover the DBA tools and techniques used in customizing Oracle Financial Analyzer. The background topics to be covered include OFA architecture, how OFA interacts with Express Server and Personal Express, and OFA Structures and Catalogs. The major portion of the presentation will be a discussion of how to maintain the catalogs behind the scenes in Express 4GL, as well as loading data and structures

Continue ReadingOracle Financial Analyzer (OFA) and the GL Link

Using Oracle Warehouse Builder 3i and Oracle9i to Create OLAP-Ready Warehouses

With the use of the new features found in Oracle's Warehouse Builder (OWB) 3i and Oracle 9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 3i and Oracle 9i OLAP and how to design and construct an Oracle 9i database that can be used for OLAP analysis and presentation.

Continue ReadingUsing Oracle Warehouse Builder 3i and Oracle9i to Create OLAP-Ready Warehouses

Converting Express Applications to Oracle9i and BI Beans Applications

With the introduction of Oracle 9i and BI Beans, the landscape for development of BI applications is changing. This leaves clients with existing Express based applications developed in Express Web Agent and Oracle Express Objects (OEO) asking "How do we move our applications?". The direct migration of such applications is not fully supported but there is hope.

Continue ReadingConverting Express Applications to Oracle9i and BI Beans Applications

Oracle 9iOLAP–How Does It Really Work?

In Oracle 9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. What's the magic that makes this work? How does this impact performance? What operations are precluded by various design decisions? Why would you want to use Oracle 9i OLAP or BI Beans instead of simply using regular RDBMS tables with Oracle Discoverer?

Continue ReadingOracle 9iOLAP–How Does It Really Work?