Skip to Content
0
Mar 11, 2021 at 11:56 AM

Assign access restrictions for Custom query/report

147 Views Last edit Aug 15, 2023 at 08:51 PM 3 rev

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