how to add new pivot table fields to add in protfolio analyzer view

[Nosh]

the portfolio analyzer allows to see data in different dimenstions based on the databases cubes present in sql analysis server. I have one such view which shows the timesheet entries based on years,quarters, months and then days not weeks.I need to now how to add new pivot table fields to the ones already present to build protfolio analyzer view, so that I can add the week field so that I can see time sheet entries based on weeks and their total as well. One way is to add cubes or virtual cubes of a new database in analysis server,which are based on the original project server database, because when I add another week dimention to the already present cube of the analysis server database, it is deleted once the olap cube is rebuilt through project server. this I have not yet tried because this involves deep interaction with the olap cube manually, if there is a easier way that would be better
One thing I found out in the analyzer view is that if you select a group of columns collectively like the days, and then right click you can declare each one as a group, and it even shows the total for those days automatically, but this means everytime making weeks by grouping yourself, there should be a way to do this automatically or by declaring a new pivotable field. Please let me know if anyone has any idea of what to do...
Nosh

 

[Dale Howard [MVP]]

Nosh --

To add the Weeks time dimension to the OLAP cube, refer to the following
link that contains several relevant downloads from Hugues Perron:

http://www.projectserverexperts.com/Project Server Downloads/Forms/AllItems.htm

Hope this helps.

the portfolio analyzer allows to see data in different dimenstions based

on the databases cubes present in sql analysis server. I have one such view
which shows the timesheet entries based on years,quarters, months and then
days not weeks.I need to now how to add new pivot table fields to the ones
already present to build protfolio analyzer view, so that I can add the week
field so that I can see time sheet entries based on weeks and their total as
well. One way is to add cubes or virtual cubes of a new database in analysis
server,which are based on the original project server database, because when
I add another week dimention to the already present cube of the analysis
server database, it is deleted once the olap cube is rebuilt through project
server. this I have not yet tried because this involves deep interaction
with the olap cube manually, if there is a easier way that would be better.

One thing I found out in the analyzer view is that if you select a group

of columns collectively like the days, and then right click you can declare
each one as a group, and it even shows the total for those days
automatically, but this means everytime making weeks by grouping yourself,
there should be a way to do this automatically or by declaring a new
pivotable field. Please let me know if anyone has any idea of what to do....