The Advanced Data Security Model is used for cases when the Data Security in Sisense Web does not answer your organization's data security needs, since you would like to use "And" & "Or" conditions to create more complex data security combinations.
In order to demonstarte the Data security usage we will use the Sample - Ecommerce EC in Sisense:
Create a custom table via Excel with all possible combinations for data security needs for example:
Make sure the same combination appears only once.
(See the Excel file attached below)
Create a key Field in the Data Security table that concatenates the combination fields together
Create the same field in the fact table.
Connect the fact table and the security table by using the security key.
(See attached ecdata file)
Use the group field in the Security Table to create the security for your user/ group in Sisense Web. This will enforce the desired security combination.