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

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

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

Analysis Services Reporting Options: ProClarity Professional  Part II

In this article we will continue our exploration of ProClarity in the same hands-on manner, with a focus on exposing more of the rich analysis and reporting capabilities of the application.
First, we will return to the point at which we left our “tour” at the end of Part I, and finish discussing some features from the rudimentary perspective of the Budget cube. Next, we’ll move our examination to a cube with a bit more complexity, and take advantage of the opportunities that this avails to experience additional features of the application.
 

 

The topics within this article will include:

  • An introduction to several additional features that are available within ProClarity to provide for analyzing, and creating enterprise reporting components from, data in MSAS cubes;
  • Various use and navigation tips for the ProClarity interface in analyzing, and reporting from, MSAS cubes;
  • Practice examples of uses for the ProClarity functionality that we expose.

Read the Article ...

SYNOPSIS & CONCEPTS :
 Synopsis:

Discover yet another option for effectively reporting from MSSQL Server Analysis Services cubes. MSAS Architect Bill Pearson revisits practical reporting solutions with an Introduction to ProClarity for Analysis Services.

Concepts:

  • MSSQL Server

  • Cube

  • Calculated Cell

  • MDX

 

  • Analysis Services

  • Analysis Services

  • ProClarity Professional

  • MDX

  • Properties

  • OLAP

  • Report

  • Reporting

  • Formula

  • Condition

  • Calculation

 

   
 

 

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.

ProClarity, Professional, MSAS, MSSQL , Server, Analysis Services,, Cube, MDX, Properties, OLAP, Report, Reporting, Formula, Condition, Calculation
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