Cannot get the Data Provider Outline error while executing a Calculation View

Issue: You might see the below error while doing a data preview of a calculation view:

“Cannot get the Data Provider Outline: Data Preview is not possible; object is either inactive or broken. If it is an inactive object, activate it, else redeploy.” 

Solution: This error occurs due to 2 reasons:

1. SELECT authorization on the schema for _SYS_REPO User – The activation of modeling views are done in the name of user _SYS_REPO. _SYS_REPO is “the activation guy”. Unless you grant this authorization to _SYS_REPO on the respective schema, users will not be able to activate the Calculation view or do a data preview.

Use the below SQL statement to grant the authroization:

GRANT SELECT ON SCHEMA <SCHEMA NAME of the tables used in models > TO _SYS_REPO WITH GRANT OPTION

2. SELECT authorization on _SYS_BI & _SYS_BIC – If the user who is doing the data preview should have SELECT authorization for both the _SYS_BI & _SYS_BIC catalog objects. Ensure that the user has authorization for the same.

Now you can do a data preview without any issue.

Was this helpful?

Yes   No
Related Articles