I found some good posts by HIC related to hierarchy and security
I had to use a combination of concat keys and generic keys to get everything to work!!!
create a link table with the following code to join the security table to rest of the data model
Load * , REGION&'|'&SUPERVISOR_ID&'|'& AGENT_ID AS SECKEY Resident AGENT;
Load * , 'ANY' AS SECKEY Resident AGENT;