Data security is implemented when there is a need to prevent the users from seeing the entire set of data. Each user only needs to see a data set based on permissions that is defined in Sisense Web.
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.
Image 1. Default data security in with / without changes in the EC
In order to demonstrate the Data security usage we will use the Sample - Ecommerce EC in Sisense:
Image 1. Sample data schema
Create a custom table via Excel with all possible combinations for data security needs. For example:
Image 2. Data security definitions per user
Make sure the same combination appears only once.
Create a key Field in the Data Security table that concatenates the combination fields together
Image 3. Custom field Definitions
Create the same field in the fact table and connect the fact table and the security table by using the security key.
Image 4. Connections between the data security table and the fact table
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.
General note: The solution described above is only relevant for a one-fact schema.
In case of a multi fact schema, we will add the data security combination (Brand & Country) to each and every one of our dimensions - using a Cartesian join of the security combination field and the dimension (The dimension table will contain records of the dimension data duplicated for each security combination).
The security table will be connected to each and every dimension; while the dimensions will be connected to each of the facts.