In this article, we will explore calculated cells, which enable us to apply functionality previously reserved for calculated members, custom members, and custom rollup formulas (all of which we have explored in previous articles) to a specific range of cells—or even to a single cell. We will describe the construction of a calculated cell, touching upon the basic properties that make it up.

In this article, we will perform the following:

• Overview calculated cells and discuss some of the advantages and benefits that attend their use;
• Discuss the properties that must be defined to create a calculated cell;
• Discuss several optional property options that can be selected after definition of the calculated cell;
• Overview briefly the practical use of Microsoft Windows operating system red-green-blue format (RGB) values
• Modify a calculated cell to enable exception highlighting in an example business-need scenario.

Read the Article ...

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.

MSAS, MSSQL Server , Analysis Services, Cube, Calculated Cell, Cell, MDX , Subcube, Condition, Formula, Session, Global , Scope, CalculationPassValue(), ForeColor, BackColor, RGB, FontName, FontSize, FontFlag, Properties
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.