Question Re: calculation view data preview issue when analytical privilege set SQl Analytical Privilege in Technology Q&A

calculation view data preview issue when analytical privilege set SQl Analytical Privilege

former_member210043 — Sun, 12 Apr 2020 17:22:37 GMT

Hi Team,

i have created simple view with Analytical Privilege Set to SQL Analytical Privilege in Web IDE XSA for HANA, i was able activate/ Build the calculation view successfully but when i am trying to do the data preview getting the error as insufficient privileges as below.

Could not open 'START123_HDI_STARTHDB_1'.'start123.startHDB::CV_VBAK_AP'. Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid 'F67FC3FB4563E04681299A03306F849B' .

i tried in in hana studio also by creating and doing the data preview but getting the same error .

attached screen shot of calculation view properties.screen4.png

if i use Classical or blank as Analytical Privilege type in the calculation view Properties then i was able to do the data preview

Please help in this regard.

Thanks,

Nikil

Re: calculation view data preview issue when analytical privilege set SQl Analytical Privilege

braghavendra_rao — Mon, 13 Apr 2020 04:27:45 GMT

Hi Nikil

The Application User of the HDI container needs to be granted the Analytic Privilege in order to data preview.

Please refer to section "How do I assign analytic privileges to the user that runs a data preview in Web IDE?" in the blog https://blogs.sap.com/2019/11/13/faq-modeling-in-web-ide/

Regards

Raghavendra

Re: calculation view data preview issue when analytical privilege set SQl Analytical Privilege

former_member210043 — Mon, 13 Apr 2020 06:13:20 GMT

Hi Raghavendra,

Thanks for the reply , i have not created any analytical privilege yet , just i have created a simple view and set the analytical privilege as SQL Analytical Privilege instead of keeping it as Blank or Classical Privilege in view properties of the Calculation View.Then tried data preview with same user id but getting the error.

Could not open 'START123_HDI_STARTHDB_1'.'start123.startHDB::CV_VBAK_AP'. Error: (dberror) [258]:

insufficient privilege: Detailed info for this error can be found with guid 'F67FC3FB4563E04681299A03306F849B' .

if I Create the Analytical Privilege to restrict the data access then the above mentioned ans may help , but my scenario is simple just i changed Calculation View Analytical Privilege Property to SQL Analytical Privilege , attached screen shot for reference.

screen4.png

Thanks,

Kiran

Re: calculation view data preview issue when analytical privilege set SQl Analytical Privilege

braghavendra_rao — Mon, 13 Apr 2020 07:16:31 GMT

Hi Kiran

If you set the property to SQL Analytic Privilege in Calculation view, then you have to define a privilege object. If you dont intend to define it yet, then you can select blank in the dropdown in Calculation View.

Regards

Raghavendra

Re: calculation view data preview issue when analytical privilege set SQl Analytical Privilege

former_member210043 — Mon, 13 Apr 2020 09:03:44 GMT

Thanks Ragavendra.. for the response