How to list reports included in a dashboard

[rrataj]

Hi,

is there a way to display dashboards and the corresponding elements e.g reports that are part of those dashboards ?

I have examined the following tables having information about dashboards, tabs, reports, however I do not see an easy way to display dashboards and corresponding reports.

• pa_dashboards
• pa_tabs
• pa_m2m_dashboard_tabs
• sys_report

Thanks.

[Chuck Tomasi]

Hi Rafal,

What is the business requirement here? Normally, people put stuff on dashboards and don't give it a second thought. Are you having issues with something?

[rrataj]

Hi Chuck,

the requirement is to limit reports sharing, especially to "Everyone" ,

and reports contained in dashboards are also shared

I wanted to have some overview on which reports are not used in dashboards and can be changed in scope of sharing with no impact.

[Chuck Tomasi]

Hi Rafal,

One of benefits of sharing reports is so you don't end up with multiple copies of the same report. What is the objection to sharing reports with everyone?

[rrataj]

Hi Chuck,

some employees have created reports for internal use and set them to share with everyone, that's no good, need to limit the sharing .