Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Nov 17, 2003

Introduction to MSSQL Server 2000 Analysis Services: Using Calculated Cells in Analysis Services, Part I - Page 4

By William Pearson

In this example, we do not provide a surrogate value for cells that meet the condition, but use the condition as a basis for the application of exception highlighting only. Therefore, the address of the current cell is appropriate. We use the CalculationPassValue() function to prevent the expression from referencing itself, once again (via the same logic we used in the calculation formula in the last step).

25.  Click Next.

We arrive at the Finish the Calculated Cells Wizard dialog box. We provide the name Warehouse Cost Subanalysis Scope, to define a list of warehouses whose level of costs exceeds the threshold of our scope for further examination. We see a summary of the parameters we have assigned through the wizard for the calculation subcube (defaults were assigned for dimensions that we did not specify). In addition, we see a confirmation that the calculation condition has been specified.

The Finish the Calculated Cells Wizard dialog box appears, as shown in Illustration 9.

Click for larger image

Illustration 9: The Completed Finish the Calculated Cells Wizard Dialog Box

26.  Click Finish.

At this point in the calculated cells creation process, we have a new calculated cell that has no display criteria. We should see the calculated cell Warehouse Cost Subanalysis Scope in the left side of the Cube Editor within the appropriate folder of the tree pane, as depicted in Illustration 10).

Illustration 10: The New Calculated Cell Appears in the Tree

Setting Properties for the Calculated Cell

We now need to set the display properties for the calculated cell. We do this in a manner very similar to that in which we set properties for calculated members.

27.  Click once to select the Warehouse Costs to Subanalyze calculated cell.

28.  Expand the Properties pane in the lower tree pane.

29.  Click the Advanced tab.

The Properties pane--Advanced tab appears, as shown in Illustration 11.

Illustration 11: The Properties Pane - Advanced Tab

The ForeColor and BackColor cell properties are used to store color information for the text and the background of a cell, respectively. The color and hue are defined in these properties boxes using an RGB value (the Microsoft Windows operating system red-green-blue format).

Any color in the spectrum exists at some intersection point of the basic colors (or as a "pure" color). A few common examples of intersect values are depicted in Illustration 12.

Illustration 12: Color Definitions from the Perspective of RGB

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM