Hide sensitive data while keeping aggregations available

Hi,

I have some sensitive information (salary) on my company which I don't want all users to see. However, some users must see total level (for example sum of salary by department…).

Let's suppose the detailed data is stored on a module A, and aggregations are calculated in module B (so it picks up data from module A). If I set "none" as a role access for module A, can users see correct totals on module B? Otherwise, what could be a solution to hide these data?

Thanks for your help.

Best Answer

  • Venki9902
    Answer ✓

    Hi @Emmeline ,

    In the module A, Apply the DCA so that no one can able to see the data of the salary at employee Level.
    Then for the module B create one more DCA to only few users can able to view data at upper level(Department).

    I Presume Department -Employee has Parent-child relationship.
    General example:
    Step1:Employee Salary

    image.png

    2.After applying DCA:

    image.png

    Step3:Salary at Department level:

    image.png image.png

    in these module apply DCA based on which user want to see the data at the top level.

    If there is no Parent child relation use sum function to aggregate using mapping and apply the same DCA for Step3.

    Hope this helps :).

    Regards,
    Venkatesh