Join user id with custom dimension in report

Hi,

We’ve added a custom dimension to our Piwik system. Now we’d like to see the connection between visitors/users and this dimension. Is it possible to create or see such a report? Or using the HTTP reporting API? And not only for one known dimension value, but more like a SQL join.

Thank you,

Olle