none
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

    or

    AdventureWorks 2008R2 Analysis Services Project

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

Answers

  • 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:
    http://technet.microsoft.com/en-us/library/ee662108.aspx

    Once you have SSAS configured, you can configure & build a cube for PWA.
    http://technet.microsoft.com/en-us/library/ff465339

    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

    Wednesday, June 27, 2012 2:41 PM