Presentations 2001

AppsWorld 2001

IOUG Live! 2001

Business Intelligence Portals and Oracle Portal

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.

Optimizing Oracle 8i for Business Intelligence

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.

OLAP Applications, BI Beans, and Java OLAP API

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.”

Oracle’s SQL Analytic Functions in 8i and 9i

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 and Express–What Now?

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.

OAUG Spring 2001

OAUG Fall 2001

Using Business Intelligence with Oracle’s E-Business Suite

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.

A Business Case for 11i OM and E-Commerce Gateway

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’s SQL Analytic Functions in 8i and 9i

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.

A Business Case for 11i OM and E-Commerce Gateway

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.

SCOUG 2001

Let’s discuss your options

Contact us to discuss next steps.

Close Menu