Dashboard

[rituparna_pwc]

Can someone help me with Dashboard, the documentation is very poor.

I am unable to fetch data into dashboard. 

I want to have a SoD violation dashboard created. In the dashboard I am writing the query as SELECT u.username , u.departmentname as 'Department', u.title, sr.Riskcode, rk.DESCRIPTION, CASE WHEN sr.status = 1 THEN 'NEW' END AS 'SoDRiskStatus' FROM sodrisks sr inner JOIN risks rk ON sr.riskkey = rk.riskid inner join Users u on sr.userkey = u.userkey WHERE sr.status =1 group by u.username,sr.Riskcode;

In chart type I am writing 

[
{"tileType":1,
"data":"",
"displayName":"SoD Dashboard",
"clickable":"yes",
"chartType":"",
"objectName":"SoD Dashboard",
"className":"dashboard-stat orange-new",
"category":"Compliance",
"clickType":"analytics"
}
]

On configuring the above, I see result as 0 in dashboard, it is not fetching any data.

How can we configure dashboards in saviynt to display various data?

[Dhruv_S]

We are checking on this and will update you.

[Dhruv_S · Accepted solution]

Please follow the below steps:

1. Go to Intelligence -> Analytics configuration list ->create new analytics- Using SQL quey

2. In analytics query -> please put the SQL query you have prepared and category as information refresh and save the analytics.

3. Once the analytics is saved you need to pick the analytics config number from the URL

Example : SaviyntURL/ECM/analyticsConfigES/show/1585

Here the analytics config number is 1585

4. Go to settings- Dashboard configuration-> Create dashboard.

Dashboard query: {"analyticsConfig":"1585","fieldToGroup":"username"} and Dashboard Type : ES Tile

5. Save it and you can add this dashboard to the SAV role. Dashboard will reflect.

Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.

[Dhruv_S]

Hi @rituparna_pwc 

Hope Your issue has been resolved or you are still facing the issue?

Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.

[rituparna_pwc]

@Dhruv_S , working. Thanks a lot