Well, I haven't posted a question on here for quite some time, and yet I've been handed a requirement that I'm having a tough time figuring out how to work. Let me set first what the requirement is so it is understood.
Our sales group has global reports which list data for our entire company. Embedded in these reports in a qualifier (iobj) for region. So we can grant users to these reports by region and they only see the sales data for their area. However, we now have a requirement for account managers to not only see all data at the region level, but also GLOBAL data for a specific customer that they own - all in the same report. So, the report should list out all customers and figures for the local region the user is authorized for, however it should also have items listed for other regions specfic to one or two customers, again in the same report.
I assume this can be done, but we are having a tough go with the build of the analysis auths. Ive built two roles, one with * for region and a specific qualifier for the customer number (which is a characteristic mind you, not an iobj). Then also built the other role with the specific region (NA), and no qualifier for the customer number.
Is what requested even possible? As always, thanks to the community for assistance. Also - if i've assigned this in the wrong forum, please move it (admins). My apologies if this is the case.
Thanks!
Kind Regards,
Wayne