We are trying utilizing the AIC for reporting. I am trying to build dashboard that make sense. So far I was able to get some KPI’s that show accurate data. But I am having issues linking entitlements and access profiles to specific sources. Was wondering if anyone had luck with it. Also. I am noticing that some data is not mapped correctly. For example, I can get manager_id but I am having an issue linking that to manager_name.
You may find the AIC reporting videos helpful for this. They cover useful guidance on data mapping and reporting concepts:
Please refer to this thread. AIC has some limitations. But for certification reporting you can get the data and build meaningful dashboards. AIC for reports - RoleName, EntitlementName, SourceName - #8 by utkirjonkamiljanov
Are you using source.id or source.name as releationship to the entitlements and access profiles? For the manager case I would suggest to verify manager correlation first. If all good try to use manager.name/manager.displayName/manager_id. Also, worth to add AIC data may take up to 24 hours to refresh.
Thanks
Hi @Tursun ,
For manager correlation everything looks good. The issue is I am always getting only manager id whenever I am using nmanager_name, manager_display_name and etc. Also for the sources, I am able to build a correlation but the data from aic and the data when I check the sources is completely different.
Hi @utkirjonkamiljanov ,
Thank you for sharing the thread. I found some useful information. I see you have shared the dashboard you were trying to build. Were you able to drill down further more on the KPI’s that you have created?
I have worked on the AIC some time ago, it was a different project. But I had year filter, quarter filter, campaign KPI’s, like total campaigns, total managers, total users, reassigned certifications, need sign off. And had a source table on the bottom. Whenever you clicked on any year, quarter, or campaign name, the next page showed the identity info, manager info, some KPI’s. Keep in mind that it also takes some time for data to refresh, even if the certification is completed, you might get the right results the next day only. There were many things that I tried to do but the data mapping issue was giving me a hard time. I want to get the number of priviliged accounts per source per se. But for certifications, I was able to build a pretty good dashboard for active campaings and completed campaigns and didn’t have any issues with the data coming in. Hope that helps.
Thank you @utkirjonkamiljanov . I will start with certification campaigns to atleast have some accurate dashboard. And will try to figure out the rest as I go. Thanks for detailed answer.