Managing access by warehouse

Hi,

I need to be able to restrict the data accessed by warehouse (aka: location). I understand XDS can be use to do this, but I’ve read through a couple of the standard MS whitepapers and still don’t have a great understanding of how it’s done. There was a great tutorial which walked through an example with customer group which made perfect sense because it was a straightforward 1 primary table with a key in the constrained table and it worked fine. My issue is I need to restrict based on siteId but how does XDS work when there’s possibly hundreds of tables with site-specific data which need to be constrained?

Thanks.