Issue with adding in additional information to a colleague skills BIP report

Summary:

We are live with dynamic skills but continue to have problems with reporting. One of the main issues, is that we have a pretty large BIP report to show colleagues attained skill levels throughout our whole organisation, which runs perfectly. However if we want to add in the colleagues position or work structure information from their core HR record we seem to get errors. Also, if we want to add in the required level of a skill from the position profile, we also get errors. I assume these are pretty basic reporting requirments.

Would anyone have the correct tables to link colleague skill data with these items?