OLAB CUbe & Task Outline Codes

[SteveR]

I am trying to pull Task Outline Codes into the OLAP Cube
but I haven't had any luck. I want to be able to report
on specific work breakdown elements that we have within a
generic template.

Has anyone had experience with pulling Task Outline Codes
into the OLAP Cube?

 

[Dave]

The default cube definition does not allow for task
details. It summarizes up to the project, and resource
levels only.

I wanted to do the same thing, but had to create my own
Cube definition in the SQL Server Analysis Manager
directly. This implies that you understand the data model
of the Project server database and that you understand how
to build an olap cube from scratch.

Once you have your cube defined, remember that you need to
refresh the data periodically.

Hope this helps.

Dave

 

[Cecile]

I added some enterprise fields and inserted them into a
new view in PWA. Since then, my Portfolio Analyzer is
telling me that it has not been created or I do not have
access. I've checked all permissions and nothing has
changed. I, as Administrator, should have access to
everything.
Please help!
Thanks.

 

[Lars Hammarberg]

This is how I do it:
(As every assignment is uniquely associated with a task, substituting a task
with an assignment should do the trick)
1. Make sure you've got assignments for every task tagged with the OC in
question.
2. Designate an arbitrary ResourceOC - e.g.: ResourceOutlineCode29 to hold
the TaskOC data - make sure the OC mask and values are the same for both
ResOC29 and the TaskOC
3. Copy the data from TaskOC to the ResOC
4. Publish and wait for the OLAP cube to be re-built.
5. Add the ResourceOutlineCode29 to portfolio views in PWA.

All the above could be done through vba (including the PWA views bit, but
that's a overkill and placed in EnterpriseGlobal to be run in the
ProjectSave event to make sure everyone saving projects to the server will
add the task codes to the cube.

/Lars Hammarberg
www.camako.se