Project Server 2007 OLAP - Portfolio Analyzer cube

[MSPLearner]

This one of several cubes that are created on a schedule (daily, weekly etc).
I have a need for some deep budget/forecast trend analysis that requires
monthly snapshots of plans, resources usage etc. If I can merge the Portfolio
Analyzer cube into a Super Cube (one additional dimension would Month-Year),
that would do the trick.

Question: Is it possible? How? Can one cube be merged into another super cube?

Any help appreciated

 

[Christophe Fiessinger [MSFT]]

yes it's possible but you will have to write custom code to do so.
Using Analysis Management Objects is one way, see this as a starting point:
http://blogs.msdn.com/chrisfie/arch...be-using-analysis-management-objects-amo.aspx