I found the solution so I will share the knowledge... Is located in the "Manage Privileges" >> "Enter XML and SQL Logical"

Thank you I very much appreciate your help. I think that the solution you gave me answers to the problem. I'll check it next week Yochai

Exactly! The proposed solution has been implemented and worked correct in the report. The question is, is there a way to implement it in RPD

Thank you for the effort ! I will try to explain in detail It does not matter what the JOB or the DEP of the employee. It is critical that the combination of the dimensions, return only one record, then I know who earns that salary. For example I have a organization that has one doctor and 10 secretaries. If I run a report…

Thanks for your response In your answer you describe setting permissions on different levels on the employee dimension. As you can see in the example I gave, the dimension of employee does not share in the query. Only Job and Department dimensions are active in the query Thanks Yochai

Thanks for your response Apparently I was not clear enough. I'll give an example: the basic data: Emp_IDDepJobsalery123HomeManger5000654Homecashier3100234Homecashier3000345ElctricManger5500456ElctricManger5400678Elctriccashier3500321Elctriccashier4000the report sum salery Dep Job…