OSA Catalogs and Properties: How does it all fit together?
Abstract not available.
Abstract not available.
IOUG Live! 2001
The presentation covers the Oracle business intelligence tools using an Oracle Portal 3.0 portal to publish and query Web site activities, explore and analyze customer behaviors, analyze trends and forecast.
This presentation covers the DBA tools and techniques used in optimizing Oracle 8i relational database for business intelligence users. The background topics covered include star schema, creation and population of data mart, Express cubes design and development, as well as the differences in MOLAP, ROLAP and HOLAP performance.
Each attendee learns the components of an OLAP-ready RDBMS application. Using a broad brush, this session discusses the OLAP-ready relational models, analytically enabled SQL, relational OLAP performance and object-based API utilized by BIBeans. Then, it looks at how one can achieve the goal of “everything in 4GL that can be done declaratively can be manufactured in SQL statements.”
Oracle8i Release 1 added support for the CUBE and ROLLUP extensions to the SELECT statement’s GROUP BY clause. Oracle8i Release 2 introduced a powerful group of SQL functions supporting business intelligence queries. These functions enable ranking, moving and cumulative aggregates, lead and lag and more. Along with the analytic functions, Oracle8i Release 2 also supports efficient multi-dimensional aggregations.
Oracle 9i OLAP services represents a radical change in the way OLAP applications are designed and built. No longer is the administration of an Express database separate from the star schema relational data warehouse. Oracle 9i OLAP services allow you to administer your multidimensional data with relational tools –because the data is truly stored in the relational database.
This class presents the new technologies that will be introduced with Oracle 9i. These include analytical functions in the relational database, OLAP services, Java OLAP API, and BI Beans. The course is based upon a book that will be released by Chris Claterbos after the release of 9i.
OAUG Spring 2001
Picking an Oracle Applications ASP – An IT Manager’s Perspective
Using Business Intelligence with Oracle’s E-Business Suite
OAUG Fall 2001
Each attendee will receive a briefing in a proven methodology that assesses your readiness to implement a Business Intelligence Solution. Each attendee will learn the advantages and disadvantages of the products under Oracle’s Business Intelligence umbrella. Finally, I will show how these two applications can be used with some of the modules in Oracle’s E-Business Suite, including using the GL Link for OFA.
The successful OM and E-Commerce Gateway implementation is filled with many challenges, but few are true technology issues. How you overcome the challenges determines how much of the technology is adopted. Process management affects the final outcomes, and what cultural changes evolve into end user acceptance.
Oracle OpenWorld 2001
Oracle 8i Release 1 added support for the CUBE and ROLLUP extensions to the SELECT statement’s GROUP BY clause. Oracle8i Release 2 introduced a powerful group of SQL functions supporting business intelligence queries. These functions enable ranking, moving and cumulative aggregates, leads and lags and more.
Using a case study, we will start by describing the business and IT environments, look at the business objectives for the Oracle applications technology, and then review the IT strategy taken. Areas covered will include data conversion, upgrade paths, and IT staffing. We will then discuss the bugs discovered, workarounds used, and patch sets required for each client install, and show the results of our initial test scripts.