Migration from Analysis Services 2000 to 2005

[mkanka1]

Hello,

We are using Cognos v 8.3, SQL Analysis Services 2005 SP2

We are trying to migrate from SQL Server 2000 to SQL Server 2005. We have some conditional formatting calculations in Analysis Services Cubes which we publish it to be used in Cognos Analysis Studio. Conditional Formatting used to work fine in Analysis Services 2000 but in Analysis Services 2005 though we can see the formatting in Analysis Services browser we cannot see it in the Cognos Analysis Studio.

e.g if we use    Iif([Measures].[cost]>1000,"#,#$","#,#:") we can see the formatting in Analysis Services cube but in the Cognos cube its not showing up. Is it a bug ?

Thanks