Business scenarios of a famous group:
There are two roles in biee11g, and Michael Jacob belongs to both roles:
Role 1: view the sales records for July and August
Role 2: You can view products classified as "digital" and "fashion ".
Problem:
Currently, Michael can only view the sale records of products in July and August, which are classified as "digital" and "fashion". However, Michael wants to see the sales records of "Kitchen, because product 3 is also a product sold in August.
According to the general idea, you only need to add the product 3 permission in role 2. The business department needs to implement this function to ensure that the constraints of dimensions do not affect each other.
The multi-dimensional condition of biee is 'and', not 'or '.
Solution:
The two roles can be combined into one to specify filtering conditions for multiple dimensions in one dimension. For example:
The result is the union of records generated by two dimensions: item and time. This solution has advantages and disadvantages (data will not be missed, but because of the or relationship, you may not be clear about several products first)