Oracle 9i presents new possibilities for OLAP applications. Data can be stored in RDBMS tables or in an analytic workspace, which is simply a new term for an Express database. Which is the right storage vehicle for your needs? How do you migrate the data? What information is lost in the transition?
Oracle 9iAS Discoverer is a key component of the Oracle 9i Application server (Oracle 9iAS) in integrated business intelligence solution. Discoverer is the ad hoc tool for queries, reporting, analysis and publishing over the web. During this presentation, I will demonstrate how to setup and implement Oracle 9iAS Discoverer environment.
Picking an Oracle Applications ASP: An IT Manager's Perspective
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.
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.
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.
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.
Using Business Intelligence with Oracle's E-Business Suite
Picking an Oracle Applications ASP - An IT Manager's Perspective
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.
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.
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.
© 2024 Vlamis Software Solutions | All Rights Reserved | Privacy Policy