Is SP 4 for Analysis Services needed ?

Hi !

We′ve just installed SP 4 for SQL 2000 and Microsoft Reporting Services on the Test environment. The Analysis Services still has the SP3.

At the same environment we have Business Objects Enterprise XIR2. The OLAP Intelligence application doesn′t work properly anymore since we′ve installed SP4 for SQL and the Microsoft Reporting Services.

Do you know, is Microsoft Reporting Services working good together with Business Objects?

I suppose we have to install also the SP4 for Analysis Services also; are there others HotFixes we should install?

greetings,

Laura

Hi,

The SP4 works perfectly fine. It is basically language oriented and gives the symbol of currency when we install in different language. There are few problems in

viewing the 'restricted dimension' column in 'manage roles' for a cube in analysis manager.

Please let me know if there are any problem.

And BusinessObjects OLAPI works fine for the same also. Moreover recommended for OLAPI is SP3a which is OK.

Please let me know if i am wrong.

Thanks,

|||

Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174 : http://support.microsoft.com/?kbid=907323&SD=tech

This article lists the hotfixes that were originally released for Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3), but that were not included in Service Pack 4 (SP4). These hotfixes are now available in a downloadable post-SP4 hotfix rollup package for SQL Server 2000 Analysis Services.

Here are some important notes regarding this hotfix rollup package:

? To apply this hotfix rollup package, you must have SQL Server 2000 Analysis Services SP4 installed. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 (http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack

?

This hotfix rollup package is Microsoft SQL Server 2000 Analysis Services Build 8.0.2174