During a configuration of Project Server 2007 Analysis Services I got the following error message "Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: The Application Server needs to have Analysis Services DSO Component installed. ". I tried the patch path given below and was able to resolve the issue without any issue. http://support.microsoft.com/default.aspx?scid=kb;EN-US;921116 On the computer that is running SQL Server 2005 Analysis Services, follow these steps:
|
|||||||||||||||||||||
2. |
Use one of the following methods, as appropriate for your situation:
|
||||||||||||||||||||
3. |
On the computer that is running SQL Server 2005 Analysis Services, follow these steps: Note This includes SQL Server 2005 Analysis Services that are running remotely in a 3-tier configuration.
|
||||||||||||||||||||
4. |
Log on to Project Web Access 2003, and then build an OLAP cube. When you build the OLAP cube, specify the computer that is running SQL Server 2005 Analysis Services on the Update resource tables and OLAP cube page. |
Jerry, bit thanks for this post – I ran into this exact same issue and your posting stepped me through the resolution.Thanks again!
Hi
Online Analytical Processing Server, also known as OLAP Server, is a kind of engine that primarily supports multi-dimensional data structures.