Enterprise Task Outline Code used in OLAP Cube

[Dominic Moss]

I have been using the Enterprise Outline codes at Project & Resource level
to analyse & report project performance. Am I being a bit slow but I do not
appear to be able to use the Task Outline codes in an OLAP Cube - am I
missing something or is this not intended?

--
Dominic Moss

www.projectability.co.uk

Helping people achieve more with Microsoft Project

Tel +44 8707 303 400
Fax +44 8707 303 500

 

[John M.]

No you are not missing something. I'm assuming that you don't want to brush
up on your VB6 and SQL skills in order to extend the OLAP cubes, so you may
want to check out the link below. It is a common way to leverage the
out-of-the-box cube with a macro that you add to the global template. Please
reference the discussion thread related to the article as it contains updated
VBA code for the macro. We implemented the macro, but we trigger it on the
Project_BeforeSave event instead of the Project_BeforeClose one. We also use
the following option on the Tools -- Options -- Collaborate menu: Publish New
and Changed Assignments...when: Start, Finish, % Complete or Outline changes.
This way each assignment isn't flagged as needing to be published upon every
save (as the macro updates the assignment resource outline code value).

http://techrepublic.com.com/5100-6315-1051489.html

Hope this helps.

John

 

[Dominic Moss]

John,

Great thanks for the signpost to the solution - I will investigate and try
to avoid the problems encountered by others as per the discussion thread.

--
Dominic Moss

www.projectability.co.uk

Helping people achieve more with Microsoft Project

Tel +44 8707 303 400
Fax +44 8707 303 500