Question about AdventureWorks and PWA RRS feed

  • Question

  • Hi!

    I'm confused. Can anybody explain me? I can't understand what kind of AdventureWorks must be installed on server for making OLAP cubes in PWA "OLAP Database Management". We have SQL 2008 Windows 2008R2.

    AdventureWorks 2008 OLTP Script

    AdventureWorks Sample Reports 2008 R2


    AdventureWorks 2008R2 Analysis Services Project

    • Edited by Soperov Wednesday, June 27, 2012 2:30 PM
    Wednesday, June 27, 2012 2:27 PM


  • Hi Mr_Minaev,

    Project Server creates OLAP cube using project server  databases . This doesn't require AdventureWorks database  . May be you have seen some examples to create a cube using AdventureWorks database. 

    Please see the below article to configure the SQL server analysis services with project server 2010:

    Once you have SSAS configured, you can configure & build a cube for PWA.

    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

    • Proposed as answer by Marc Soester [MVP] Friday, June 29, 2012 3:51 AM
    • Marked as answer by Soperov Friday, June 29, 2012 6:08 AM
    Wednesday, June 27, 2012 2:41 PM