Oracle Database 10g : Using OLAP
1 Book on PDF File
Edition 2.0 ( April 2006 )
Official Oracle University Curriculum
These set teach you everything you need to know to become an Oracle Certified
Professional. The tests are based directly from the information from these
books
Oracle Database 10g : Using OLAP
Course Objectives:
Define Oracle’s OLAP terminology
Describe the OLAP option and components
Explain Oracle’s business intelligence end-user and administrative tools
Create and populate an AW in the Oracle database
Load data into the multidimensional cubes from a provided set of tables
Describe how attributes are used
Describe advanced cube-processing techniques, such as partitioning and aggregation
methods
Describe how to manage sparse data by applying Oracle OLAP compression technology
Refresh data
Create calculated measures based on basic arithmetic, advanced arithmetic,
prior and future comparisons, and time frames
Install and use the BI Spreadsheet Add-In tool
Create worksheets that contain cross tabs and graphs of OLAP data, and use
many Discoverer Plus OLAP analytic techniques
Create and use saved selections
Create reports of OLAP data based on trend analysis and ranking data
Add visual cues (stoplights) to the report that highlight specific data ranges
Discuss how OLAP DML can be used to enhance calculated measures
Course Topics:
Defining OLAP Concepts
Reviewing business requirements
Understanding the dimensional model
Historically, how has OLAP been done?
Handling Multidimensional Needs with Oracle OLAP 10g
Understanding Oracle’s OLAP Technology
Server
Tools for the end user
Tools for the administrator
Building an Analytic Workspace
What is an Analytic Workspace?
Using the AWM 10g interface
Creating an AW
Understanding Cubes
Creating Dimensions
Using templates for dimensions
Creating a Cube
Creating Measures
Applying Advanced Dimensional Design and Cube Processing
Techniques
Adding Attributes to the dimensional model
Using Partitioning
Understanding aggregation methods
Examining dimensional design considerations
Performing ongoing maintenance: refreshing data
Creating Calculated Measures and Applying Data Refresh
Options
Calculated measures
Modify calculated measures
Refreshing data
Using the BI Spreadsheet Add-In to Query OLAP Data
in Excel
Installing the BI Spreadsheet Add-In tool
Connecting to an Oracle OLAP data source
Using the OLAP Query Wizard
Creating a ranking report
Using saved selections
Creating OLAP calculations
Applying Excel formatting to OLAP data
Building Analytical Reports with Discoverer Plus OLAP
Enabling the Discoverer Plus OLAP user
Creating a Connection, Workbook, and Worksheet
Using the OLAP Query Wizard
Using the Discoverer Plus Work Area
Understanding Query Steps
Applying User Attributes in Query Steps
Revisiting OLAP Calculations
Viewing and modifying the graph
Enhancing Analytic Content
Understanding the difference between Model and Object View
Using the OLAP Worksheet interface
Entering OLAP DML commands
Examining Oracle OLAP Calculation Engine Capabilities
In total you will receive 1 PDF File for the workbook.
Language : English
Format : PDF
Download Size : 11MB
Download Time : 10Minutes
Computer Requirements to Open this PDF Files :-
Operating System : Microsoft Windows 95/98/2000/ME/XP Home/XP Professional
Software Required : Adobe Acrobat or Acrobat Viewer ver 5 or above ( Can be downloaded from www.adobe.com )
Please click here for the step by step instruction on downloading and opening the PDF Files