Monday, 13 February 2012 10:32 PM
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.
Monday, 13 February 2012 10:47 PMModeratorDan --If it were me, I would simply write down the definition of each Data Analysis view in Project Server 2007. This information would include:
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.
- 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
Monday, 13 February 2012 11:13 PMThanks 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 PMModerator
Wednesday, 15 February 2012 8:24 PMModeratorAlso 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.
Wednesday, 28 March 2012 3:33 PMThanks for the added info. I'll keep that in mind.