Bill Pearson: MSAS Administration and Optimization: Simple Cube Usage Analysis

In this article, we will first put the Usage Analysis Wizard to work in its simplest form, examining the initial reporting options that it offers us. We will then explore the ways we can modify the on-screen reports at run time, selecting from a fixed set of filters to limit the results they present. Next, we will modify one of the standard reports to examine how we can tailor members of the set to meet our needs more closely. Finally, we will discuss the virtually inevitable requirement for going beyond the on-screen reporting set, and producing more sophisticated analysis reports, looking forward to the subject of our next lesson.

The topics within this article include:

An examination of the Usage Analysis Wizard, and the “out of the box” reports it offers;
An exploration of ways we can modify the on-screen reports at run time, selecting from a fixed set of filters to limit the results they present;
A modification of one of the standard reports to examine how we can tailor the reports to meet our needs more closely;
A discussion surrounding the production of more sophisticated analysis reports, looking forward to the subject of our next lesson.

Read the Article ...

SYNOPSIS & CONCEPTS :

Synopsis:

MSAS Architect Bill Pearson introduces the Usage Analysis Wizard, and the “out of the box” reports it provides for rapid utilization. We discuss using the “out of the box” reports, then examine modifications with a representative report, before discussing the production of more sophisticated analysis reports, as a a preview to our next lesson.

Concepts:

Analysis Services
Usage
Analysis
Reports
Wizard
Performance
Standard
Customization
Data Source
Table
Business Intelligence
Query

About the Series:

This article is a member of the series Introduction to MSSQL Server 2000 Analysis Services. The 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.

Analysis Services, Usage , Analysis , Reports, Wizard, Performance, Standard, Customization, Data Source, Table, Business Intelligence, Query
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.

Previous page

The articles guide continues on the next page

Next page