Producing a skills report using multi value enterprise resource co

[harry_nz]

Hi,

I have recently completed an install of Project 2003 Server, and have
implemented several custom mulitvalue enterprise resource outline codes
to hold information such as skillset, qualifcations, languages etc.
Everything works great, and I am able to use team builder just as
described to search for resources based on availability combined with
these multivalue fields..

The other day however, I was asked to produce a report showing all the
various qualifications that we have in the organisation, by staff
member.

I've scratched around for days and can't find anything except for
references to SQL reporting services for anything that isn't possible
in native project. Before I embark on that I just want to be sure that
this is the only way. The multi-value fields are stored within SQL as a
numerical value, and there doesn't seem to be a corresponding table to
translate it back to text (I'm sure there must be somewhere though!). I
have manually worked out which mulitvalue codes relate to which
qualifications, and with this info am able to create a report in Excel
using an ODBC connection. Though it works fine, it's an ugly solution,
and one which I wouldn't want to inherit myself.

I don't want to leave it like this and I'm amazed that although using
custom mv enterprise resource fields are a microsoft recommended way of
implementing skills based resource selection in Project 2003 server,
there doesn't seem to be any way of reporting on what's in there once
you've set it all up.

Any ideas? To start with, I need a simple report, by resource, listing
their corresponding qualifications (from the ent resource outline mv
code) on the right.

 

[Wiley]

Well, this may not be as SQL-oriented as you want it, but you did say you
wanted a "simple report". I do not knwo the SQL side, but in case no one
else provides what you are looking for, here is a way you can get the info.

Add the necessary MV fields to a (custom) view in the Resource Center. Ope
the view and highlihgt all cells. Paste into Excel. type in column names.
It's a little manul in effort, but it can be done in 5 minutes.

Hope this helps.

 

[harry_nz]

Wiley, Thanks for the suggestion. It's a bit too limiting though as this
method puts all qualifications in a single column, and also includes their
heirachical path which makes the report very hard to read. The usefulness of
the report is also limited, as I am unable to sort by particular skill. E,G
If I wanted to see at a glance how many MCSE's we had in the org...
A Pivot table view would be handy, although breaking all the skills into
single columns would be a pre-requeisite for that.