Task Detail in Portfolio Analyzer

[Damir]

Hi,

I've been reading a document about Extending OLAP Cube Services in Microsoft
Project Server. At the end of the document it says:

"Another way you may want to extend the OLAP cube is by
including task data in the OLAP cube. To view task data
in the cube in a work breakdown structure (WBS), you will
need to insert task codes into assignments, since task
enterprise codes are not supported in the OLAP cube. You
can do this by creating a task enterprise code named WBS
with a structure that is representative of your WBS. You
can then create a resource outline code that shares the
lookup data with the resource data. Finally, you can
create and run a VBA macro that copies task codes into
the assignments as you save a file. The task WBS will
appear through the resource outline code in the OLAP cube."

What is not clear to me is how to create an enterprise outline code for task
with a name "WBS" because this name is already used by WBS of course.
And the second this what is not clear is the resource outline code that
shares the lookup data with the resource data??? What does that mean?

I hope someone can help me on this!

Regards,
Damir

 

[William Raymond]

Hi Damir,

The RBS discussion is just conceptual. What this document really means is
that you can create a custom "Task Outline Code" that copies the same info
selected on the Task Outline Code to an Assignment Outline Code.

-Bill

 

[Damir Varga]

William,

If I understand correctly what you are saying is that a project user has to
select an info in the "Task Outline Code" about the task. Which means that
the "info" is preset with the Code mask and the Lookup table for the
enterprise outline code. That means that this conceptual solution is not
generic enough to support reporting on every task in the Portfolio Analyzer.
Is there a solution or workaround that enables the Portfolio Analyzer to
report on the task level besides extending the staging tables?

Thanks,
Damir