IOUG Live! 2003
This class will present the new technologies that were introduced with Oracle9i and 9i Internet Developers Suite (9iDS). These include, analytical functions in the relational database, OLAP Services, 9i Oracle Warehouse Builder (OWB), Java OLAP API, and BI Beans. Attendees will see how to use Oracle9i, OLAP Services, 9i OWB, JDeveloper 9i and BI Beans to build an OLAP aware warehouse and then develop simple and complex applications to view the warehouse data. A comparison between thick and thin client applications will also be discussed.
This presentation will detail the processes and the experiences that Vlamis Software had during the process of developing a commercial BI Application built using JDeveloper 9i and BI Beans. Attendees will see how to use Oracle9i, OLAP Service, JDeveloper 9i and BI Beans to develop simple and complex applications.
With the introduction of Oracle9i and BI Beans, the landscape for development of BI applications has changed. This leaves clients with existing Express-based applications asking “How do we move our applications and data?” and “Do we store our OLAP data in RDBMS tables or analytic workspaces?”. This presentation will address the issues involved in converting and migrating these types of applications over to the new technology.
With the use of the new features found in Oracle’s Warehouse Builder(OWB) 9i and Oracle9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 9i and Oracle 9iOLAP and how to design and construct an Oracle9i database that can be used for OLAP analysis and presentation.
KCOUG Fall Conference
Are you considering building a business intelligence/data warehousing solution? Are you experiencing integration pain from a “best of breed” solution or a metadata mess? Who has the latest data? What impact will this change have? How can you turn your queries into reports? How do you take advantage of the latest Oracle Database features?
This presentation will produce an actual, completed, OLAP-ready datamart, with a working BI application. It will include the new OWB API and new OLAP migration wizards, with a step-by-step guide addressing implementation and design issues as well as how to use OLAP Service, JDeveloper 9i, and BI Beans to develop simple and complex applications.
This presentation will describe the components of Oracle9i LOAP. Armed with information answering “What is an analytic workspace?” and “What metadata is required to support the Java OLAP API and BI Beans?”, a designer will be able to design a data warehouse or data mart for use by a business intelligence application.
With the use of the new features found in Oracle’s Warehouse Builder(OWB) 9i 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 9i and Oracle 9i OLAP and how to design and construct an Oracle 9i database that can be used for OLAP analysis and presentation.