Skip to Content

How to filter results based on authorization in HANA Calculation view

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 09, 2017 at 01:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded