Change Report Queuing and Data Source Options

You can change the queuing and data source options for reports and dashboards.

Before you start

The Administrator Analytics profile permission is required to modify these settings on a standard report or dashboard. See Analytics Permissions.

Here's what to do

1. Click Analytics on the navigation pane.
2. Double-click Reports Explorer.
3. Go to the report or dashboard you want to modify, right-click the report, and select Edit.
4. Open the Edit Settings window using one of the following options:
   • To open the window for a standard report or dashboard, click More Options.
   • To open the window for a custom report or dashboard, click Options, and then select More Options.
   The Edit Settings window opens.
5. To require the report or dashboard to be queued when it's next run, select Set Report to Deferred Execution. See Automatically Queuing Reports.
   If this option isn't selected but the report or dashboard is automatically queued the next time it's run due to meeting queuing criteria, the Set Report to Deferred Execution check box is selected automatically. Clear this check box to prevent the report or dashboard from being automatically queued when it's next run. However, even when this check box is cleared, you will still be asked to queue the report or dashboard when you next run it if it meets queuing criteria.
6. Select the database you want the report to run on.
   1. To run the report or dashboard on the operational database, select Operational Database. This option is helpful if you need the most current data available.
   2. To run the report or dashboard on the report database, select Report Database. This option is helpful if your report queries a large amount of data since the query size restrictions on report databases are more relaxed than those on operational databases.
7. Click OK.
8. Click Save.