Analytics center : simple - list on dashboard ('report - database view table')

[eyal abu hamad]

I want to add a database view report to the dashboard in Analytics center in HR agent workspace
for some reason I cannot find the database view table.

[Ankur Bawiskar]

@eyal abu hamad 

what's your question and business requirement?

1) I was able to add incident_sla database view in Data visualization in the workspace landing page

2) I was able to add incident_sla in Platform analytics dashboard as well for reporting

check this as well

Using a database view in a simple list in UI Builder 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[eyal abu hamad]

sorry for late response.
I created new database view. I'm trying to add a report on the Analytics center of the HR workspace
for some reason I cannot add the database view that I created, the system is not giving me the option to pick new database view.
BUT in low environment I have managed to do it.
why on the low environment working fine and on the PROD is not working

[Bhuvan]

@eyal abu hamad 

Check if you have created database view correctly and you have defined view tables and related conditions. If you have not created view tables, database view table will not be created in the first place and when you go to database_view_name.LIST from Application Navigator, it will not work. It will also not work in Dashboard since table is not yet created.

Configure View tables and use UI action 'Try It' to make sure view table is created and accessible. Make sure dashboard you are creating is in same scope as database view table. If you have checked everything, validate whether report_on ACL is allowed for the user creating the dashboard for the DB view table.

Before view tables definition,

After view tables definition,

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@eyal abu hamad 

Did you get a chance to review this ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@eyal abu hamad 

Did you try the solution I provided after testing it in my PDI ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan