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

Dashboard

rituparna_pwc
Regular Contributor
Regular Contributor

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?

4 REPLIES 4

Dhruv_S
Saviynt Employee
Saviynt Employee

We are checking on this and will update you.

Dhruv_S
Saviynt Employee
Saviynt Employee

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.Analytics step.PNGDashboard step.PNG

 


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
Saviynt Employee
Saviynt Employee

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.

@Dhruv_S , working. Thanks a lot