Skip to Content
1
Mar 13, 2017 at 05:45 PM

Input Parameters of Calculation View by Procedure with Analytic Privilege

174 Views

Hi I should set different input parameters of calculation view reading the values from a table in according with an "analytical privilege" for example in my table I have 2 record one for ADMIN and another one for LOCAL users with 4 columns.

If I run my calculation view using an ADMIN user (It's possible to have more than one administrator users), I should read only the record from my table for ADMIN, I thought to use privilege to filter this record dynamically but I can't use this solution because input parameters work with table but analytical privileges work with view so I can't filter my record.

Is there any other way to filter dynamically from a table in according with privilege or role?

Thank you