Reporting DB Skills-MV Excel Query

[Darrell]

All,

I was hoping to run an Excel query against the RDB in order to see work by
skill set. I have a Skills-MV custom field and a Skills lookup table with
resources assigned to multiple skill sets. I am having a problem figuring out
how to relate the Skill-MV field to the resource name field in the Excel
query. Can this be done and if so can someone guide me in the right direction?

Darrell

 

[Mike Mahoney]

All,

I was hoping to run an Excel query against the RDB in order to see work by
skill set. I have a Skills-MV custom field and a Skills lookup table with
resources assigned to multiple skill sets. I am having a problem figuringout
how to relate the Skill-MV field to the resource name field in the Excel
query. Can this be done and if so can someone guide me in the right direction?

Darrell

Hi Darrell]

MV fields don't make it into the reporting database.

regards

Mike

 

[Darrell]

Mike,

Thanks for the reply.

You are correct, it is the skills lookup table I am seeing in the RDB
listing the individual skills and not the Skills-MV field. Can I use the RDB
to report work by skill set using an Exel query or is this another report
that must be done in a differnt application or programmatically?

Darrell

All,

I was hoping to run an Excel query against the RDB in order to see work by
skill set. I have a Skills-MV custom field and a Skills lookup table with
resources assigned to multiple skill sets. I am having a problem figuring out
how to relate the Skill-MV field to the resource name field in the Excel
query. Can this be done and if so can someone guide me in the right direction?

Darrell

Hi Darrell]

MV fields don't make it into the reporting database.

regards

Mike

 

[Mike Mahoney]

Mike,

Thanks for the reply.

You are correct, it is the skills lookup table I am seeing in the RDB
listing the individual skills and not the Skills-MV field. Can I use the RDB
to report work by skill set using an Exel query or is this another report
that must be done in a differnt application or programmatically?

Darrell

Hi Darrell]

MV fields don't make it into the reporting database.

Mike- Hide quoted text -

- Show quoted text -

Hi Darrell

Clearly you can access any data in the reporting database from any
tool (including Excel) if you connect via an account which has at
least read permission. In the case of MV fields the data is not there
for you to extract. My approach with skill attributes is to define a
primary skill and secondary skills field - the latter is MV and for
"informal" interrogation. They both lookup the same lookup table. The
primary field usage will always map to a set of generic resources. In
this way you can analyse resource usage by skill in Data Analysis
reports (or Excel if you want).

regards

Mike