insufficient privilege: error while preview the calculation view sap hana studio

[rshr51bs9399]

Hi Experts,

I am facing the below error while preview the calculation view in Hana studio. Even with system user same error arrise and blocked me to preview the View data in sap Hana studio . I checked and maintained all the required privileges to user.

I would Appreciate If you reply .

Error executing the Query.

Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid

'99A43C7A1FE66649B45E96AF3734DEB2'

SAP HANA studio SAP S/4HANA Cloud ABAP Environment  SAP HANA multi-model processing

[Maciej__Galica]

Hello,

Why even SYSTEM User Fails?
SYSTEM user has DB-level rights, but analytic privilege checks happen above database level at the calculation engine layer.  SAP HANA enforces these separately for data security in views. 

In SAP HANA, even SYSTEM users must have analytic privileges to read/view data from Calculation Views (CUBE or DIMENSION types, especially). Privileges like SELECT on the base tables alone are not enough.

Calculation Views require ANALYTIC PRIVILEGES or SQL Analytic Privileges to be assigned.

• Go to HANA Studio → Security → Analytic Privileges.

• Create a new Analytic Privilege or use an existing one.

• It must include authorization to access the specific Calculation View

Thanks