Reporting Data Warehouse Page

The Extract, Transform, and Load (ETL) process updates the data warehouse with new records from the source database. On the Reporting data warehouse page, you can monitor ETL activity, manually start an ETL refresh, reset the ETL process for a full refresh, and schedule queues to run before or after the ETL process. In addition, you can access KPI information about the data warehouse and the ETL process.

You can also deploy eligible smart fields to the OLAP cube and refresh the data in the cube after the ETL process updates the data warehouse. On the OLAP database roles tab, you can configure database roles to control access to the OLAP cube.

To keep the data warehouse up to date, we recommend that you schedule the ETL process to occur at regular intervals. You can create a queue process for the Data Warehouse Start ETL Refresh Job Business Process and schedule the queue process to run the ETL process at regular intervals.

For information about how to set up a queue process, see the Administration section of the help file.

For information about configuration options, see Data Warehouses Configuration.