Our issue involves a data entry form that includes four slicers. The first slicer is for the sales hierarchy, which has a specific hierarchy structure comprising a demand planner, regional sales supervisor, area supervisor, sales supervisor, and salesman. Security settings are applied to all dimensions based on data access rights. For instance, if a salesman has read and write permissions for a particular dimension, the sales supervisor above the salesman will also have the same access or a subset of that access. These security settings apply to all levels of the hierarchy, including regional supervisors, regional sales supervisors, and demand planners. When a regional sales supervisor logs into the form, the slicers will display member lists based on the security applied in the dimensions for the regional supervisor. For example, the sales hierarchy slicer will display all members who belong to the regional sales supervisor and those below him. The problem we are facing is that when the regional supervisor selects a salesman from the sales hierarchy slicer, the other dimensions in the data entry form should update based on the selection made in the sales hierarchy slicer. In essence, after selecting the salesman from the sales hierarchy slicer, all other dimensions should update and only display members who belong to that particular salesman.
... View more