Configure Budget and Forecasting Views for Analytics
Background
The Analytics tool enables you to map standard and custom budget and forecasting views directly to your company’s data warehouses or custom Power BI reports. Selecting designated views ensures that specific financial and forecasting datasets are made available as tables (budget_views and budget_view_details) within your Analytics database.
Things to Consider
Additional Information:
For additional configuration options, see Configure a Custom Budget Report.
The budget and forecasting data are updated twice an hour in the Company level Analytics tool.
Changes to your budget and forecasting settings may take up to 12 hours to reflect in Power BI reports.
Steps
Navigate to the Company level Analytics tool.
Click the Data Configuration tab.
On the 'Budget and Forecasting View' card, click Edit.
In the 'Edit Budget and Forecasting View' modal:
Budget View. Click into the field and select one or more budget views from the drop-down list.
Forecasting View. Click into the field and select one or more forecasting views from the drop-down list.
NoteAt least one budget view and one forecasting view must be selected for budget and forecasting data tables to populate in your Analytics database. For details on how to create a custom budget or forecasting view, see Create a Budget View and Create a Forecasting View.
The 'Procore Standard Budget' and 'Procore Standard Forecast' views are selected by default.
You can remove a selected view by clicking the X icon next to its name.
Click Save Changes.
Once you configure the budget and forecasting views, data will populate in the
budget_viewsandbudget_view_detailstables in the Analytics database.All budget snapshots are synced automatically to the following tables, regardless of your view selections:
budget_snapshot_line_item_headersbudget_snapshot_line_itemsbudget_snapshot_line_item_forecasts