Skip to Content
0

How to filter results based on authorization in HANA Calculation view

Jun 09, 2017 at 11:46 AM

58

avatar image

Hi,

I need to filter my calculation view results based on the user authorizations for plants.

i,e,

Only values pertaining to plants the user is authorized in should show up in the results.

Thanks in advance

Arkajeet

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Jun 09, 2017 at 01:13 PM
2

You can check if the usage of Dynamic SQL Analytic Privileges is an option for you. With that you can define an SQL Analtytic Privilege for your calc. view. The SQL Analytic Privilege uses a stored producedure in which you can determine for your user the valid plants. The procedure returns the valid values which are used to restrict the calc. view result.

If you need more information than that what is already described in the online documentation you can search here in the community. There are already several Q&As + blogs covering that topic.

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded