Your schema needs some attention ... it's not clear what table is Entitydimkey supposed to "point" to.
You will need to do some research on Foreign Keys in tables.
Once you've grasped that concept you will need to do some further research on SQL JOINS.
As an example I would have a foreign key (FK) to the user table on the incident table so that I could easily determine which user raised the incident. I would then query along these lines...
SELECT * FROM table_incident I
INNER JOIN table_userdim U on I.userdimkey=U.userdimkey
As an aside, it's not considered good form to prefix your tables with the word "table"