none
Cube Build for Project Server 2010 RRS feed

  • Question

  • The OLAP Cube build is failing with a CBSDsoNotInstalled = 17002.  I have found a reference to an explanation to The CBS neeeds Decision Support Objects (DSO) components intallaed for Analysis Services.  Project Server 2010 is installed with SQL 2008 R2.  Previous experience with Project Server 2007 required that DSO be installed the three tiers across the server farm which was documented in the 2007 deployment guide.  I have been looking through the deployment documentation and DSO is not referenced for Analysis Services setup but Analysis Management Objects is referenced for configuring reporting.   Will installing Analysis Management Objects resolve this cube building error?

    Tuesday, June 5, 2012 1:56 AM

All replies

  •  

    Yes, as compare to OLAP cube build configuration in 2007, 2010 configuration is much simpler and less complicated

    For OLAP cube build we do need AMO.

    Installing AMO will resolve your issue


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    Tuesday, June 5, 2012 4:50 AM
    Moderator
  • Hello Chris--

    Agreed with Hrishi. Project Server is integrated with Excel Services in Microsoft SharePoint Server 2010 to make it easier to create custom reports so using reports in Project Server 2010 requires you to install AMO . You will need to use the SQL Server 2008 version of AMO regardless of which version of SQL Server you are using to host your databases. After installing the AMO objects, restart the Project Application Service on each application server in the farm where it is running. This service is configured in SharePoint Central Administration under System Settings, Manage services on server.

    Regarding your query " I have been looking through the deployment documentation and DSO is not referenced for Analysis Services setup but Analysis "
    Please see below article:
    http://technet.microsoft.com/en-us/library/ff686783.aspx
    http://technet.microsoft.com/en-us/library/ee662106.aspx

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, June 5, 2012 5:02 AM