"Insufficient Privilege" Issue after changing the view property

[priyanka_kumari23]

I am getting issue "Insufficient Privilege" after changing the view property to"SQL Analytics Privilege" in the data preview of the calculation view.I dont know why is this happening.It works fine when the keeping the view property as "Classical Analytics privilege". Can anyone please help on this?

[pfefferf]

Have you defined SQL Analytic Privileges and assigned to the user, so that the user is able to get data from the view. If not SQL Analtytic Privilege is assigned to your user, you will get the error.

[priyanka_kumari23]

No...I didnot proceed further after seeing this error..Just changed the property and data preview.And getting this error..Idealy it should display even if not applying the Analytic previlege.

And also when I try to create AP with attribute type , I am getting the same error while seleting values from the field..

[priyanka_kumari23 · Accepted solution]

It is working fine after applying AP based on SQL Editor.