Introduction
Row-Level data reduction restricts access to data based on the characteristics of the person viewing the data.
Astrato supports.
Row-level data reduction presents each user with only the specific rows in the data he has permission to view.
Astrato data reduction can be set using these user attributes:
User email address
User membership in Astrato's groups.
Data reduction is done on a defined set of columns in a table.
When global data reduction is enabled, all queries that reference tables related to the table with the data reduction rule will be filtered.
Configure Data Reduction
Data reduction is configured in the semantic layer editor.
To define a data reduction rule, follow these steps:
Click on the target table and open it for preview
On the top right side, click on the filter icon to open the dialog to define the data reduction rule
Using User Email
Select the email address field in the table, and define the data reduction as displayed in the image below.
Select equal as the operator, parameter as the type of value.
In the parameter value, enter $userEmail (this is the system attribute), and give the parameter a meaningful name.
Using User Groups
Select the field in the table with matching group names, and define the data reduction as displayed in the image below.
Select in list as the operator, parameter as the type of value.
In the parameter value, enter $userGroupNames (this is the system attribute), and give the parameter a meaningful name.
Enabling Global Data Reduction
Global data reduction means that the filter defined in the table is applied whenever a field or measure from a table connected to the source table is used.
To enable global data reduction, follow these steps:
Check the box Apply as global data reduction
Check the box Enable
When not enabled, the data reduction work will not be applied.
Below is an image of a filter applied as a global data reduction
Editing Data Reduction Settings
To edit an existing data reduction rule, follow this process:
Open the Semantic layer editor
Find the table with a filter and lock icon
Click on the filter icon
Edit the data reduction settings and Save.
Example: how data reduction works
When a global data reduction is applied, all charts that use fields from tables connected to the data reduction table will be filtered.
Let's look at an example:
In this example, all tables are connected to the Territory Data table, where a global data reduction is active.
Now, if we look at the list of cities from the Geography data table, it'll display only the cities that had activity related to the filtered countries in the Territory Data table.
The same will apply to the list of products or dates.