Overview
| Course code | 1WB52 | Skill level | Advanced |
|---|---|---|---|
| Duration | 8.0 hours | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $300.00 plus tax |
Note: This is a self-paced online course. This course usually requires 8 hours to complete. Once you receive your access information, you will have access to this course for 1 year.
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course materials.
This course is a subset of the course InfoSphere Warehouse 9 Components (DW352). It is designed to give an in-depth knowledge of the Cubing Services component of InfoSphere Warehouse. You will create and administer a cube server. You will create OLAP metadata that describes a star schema defined in DB2 and deploy that metadata to a cube server. An IBM Alphablox application will then be used to access the DB2 data in the star schema via the cube server.This course is is appropriate for those who are using InfoSphere Warehouse within the IBM Smart Analytics system and for those that are using IBM InfoSphere Warehouse and IBM InfoSphere Warehouse on System z independently.
Course Materials
The course materials address InfoSphere Warehouse 9.7.
Hands-On Labs
Four labs are included to address InfoSphere Warehouse 9.7.
Training Path
This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.
Audience
This advanced course is for those who will be administering or using the Cubing Services component of InfoSphere Warehouse or IBM InfoSphere Warehouse on System z.
This course is also appropriate for customers who have acquired the IBM Smart Analytics System.
Prerequisites
It is strongly suggested that you'll be familiar with DB2 and have attended InfoSphere Warehouse 9 - SQL Warehousing Tool and Administration Console (DWA52).
Skills taught
- Create Cubing Services cube servers
- Create OLAP metadata that describes a star schema stored in DB2
- Deploy OLAP metadata to a Cubing Services cube server
- Administer a Cubing Services cube server
- Use Cubing Services to create MQTs to enhance some OLAP tools’ performance
- Use IBM Alphablox Blox Builder to access DB2 data stored in star schema
Course outline
Introduction to Cubing Services
- Define OLAP and its position with Business Intelligence
- Contrast different types of OLAP
- State the benefits of OLAP
- List the components of Cubing Services
- Define Summary Tables as used by Cubing Services
- Describe how Cubing Services exploits Summary Tables
- State the benefits of using Cubing Services
Cubing Services Metadata
- Explain how OLAP metadata is: Imported into the Design Studio and Deployed to the InfoSphere Warehouse repository
- List the main tasks when defining a cube model
- Describe dimensions, levels and hierarchies
- List the different hierarchy types
- Define advanced measures for a cube model
Cubing Services Security and Virtual Cubes
- Describe Cubing Services concept of virtual cubes
- Explain how to create a virtual cube
- Give examples of where a virtual cube is appropriate
- Explain how to merge members in a virtual cube
- List the objects that make up the Cubing Services security model
- Describe the Cubing Services security model lifecycle
- Explain the resolution when there are conflicting access and deny policies for a user
Cubing Services Administration
- Describe the Cubing Services architecture
- List some examples of cube server configuration parameters
- List the cube deployment criteria
- Describe the action that takes place when queries are made against a cube server
- Describe some tools used to query a cube via a Cubing Services cube server
Cubing Services Optimization Advisor
- State the benefits of using Summary Tables
- Compare SQL used to create different Summary Tables
- Use Optimization Advisor to generate Summary Table scripts
Agenda
- Welcome
- Unit 1: Introduction to Cubing Services
- Unit 2: Cubing Services Metadata
- Exercise for Cubing Services Metadata
- Unit 3: Cubing Services Security and Virtual Cubes
- Exercise for Cubing Services Security and Virtual Cubes
- Unit 4: Cubing Services Administration
- Exercise for Cubing Services Administration
- Unit 5: Cubing Services Optimization Advisor
- Exercise for Optimization Advisor
Machine requirements
HW/SW CONFIGURATION
The minimum hardware and software required to launch the course are:
- Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
- Windows 2000 or XP or Vista
- Computer with soundcard
- Headset or computer speakers
- Internet Explorer 5.01 or later, or Firefox 1.0 or later
Network Speed Test
http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8
User: clp
Pass: ibmeduc
For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be.
High-speed broadband internet access is the recommended configuration for this course.
Keyboard Configuration
If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.