cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member210043
Participant
0 Kudos
1,544

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

View Entire Topic
0 Kudos

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

former_member210043
Participant
0 Kudos

Thanks Ragavendra.. for the response