Adding new fields to basic Portfolio Analyzer cube

T

Tony Wojnar

I am trying to accomplish something similar to the post
from Brian Gibson, "Reporting Directly from Database using
SQL" on 12/1/2003.

Instead of creating a Project view, I want to use the
Portfolio Analyzer. Specifically, I would like to use an
Enterprise Task Outline Code to categorize the "types" of
hours spent on a project, against standard methodology
definitions (e.g., Analyze, Design, Define, Code, Test,
Implement, etc., etc.).

After defining the Enterprise Task Outline Code column,
and inserting it into the project plan, we could
then "tag" the task and collect the hours spent on the
task into the appropriate "bucket". The various buckets
could then be examined to summarize the amount of time a
deployment team, for instance, is spending on various
types of activies.

The question is: can I extend the Analyzer cube to
include Enterprise Task Outline Codes? That would be the
first step to determining if this standardized reporting
approach would work.

Thanks for whatever help you can give ...
 
T

Tony Wojnar

Thanks for the info, Naveen

I posted a reply yesterday, but it never showed up. If this gets dup'd, my apologies ..

I reviewed the MSDN article, and it confirmed my suspicion about enterprise task outline codes in the cube -- they are not available. But it does suggest a work-around that fits my issue almost perfectly. The example in the article is adding a WBS code to categorize against, which is similar to the categorization I need to do. This appears in the section entitled, "Extending the Cube Building Process"

I understand the concept of the work-around, and how to use an enterprise resource outline code to do it. My only question is how to get the code value into the "assignment". The article is good at detailing the resource outline code and how to use it. It provides no detail on where the VB macro needs to place the task data into the collection of assignment data. I am familiar with the server tables, view tables and staging tables. Can anyone give me an idea where to place the needed task data into the "assignment" bucket of data, as the article indicates

TIA...

----- Naveen wrote: ----

Here is the MSDN Article on extending OLAP cubes in Project Serve

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/pdr/PDR_Extending_OLAP_3347.as

Cheers
 
Top