I've taken over some cubes, making some developments to them including implementing dynamic Row Level Security. General access to these is provided by some AD groups.
On connecting to these via Excel after processing, having implemented the OlapQueryLog table, there are numerous records added to the table relating to the low level RLS table and this is returned for all cubes regardless of the one being used within the Excel spreadsheet, a "connecting to data source" message also appears on the status bar within Excel. So if cube2 is accessed, it reports cube1 and 3-4 as well. This happens for each user and then it will be fine for the rest of the day until processing runs again. The "connecting to data source" message lasts for a few minutes. I've attached a sample output.96311-olapquerylog.txt from the QueryLog table.
My RLS/bridging table is based on a low level site code, users have access to one or many sites, this table is quite large and I have tried limiting this down to the very specific users concerned rather than all but this hasn't helped.
I've looked at cache warming thinking I needed to calculate the security after processing but haven't been to do this especially for each user. Appreciate that security has to be worked out somehow but there isn't a great deal of info from what I've seen on the effects of implementing RLS and having a large number of users.
Can anyone help/explain the behaviour being observed?
