Skip to Content
0
Jan 25, 2019 at 12:29 AM

Restriction on the Analytical Privileges for Different Company codes in SAP HANA Studio

127 Views Last edit Jan 25, 2019 at 01:33 AM 2 rev

Hi There,

We have got a requirement where we need to restrict the data (Sales Insights) at Store level based on Company Code. Totally we do have about 150 stores where this to be restricted at each store level. So if this is the case, we need to create 150 Analytical Priv for 150 stores separately?

( Or )

Do we have any other way, where a single analytical priv can restrict the access based on the user access at application level (Backend system) which permits to their CC only.

If yes, how this has to be achieved? How to apply the Dynamic Analytical Priv's?

It would be great help, if you can share the possibilities to minimize the effort rather creating 150+ AP’s.


Cheers,

Prema Gudi

SAP Security Consultant