Hello community,
we created a custom analytical query based on a custom CDS view and the query contains supplier invoices with Profit Center and Cost Center information.
Afterwards we assigned the query to a business catalog, which is included in a restricted user role. The user role is restricted by company code and profit center. We expected that the report data is also restricted by the company code and profit center from the user role. However it seems to work for the Company Code but NOT for the Profit Ceneter, because the user can still filter (and see) all profit centers.
We ensured that the user has only the business role which is restricted.
Does anybody know if the role restrictions should work on custom analytical query? If not, how can we ensure that users only see their Profit Center?
Thank you and best regards
Mona