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.