Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Reportee details in dashboard

ArvindKumar33
New Contributor III
New Contributor III

 

Hi,
 
We want to develop a dashboard for managers to list and view all reportees on single page. We thought of developing analytic but not able to get the logged-id user id to pass in the analytic to return reportee's for that specific logged in user.
 
Please let me know how we can get it or is there any other way to fulfill the requirement.
 
Regards, 
Arvind 
14 REPLIES 14

rushikeshvartak
All-Star
All-Star

Query:

rushikeshvartak_1-1652367532267.png

 

Output :

rushikeshvartak_2-1652367585241.png

You don't need Dashboard 🙂 

 

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi @rushikeshvartak ,

I have a similar requirement and we do not give access to analytics to end users.

We need a dashboard that takes in the logged-in user data and when user clicks "re-load" or clicks, it should show the data for that specific user


Thanks & Regards,
Haardik Verma

You can create dashboard and give access to analytics but dont give analytics tab access


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

To create a run-time analytics that uses ${user.id} we need to create v1 analytics.

But while creating dashboards, it only accepts v2 analytics, right?

Like this:

haardik_verma_1-1669749354871.png

Here the analytics with analyticskey=26 is from v2 analytics and is not the analytics that I wished to use in this dashboard.

The analytics that I created:

haardik_verma_2-1669749441005.png

This is v1 analytics, which also has analyticskey=26


Thanks & Regards,
Haardik Verma

What’s issue with v2 ?

future in v2 analytics


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

In the V2 analytics create new option, I see only these 3 varierty:

haardik_verma_0-1669782750040.png

No option for run-time analytics like in v1.

If I create new V2 Analytics "Using SQL Query" using the query: select username,firstname,lastname from users where manager=${user.id}

When clicking on create analytics, I get this pop-up:

haardik_verma_1-1669782967059.png

What am I missing here?


Thanks & Regards,
Haardik Verma

while creating analytics

rushikeshvartak_0-1669783379320.png


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

While creating v2 analytics, I only get 3 options, as seen in the screenshot shared above.
But I have an option in the SQL query analytics

haardik_verma_0-1669786256247.png

I missed this, so please ignore my last 2 comments.
Request you to please read my next comment


Thanks & Regards,
Haardik Verma

The dashboard is not showing results..

I have a v2 runtime analytics, that takes in logged-in user data properly and when a person runs the analytics, he gets data according to his userID.

haardik_verma_0-1669880002980.png

But as I mentioned, we do not want to give access to analytics.

So, I made a dashboard

haardik_verma_1-1669786614694.png

Added this dashboard and that runtime analytics in the SAV Role

haardik_verma_3-1669786727489.png

haardik_verma_2-1669786692990.png

But the dashboard in ARS is showing 0 data.

And nothing happens if I click the dashboard

haardik_verma_5-1669786921382.png

(If I make dashboard for normal analytics, clicking the dashboards takes me to the analytics history page of that analytics)


Thanks & Regards,
Haardik Verma

Share query of analytics


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

haardik_verma_0-1669880002980.png

select username,firstname,lastname from users where manager=${user.id}


Thanks & Regards,
Haardik Verma

try removing space of column name for fieldToGroup attribute in dashboard


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

haardik_verma
Regular Contributor
Regular Contributor

haardik_verma_0-1669978290989.png

{"analyticsConfigES":"525","fieldToGroup":"Loggedinusername"}

Changed to this... But still dashboard is showing 0 and not opening on clicking


Thanks & Regards,
Haardik Verma

Hi @rushikeshvartak , 

We got the dashboard to work. 

Instead of using run-time analytics, we used USER CONTEXT.

In the query, added select u.userkey as USERCONTEXT

and changed the "Context" from None to User . The dashboard now gives data based on the logged in user perfectly.

 


Thanks & Regards,
Haardik Verma