Calculation View Security
How can I configure Calculation View security such that the modeled views it consumes are private to the end users.
For example if I have a Analytic View that is consumed in a Calculation view I want to prevent the end user from being able to run the Analytic View Directly but still be able to consume the Calculation View.
Vivek Singh Bhoj replied
When you assign privileges to end user don't grant him MODEING role and access to _SYS_BIC schema.
But only grant access to the particular view in _SYS_BIC schema.
Don't grant _SYS_BI_CP_ALL analytic privilege but create an analytic privilege for your Calculation View.
Then grant select access to _SYS_BI schema, analytic privilege that you created and select privilege on Calculation View that you just created.
Additionally, you can check my blog: