Using the Sample Data Import Templates

A Using the Sample Data Import Templates

You can use data import templates as a guide to importing data to Predictive Cash Forecasting.

Before importing data, configure the application as described in this guide and import the dimensional metadata.

You can download data import templates from within the application. The templates are generated based on the features you’ve enabled and the custom dimensions that were added.

Predictive Cash Forecasting provides these data load templates as guidance for you to understand the various intersections at which the application expects data. However, Oracle recommends that you use Data Integration as the preferred choice of integration with external sources. Use these templates as guidance, and use Data Integration to configure your data load rules.

Note:

The data load for non-Fusion ERP data sources needs to be aggregated at daily or weekly or monthly level to align with the Cash Forecasting time granularity you set up in the application when you enabled features.

For more information about Data Integration, see Administering Data Integration for Oracle Enterprise Performance Management Cloud.

To download the data import templates:

From the Home page, click Application and then click Configure.
From the Actions menu, select Download Data Load Templates.
Save the ZIP file (CASHFLOW_CASH FORECASTING_DATA_LOAD_TEMPLATES.zip) locally, and then extract the CSV files.

If you need more information about using the data load templates for directly loading data, see Importing Data in Administering Planning Modules.

Video

Your Goal	Watch This Video
This tutorial demonstrates the Import Data process in Predictive Cash Forecasting using the data load template stored locally or on the server. You learn how to access the Data Import Templates then load the data files into your Predictive Cash Forecasting application. You also run the Rules for Cash Forecasting Models and finally run Data Maps to push data to a Reporting Cube.	Loading Data Files in Predictive Cash Forecasting

Tutorials

Your Goal	Learn How
In this tutorial you learn how to import and load metadata and data in Predictive Cash Forecasting. First, you load the Metadata into Predictive Cash Forecasting and perform line items setup. Then with the Import/Export utility, you import the historical actual data as well as the forecast data from the sample data load template files. Once the data is imported into the cash forecasting application, you run the associated business rules in sequence. Finally, you push the daily and periodic data into the reporting cube to generate dashboards and reports.	Loading Metadata and Data in Predictive Cash Forecasting

Your Goal

Learn How

In this tutorial you learn how to import and load metadata and data in Predictive Cash Forecasting. First, you load the Metadata into Predictive Cash Forecasting and perform line items setup. Then with the Import/Export utility, you import the historical actual data as well as the forecast data from the sample data load template files. Once the data is imported into the cash forecasting application, you run the associated business rules in sequence. Finally, you push the daily and periodic data into the reporting cube to generate dashboards and reports.

Loading Metadata and Data in Predictive Cash Forecasting