Runtime Analytics Data not fetching properly for logged in user

[Sunny]

Hi Team,

We have a requirement to display all the users  from Organization for a logged in user where logged in user is a owner of that organization.

We have created the Runtime Analytics and assigned a Usergroup to it as a owner:

SELECT u.username as User_ID, u.firstname as FIRST_NAME, u.lastname as LAST_NAME, u.email as EMAIL, u.phonenumber as PHONENUMBER, u.enddate as ENDDATE, u.owner as MANAGER, c.customername as ORGANIZATION_ID, c.displayname as ORGANIZATION_NAME, u.street as ADDRESS, u.city as CITY, u.customproperty4 as POSTAL_CODE, u.customproperty5 as MOBILE_NUMBER, u.comments as USERCOMMENTS FROM users u JOIN customer_users cu on cu.userkey=u.userkey JOIN customer c on cu.customerkey=c.customerkey where c.customerkey IN (select customerkey from organization_owners where userkey=${user.id})

However after running the analytics from ADMIN view and checking if that shows the correct result based on logged in user, I'm getting the below error:

{"error":"access denied"}

furthermore If I click on View History I could find the analytics report it is populating based on the lastrun user data(ADMIN user who had run the analytics from admin console) not based on the logged in user the report was coming.

Screenshot provided.

Could you please let me know if I am missing any configuration here?

[rushikeshvartak]

• Does user have required sav role with feature

[Sunny]

Hi @rushikeshvartak ,

The user have multiple customed SAV Role assigned to him however which feature you were talking about could you please let me know?

[rushikeshvartak]

check in browser console which api is causing issue

[Sunny]

Hi @rushikeshvartak 

I'm getting the below error through browser console. 

/ECM/analyticsHistoryES/undefined/api/idw/res/file?path=/app/usr/theme.json:1 Failed to load resource: the server responded with a status of 404 ()

I had attached the Feature Access and Webservices screenshot here. Could you please me with it.

[Sunny]

Hello @rushikeshvartak 

I have identified the feature access that was causing the error message: "access denied". The feature access that needed to be enabled was "Show Analytics Flat History". Once I added this feature access, I was able to view the analytics without any issues.

However, I noticed that the analytics reports were not displaying data based on the logged-in user. Instead, only the reports generated by users from the Admin console were appearing.

I would appreciate it if you could provide further guidance or assistance on how to resolve this issue.

[rushikeshvartak]

Use USERCONEXT approch

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...