We are running MS SQL 2000 Standard Edition.

How do I integrate conditional formatting on measures?

I read that calculated cells is not an option on the standard edition.

Thanks

The 2 options that come to mind are:

- For AS 2000, you can wrap it in a calculated measure, but then
drillthrough on the measure won't be possible.

- Upgrade to AS 2005 Standard Edition (release date Nov.7), which
supposedly supports calculated cells:

http://sqljunkies.com/WebLog/mosha/a...3/19/9223.aspx
...
In case of Analysis Services, you will immediattely see, that cell
calculations, that were only part of Enterprise Edition in AS2K, now are
available in all editions.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Another option is to do it will specially crafted custom member formulas, so
drillthrough etc will work, but it is likely to become messy. Probably
moving to AS2005 is the best option.

P.S. BTW, Nov 7 is a launch date, not a release date for AS2005

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Hi Mosha,

Thanks for pointing out the Custom Member options for controlling cell
properties.

But I'm puzzled about the difference between launch and release date,
since these terms seem to be used interchangeably in the SQL Server
trade press, like:

http://www.windowsitpro.com/SQLServe...189/SQLServer_
47189.html
Ready, Set--Select!

Now that SQL Server 2005 has an official release date (November 7), it's
time to start learning about the new editions and key features of SQL
Server 2005—and to evaluate how you can apply these features to your
business environment.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

By now you should have realized the difference. The release date was
yesterday - and SQL Server 2005 is already available on MSDN - it is
released !
However, the launch will happen only on November 7 - week from now.

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =

Thanks, Mosha - that was a pleasant surprise! Only caveat is that,
apparently, only Developer Edition is available at the moment - though
others should shortly follow?

http://msdn.microsoft.com/subscriptions/

Visual Studio 2005 Professional Edition

SQL Server 2005 Developer Edition

Exchange Server 2003 Service Pack 2 (Multiple Languages)

SharePoint Portal Server 2003 Service Pack 2 (Multiple Languages)

Office 2003 Service Pack 2 for Multilingual User Interface Pack
(Multiple Languages)

Visio 2003 Service Pack 2 for Multilingual User Interface Pack (Multiple
Languages)

Visio 2003 Service Pack 2 (Multiple Languages)

Exchange Server 2003 Service Pack 2 (Multiple Languages)

SharePoint Portal Server 2003 Service Pack 2 (Arabic)

Project 2003 Service Pack 2 (Multiple Languages)

Project Server 2003 Service Pack 2 (Multiple Languages)

OneNote 2003 Service Pack 2 (Multiple Languages)

Office 2003 Service Pack 2 (Multiple Languages)

Internet Explorer 7 Beta 1 for Windows XP with SP2

Office Business Scorecard Manager 2005 (English)

Windows Vista CTP - 64-bit - Build 5231 (English)

Windows Vista CTP - 32-bit - Build 5231 (English)

Office InterConnect 2004 Service Pack 2 (Japanese)

Visio 2003 Service Pack 2 (Multiple Languages)

Office Project Standard 2003 (Multiple Languages)

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***