If you are unable to create a new account, please email support@bspsoftware.com



MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Migration from Analysis Services 2000 to 2005

Started by mkanka1, 12 Aug 2011 12:52:17 PM

Previous topic - Next topic



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 ?