Skip to Content

How to filter results based on authorization in HANA Calculation view


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


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

Thanks in advance


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on 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.


    Add comment
    10|10000 characters needed characters exceeded