Оглавление учебного курса Essbase Integration Services

subj:
Lesson 1: Data Warehousing and Business Intelligence

Business Challenges
Business Information Analysis
Operational Systems
Informational Systems
Business Intelligence
Business Intelligence Tools
OLAP
Business Intelligence Challenges
Business Performance Management
Executive Information Systems
Information Integration
Hyperion Business Performance Management Solution
Hyperion System 9
Hyperion System 9 Components
Data Warehousing
Data Warehouse Properties
Data Staging Area
Data Warehouses and Information Analysis
Corporate Information Factory
Data Marts
Operational Data Store
Enterprise Metadata
Hyperion Business Performance Management and Data Warehousing
Analytic Integration Services and Data Warehousing
Hub-and-Spoke Configuration
Tiered Analytical Environment

Lesson 2: Analytic Integration Services Implementation

Analytic Integration Services Implementation: Overview
Analytic Integration Services Components
Analytic Integration Server
OLAP Metadata Catalog
Analytic Integration Services Shell
Analytic Integration Services Console
Analytic Services Components
Analytic Services Server
Analytic Services Database
Analytic Administration Services
Hyperion OLAP Tools
Analytic Integration Services Implementation Architecture
Relational Data Source
Analytic Integration Services Server and Client
Analytic Services Server
Required Connections for Performing Related Tasks
Analytic Integration Services Implementation Process
Analysis and Planning
Analyzing Business Information Requirements
Designing Analytic Services Database Outlines
Addressing Source Data Preparation Requirements
Model Design and Creation
Designing the OLAP Model
Creating OLAP Metaoutlines
Deployment and Support
Building Analytic Services Outlines
Loading Analytic Services Databases
Analyzing Information Using Hyperion OLAP Tools
Hybrid Analysis and Advanced Relational Access
Drill-Through Reports
Management and Support

Module 2: Analysis and Planning

Lesson 3: Designing Analytic Services Outlines

Multidimensional Database Design
Multidimensional OLAP (MOLAP)
Relational Online Analytical Processing (ROLAP)
Hybrid Online Analytical Processing (HOLAP)
Mapping Business Needs to Database Outline Requirements
Analytic Services Database Outline Overview
Analytic Services Database Outline Design
Data-Descriptor Dimensions
Business-View Dimensions
Designing the Time Dimension
Designing the Accounts Dimension
Designing the Scenario Dimension
Attribute Dimensions
User-Defined Attributes
Member Aliases
Consolidation Properties and Operators
Member Calculation Formulas
Variance Reporting
Expense Reporting
Calculating Data
Two-Pass Calculations
Dynamic Calculations
Dynamic Time Series
Analytic Services Data Storage Options
Enterprise Analytics: Benefits
Enterprise Analytics Versus Essbase Analytics
How Does Aggregate Storage Work?
Combining Solutions
Delivering End-to-End Support
OLAP Model, Metaoutline, and Analytic Services
Database Outline

Lesson 4: Preparing the Relational Data Source

OLAP Models
Metaoutlines
Data Integration Requirements
Consolidating Data
Creating a Data Staging Area
Cleansing Data
Implementation Scenarios
E-R Database Models: Third Normal Form (3NF)
Dimensional Database Models: Star Schema
Fact Table
Dimension Tables
Dimensional Database Models: Snowflake Schema
E-R Models as a Source for Analytic Integration Services
Implications for OLAP
Creating Views
Dimensional Models as a Source for Analytic Integration Services
Guidelines for Preparing the Relational Data Source
Creating Views, Tables, and User-Defined Tables
Removing Unions
Denormalizing Source Data Tables
Adding Columns to Tables
Joining Tables
Creating Indexes
Transforming Data
Source Data Access Considerations
Text Files as a Source for Analytic Integration Services

Module 3: Model Creation

Lesson 5: Creating OLAP Models

OLAP Model Overview
Fact Table
Accounts and Time Dimensions
Other OLAP Model Dimensions
OLAP Model Process
Connecting to the OLAP Metadata Catalog Database
Connecting to a Data Source
Examining Source Tables and Views
Guidelines for Fact Tables
Standard Fact Tables
Alternate Fact Tables
Guidelines for the Time and Accounts Dimensions
Creating a Time Dimension Automatically
Implementation Workflow
Creating the Accounts Dimension Automatically
Creating the Fact Table and Time and Accounts Dimensions
Creating Standard Dimensions
Creating a Fact or Dimension Table from Multiple
Source Tables
Creating Multiple Dimension Tables from a Single
Source Table
Creating Dimension Branches
Defining Joins
Viewing Join Information
Joins and OLAP Metadata Catalog
Joining Two Tables
Displaying Dimension Table Columns
Viewing and Editing Dimension Properties
Deleting Dimensions

Lesson 6: Refining OLAP Models

Assigning Table Column Properties
Hiding Columns
Deleting Columns
Setting Columns to Attribute-Enabled
Creating User-Defined Columns
Defining Column Transformations
Creating String Columns Using Substring
Creating String Columns Using Concatenate
Defining Transformations for Numeric Columns
Defining Transformations for Datetime Columns
Defining Transformations for String or Numeric Columns in the Time Dimension. 6-18
Defining Pass-Through Transformations
Dimension Hierarchies Overview
Defining Dimension Hierarchies
Creating Filters
Creating Sorts
Transforming Data
Defining Replace Transformations
Adding Prefixes and Suffixes
Defining Recursive Hierarchies
Recursive Hierarchies Overview
Defining Recursive Tables
Creating Automatic Date Hierarchies

Lesson 7: Creating Metaoutlines

Creating Metaoutlines: Overview
OLAP Model and OLAP Metaoutline
Metaoutlines and OLAP Metadata Catalog
Features of Metaoutlines
Creating Metaoutlines: Process
Creating New Metaoutlines
Adding Metaoutline Dimensions, Member Levels,
and Measures
Adding Dimensions
Creating Metaoutline Dimensions Automatically
Creating Metaoutline Dimensions Manually
Adding Member Levels
Creating Recursive Dimensions
Adding User-Defined Dimensions and Members
Creating User-Defined Dimensions
Creating User-Defined Members
Setting the Default Load Member
Renaming Dimensions and Members
Deleting Dimensions and Members
Defining Member Name and Measure Transformations
Member Name Transformations
Measure Transformations
Defining Search-and-Replace Member Name Transformations
Adding Prefixes or Suffixes to Member Names
Applying Scaling Transformations
Applying Flip-Sign Transformations
Defining Filters: Overview
Member Filters
Metaoutline Filters
Filtering in an OLAP Model or Metaoutline
Creating and Viewing Metaoutline Filters
Viewing Member Filters in the Current Filter
Deleting Metaoutline Filters
Creating Member Filters

Lesson 8: Enhancing Metaoutlines

Assigning Analytic Services Outline Properties
Setting Dimension Properties
Enabling Dynamic Time Series Members
Setting Member Properties
Loading Member Properties from Database Columns
Specifying Time Balance, Variance Reporting, and Currency Conversion Settings . 8-12
Time Balance Properties
Variance Reporting Properties
Currency Conversion Properties
Specifying UDAs
Specifying Formulas
Setting Aliases for Dimensions and Members
Creating Alias Tables
Attribute Dimension Properties Overview
Attribute Member Names Properties
Specifying Member Name Formats
Specifying Attribute Calculations Member Names
Specifying Boolean and Date Member Names
Specifying Numeric Ranges Settings
Setting Attribute Dimension Properties
Setting Properties for Attribute Dimension Members
Specifying Member Level Associations
Specifying Boolean Value Parameters
Specifying Numeric Ranges
Defining Alias Names
Setting Dimension Load Properties
Handling Duplicate Names
Handling Duplicate Names in a Recursive Hierarchy
Handling New Members During Data Load
Optimizing Data Loads
Setting Load Properties for Members
Sorting Members
Setting Build Levels
Optimizing Member Loads
Previewing Sample Outlines
Verifying and Saving Metaoutlines
Saving Metaoutlines
Deleting Metaoutlines

Lesson 9: Creating and Loading Analytic Services Databases

Member and Data Load Overview
Creating Applications and Databases Process
Creating Analytic Services Outlines
Preparing to Load Members
Specifying Data Storage Properties
Creating Outlines with Duplicate Member Names
Setting Query Governor Options
Selecting a Metaoutline Filter
Connecting to Analytic Services
Initiating Member Loads
Member Load Options
Loading Members Immediately
Scheduling Member Loads
Viewing Member Load Error Information
Performing Incremental Member Loads
Populating Analytic Services Databases
Loading Data
Viewing Data Load Error Information
Scheduling Data Loads
Performing Incremental Data Loads
Performing Time-Based Incremental Data Loads
Performing Member and Data Loads
Granting Access to Specific Users
Saving Member Load Scripts
Viewing Scheduled Member and Data Loads
Examining Analytic Services Outlines
Examining Analytic Services Data

Lesson 10: Managing Drill-Through Reports

Drill-Through Reports Overview
Drill-Through Reports Process
Identifying Drill-Through Columns
Creating Drill-Through Reports
Adding Drill-Through Reports
Defining Drill-Through Intersection Levels
Adding Drill-Through Columns
Ordering Columns
Sorting Rows
Enabling End Users to Customize Reports
Building Reports Using Template SQL
Setting Query Governors
Administering End-User Access to Reports
Updating Drill-Through Information
Viewing Drill-Through Reports Using Hyperion OLAP Tools
Accessing Drill-Through Reports Using Hyperion Essbase Spreadsheet Add-in . . 10-26
Customizing Drill-Through Reports
Selecting and Ordering Columns
Sorting Rows
Filtering the Results
Executing Reports

Lesson 11: Administering the Integration Process

Managing OLAP Models and Metaoutlines
Copying and Renaming OLAP Models and Metaoutlines
Exporting to an XML File
Importing from an XML File
Troubleshooting Member Loads and Data Loads
Automating Administration Tasks
Using Analytic Integration Services Shell
Starting Analytic Integration Services Shell
Command Syntax and Execution
Analytic Integration Services Shell Commands
Running Analytic Integration Services Shell Script and Batch Files
Loading Members Using the Command Line
Loading Data Using the Command Line
Module 5: Advanced Topics
Lesson 12: Alternative Design Techniques
Designing Alternate Accounts Dimensions
Standard Accounts Dimension
Alternate Accounts (Measures) Dimensions
Adding Measures Dimensions
Setting Measures as the Accounts Dimension in a Metaoutline
Specifying a Database Measures Column
Creating Alternate Time Dimensions
Defining Business Calendars
Building Metaoutlines Using Business Calendars
Working with Columnar Time Data
Storing Time as a Field Within a Row
Storing Time in Separate Columns
Creating Accounts and Time Dimensions
Building Metaoutlines
User-Defined Tables
Creating User-Defined Tables
Modifying and Deleting User-Defined Tables
Alternate and Ragged Hierarchies
Designing Alternate Hierarchies
Designing Ragged Hierarchies
Ragged Hierarchies in Recursive Tables
Ragged Hierarchies in Generation Tables
Optimizing Load Processes
Effects of Metaoutline Editing After Using SQL Override

Lesson 13: Designing Relational and Hybrid OLAP Applications

Hybrid Analysis Overview
Hybrid Analysis Architecture
Creating Hybrid Analysis Metaoutlines and Analytic
Services Databases
Creating Hybrid Analysis Databases
Updating Hybrid Analysis Definitions
Configuring Analytic Services for Retrieving Relationally Stored Data
Managing Hybrid Analysis
Monitoring Hybrid Analysis
Managing Data Consistency
Managing Security
Hybrid Analysis Guidelines
Design Guidelines
Formula Restrictions
Unsupported Functions
Advanced Relational Access Overview
Enabling Advanced Relational Access
Enabling Relational OLAP Using Analytic Integration Services
Advanced Relational Access Guidelines