In a dashboard, can individual reports be set to run against different databases?
Environment:
Analytics, Reports, Dashboards
Oracle B2C Service, All versions
Issue:
Reports are running against the wrong database when run inside a dashboard.
Resolution:
A dashboard always forces all the reports in it to run against a single database; they will all run on the reports database, or they will all run on the operational database. Which database they run on is determined via a setting in the dashboard. There is currently no way to have some reports run on one, and other reports to run on the other database when run on a single dashboard.
To change this setting, edit the dashboard. On the Ribbon --> In the Home tab --> in the Properties area --> select Options --> More Options --> ensure the Data Source option is set to the desired database.
To learn about the distinction between the two databases, along with their strengths & weaknesses, see Answer ID 5609: Information on different database types used for reporting.