Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
converting 2007 Data Analysis views to 2010 Excel Services views

Answered converting 2007 Data Analysis views to 2010 Excel Services views

  • Monday, 13 February 2012 10:32 PM
     
     
    Sign In to Vote
    0

    Looking for any assistance/shortcuts/step by step instructions/directions to the "clue store" etc  regarding how to convert (or rebuild) existing data analysis views that we have defined in the project server 2007 environment to project server 2010.

    Thanks in advance.

    Dan

     

All Replies

  • Monday, 13 February 2012 10:47 PM
    Moderator
     
     Answered
    Sign In to Vote
    0
    Dan --
     
    If it were me, I would simply write down the definition of each Data Analysis view in Project Server 2007.  This information would include:
    • Name of the OLAP cube used in the view
    • Dimensions included in the Row Fields drop area
    • Dimensions included in the Column Fields drop area
    • Dimensions included in the Filter Filters drop area
    • Total fields included in the Total Fields drop area
    Once you have documented the preceding information, you can recreate your Data Analysis views in the Business Intelligence Center in Project Server 2010.  In essence, you will find that the 14 OLAP cubes are pretty much the same in both versions of the software, and I believe you will find all of the dimensions and total fields in the same OLAP cubes in both versions.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Proposed As Answer by PWMatherMVP Monday, 13 February 2012 11:21 PM
    • Marked As Answer by dfeigen115 Thursday, 10 May 2012 5:21 PM
    •  
     
  • Monday, 13 February 2012 11:13 PM
     
     
    Sign In to Vote
    0
    Thanks Dale - we'll give it a try (I think we just may be overthinking it and making it more complicated than it is)
     
  • Tuesday, 14 February 2012 2:58 PM
    Moderator
     
     
    Sign In to Vote
    0
    dfeigen115 --
     
    You are more than welcome for the help, my friend!

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

     
  • Wednesday, 15 February 2012 8:24 PM
    Moderator
     
     
    Sign In to Vote
    0
    Also remember that you should investigate the Excel Services views that are written directly against the reporting database.  You may find that you no longer need all of the DA views.  The advantage is that these views do not rely on a cube rebuild and so the data is available in the report as soon as the project is published.

    Ben Howard [MVP] blog | web

     
  • Wednesday, 28 March 2012 3:33 PM
     
     
    Sign In to Vote
    0
    Thanks for the added info. I'll keep that in mind.