ARTICLES

Introduction to MSSQL Server Analysis Services

Creating Our First Cube
Working with Dimensions
Handling Time Dimensions
Parent-Child Dimensions
Working with the Cube Editor
Exploring Virtual Cubes
Custom Cubes: Financial Reporting
Custom Cubes: Financial Reporting - Part II
Drilling Through to Details: From Two Perspectives
Reporting Options for Analysis Services Cubes:            MS Excel
Reporting Options for Analysis Services Cubes: MS FrontPage
Reporting Options for Analysis Services Cubes: Cognos PowerPlay
Build a Web Site Traffic Analysis Cube: Part I
Build a Web Site Traffic Analysis Cube: Part II
MSAS Administration and Optimization: Simple Cube Usage Analysis
MSAS Administration and Optimization: Toward More Sophisticated Analysis
Using Calculated Cells in Analysis Services, Part I
Using Calculated Cells in Analysis Services, Part II
Reporting Options: ProClarity Professional, Part I
Reporting Options: ProClarity Professional, Part II
Putting Actions to Work in Regular Cubes
Actions in Virtual Cubes
Introduction to Local Cubes
Another Approach to Local Cube Design and Creation
Creating a Dynamic Default Member
Derived Measures vs. Calculated Measures
Basic Storage Design
Partitioning a Cube in Analysis Services - An Introduction
Performing Incremental Cube Updates - An Introduction
Semi-Additive Measures and Periodic Balances
Distinct Count Basics: Two Perspectives
Manage Distinct Count with a Virtual Cube
Point-and-Click Cube Schema Simplification
Introduction to MSSQL Server Analysis Services

 

 

 

 

 

 

 

 

The Introduction to MSSQL Server 2000 Analysis Services series is designed to provide hands-on application of the fundamentals of MS SQL Server 2000 Analysis Services, with each installment progressively adding features and techniques designed to meet specific real-world needs. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial article, Creating Our First Cube.

MSSQL, Server, Analysis Services, OLAP, MDX, optimization, Performance, optimization, Island Technologies Inc., Bill Pearson, William E. Pearson, III, Dimension, Query, Cognos, Business Objects, Reporting Services, Conversion, Design, Cube, model

All Contents Copyright Island Technologies Inc. ®  Island Technologies® and Island Technologies Inc.®  are registered trademarks of Island Technologies Inc., protected in the United States and other countries.  For information, contact Island.



The Articles Guide continues on the Next Page
Next Page

MDX, optimization, Performance, optimization, Island Technologies Inc., Bill Pearson, William E. Pearson, III,

Dimension, Query, Cognos, Business Objects, Reporting Services, Conversion, Design, Cube, model