Analytics Software

I am designing a reporting application in Discoverer, from Oracle Applications data. We need to show sales data to the sales people - and we would like a single Discoverer workbook to do this - the challenge is that we need to restrict the data so that the salesperson only sees his/her own data, and cannot view other sales data.

I will need to use this same methodology for the sales managers. Each sales manager will only be able to see his/her direct reports' sales data.

How would you design this? Could we use a single Discoverer workbook for all sales people - and there be row-level security to restrict the current users' search results?

Thank you,
Rich Magee
Greenwich, CT