In BI Platform, we can set up one data security profile and apply it to any/all universes.
Is there an equivalent to models in SAC?
Security is controlled by employees, at 2 levels: site and company. Together in the warehouse this creates a UserCompanySiteKey. Employees can have access to all companies, some companies, all sites, some sites, and any combination there in. All queries in the warehouse go through this security table to ensure the employee is only seeing informaiton at their sites/companies.
Employees can have access to all or some companies, and employees can have access to all or some sites.
Can I have one model that maintains security (named modSecurity)- ie. it basically contains the UserCompanySiteKey as well as the associated properties to this, company name, site name, employee name.
My next model (named modCompanyRevenue), if I only have Company in the data set, can I join this model to the modSecurity on the Company Name? Then any stories that use modCompanyRevenue will go through the modSecurity model to apply the row level security at the Company level?