cancel
Showing results for 
Search instead for 
Did you mean: 

error while connecting EXcel to SAP HANA Views

former_member195748
Participant
0 Kudos

Hello Folks,

I am connecting Calculation views to EXcel. With the developer User ID , I can execute the report in excel

But with the Business User ID , I cam getting the below error. The user is able to connect and see the calculation views and the package Hier

As he click Finish on the final step, he gets the below error.

I have assigned- Public, Sys_BI , SYS BIC, ( both Execute and Select) , repository_rest ( exeute) and _sys_bi_cp_all.

Regards,

Vivek

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

There could be 2 possibilities:

  • Can you check the view properties if it is Analytic Privilege enabled or SQL privilege enabled?    If the view is SQL Privilege enabled, then even if you have _SYS_BI_CP_ALL, you will get not authorized error
  • Also, select privilege on _SYS_BIC and _SYS_BI should be grantable to others.

Thank you.

Best Regards,

Anjali.

former_member195748
Participant
0 Kudos

Hello Anjali,

Yes, both are assigned, but no idea, its still not working

Classical analytical privilege is assigned to the users. with _sys_bic and BI is assigned.

former_member183326
Active Contributor
0 Kudos

Did you run the trace to see what is missing?

former_member183326
Active Contributor
0 Kudos

Hello,

Could run an authorization trace to see what privilege is missing?

See this Troubleshooting Guide