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

“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.

• Author
• Recent Posts

Raghu Boddu

SAP Security & GRC SME at SAP HANA HUB

As a specialist in SAP Security & GRC, Raghu is well known to the SAP community. A forensic expert with deep roots in SAP, governance, compliance, and security, he has over 20 years of industry experience. Because of Raghu's passion for technological advancements, he was able to develop many SAP certified solutions and implement various automations.

Latest posts by Raghu Boddu (see all)

• 6 Tips to secure HANA DB - January 24, 2022
• Best Approach for building SAP HANA Privileged based roles - July 27, 2018