Oracle Database and SAP NetWeaver Business Intelligence NEW

Total time

Oracle Database and SAP NetWeaver Business Intelligence NEW

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

The special features of SAP NetWeaver Business Intelligence (BI) in an interplay with the Oracle database are discussed at this workshop. The way in which SAP BI uses the Oracle database differs significantly from standard SAP.

Participants each have a PC of their own at their disposal. Within the scope of the course, exercises are conducted on individual focal topics. It is possible to access customer systems within the scope of the workshop.


Audience
  • Data Warehouse Administrator
  • Database Administrators

Course Topics BI overview/architecture Schemas
  • Star Schema
  • Star Query
  • Star Join
  • Snowflake
  • Multi-Dimensional Schema in BI
BI structures mapping in the database (table names) Tablesp…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Business Intelligence (BI), SAP, Data Warehouse, Oracle 10G, and Microsoft SQL Server.

The special features of SAP NetWeaver Business Intelligence (BI) in an interplay with the Oracle database are discussed at this workshop. The way in which SAP BI uses the Oracle database differs significantly from standard SAP.

Participants each have a PC of their own at their disposal. Within the scope of the course, exercises are conducted on individual focal topics. It is possible to access customer systems within the scope of the workshop.
Audience
  • Data Warehouse Administrator
  • Database Administrators

Course Topics BI overview/architecture Schemas
  • Star Schema
  • Star Query
  • Star Join
  • Snowflake
  • Multi-Dimensional Schema in BI
BI structures mapping in the database (table names) Tablespace layout for BI Oracle parameter settings Partitions
  • Basics of partitions
  • Managing partitions with BI
  • Index design (local/global)
  • Partitions for ODS objects
Performance
  • CostBasedOptimizer basics
  • Understanding star queries
  • Optimizing star queries
  • Using Oracle events to optimize performance
  • Using 10g features for performance analysis
  • Optimizing aggregate structure
  • Optimizing ChangeRun
  • Oracle hints in the BI environment (star_transformation, fact)
Oracle tables/index statistics for BI
  • Creating statistics how often
  • Dbms_stats analyze table
Cube structure (including partitions) on the basis of a flat file as an exercise for participants
Course Objectives
  • Optimizing the Business Warehouse system
  • Configuring and administering Oracle for SAP SAP NetWeaver Business Intelligence
  • Describing Business Warehouse concepts

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.