February 22, 2001 04:22 PM

Setting Display Characteristics

Rating: (0)
SQL Server Magazine
InstantDoc ID #16514
Cell properties let analysis applications support exception highlighting
Exception highlighting, or conditional formatting, lets you apply different display characteristics to various parts of a query result. For example, you might display profitability by product and highlight negative profit numbers (i.e., products that are losing money). Exception highlighting can draw attention to important numbers in a printed report, making the numbers bold or displaying them in a...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

I found this cell properties doesn't work in Excel. Does Excel (say version 2003) support cell properties?

William10/21/2005 4:13:20 AM


The query in the 1st page of the article should have
({[Product].[Product Family].&[Food]}) instead of ({[Product],[Product Family],&[Food]}).
As the one given below
WITH CELL CALCULATION Sample FOR '({[Product].[Product Family].&[Food]})'
AS 'CalculationPassValue(Product.CurrentMember, 0 )',
CONDITION = 'CalculationPassValue((Product.CurrentMember,[Unit Sales]), 0 ) > 12000', FORE_COLOR = '255 * 256'
SELECT [Product].[Product Family].Members on Columns FROM Sales

Vinay Dharmik8/2/2004 8:15:53 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS