Importing forecasted data from external sources

Import forecasted data from external sources, such as financial documents or marketing strategies by using BMC Helix Continuous Optimization. This data is imported as statistics. You can use this data and create an analysis or model to better plan your current and future capacity requirements. 

The statistics are imported into BMC Helix Continuous Optimization by using the following vertical datasets that include the STATNM column.

• WKLDAT: Business driver data
• SYSDAT: System data

STATNM identifies the statistic by using the ID (if the value is numeric) and the statistic name.

The following user-defined values are supported for the statistics:

• XST_H: External hourly forecasted values
• XST_D: External daily forecasted values
• XST_W: External weekly forecasted values
• XST_M: External monthly forecasted values

To import forecasted data from external sources

Use the Generic CSV file parser ETL to import forecasted data from external sources. Other ETLs are not supported.

Perform these steps:

1. Create a CSV file.
   

   Example of the CSV file used for the daily custom prediction of total events for the "Order Received" business driver

   TS;DS_WKLDNM;OBJNM;VALUE;DURATION;STATNM
   2023-02-01 00:00:00;Order Received;TOTAL_EVENTS;45;86400;XST_D
   2023-02-02 00:00:00;Order Received;TOTAL_EVENTS;20;86400;XST_D
   2023-02-03 00:00:00;Order Received;TOTAL_EVENTS;80;86400;XST_D
   2023-02-04 00:00:00;Order Received;TOTAL_EVENTS;80;86400;XST_D

    

   Important

   The Duration column is required. XST_D represents daily values.

2. Configure the Generic CSV file parser ETL to use this CSV file and run it. For details, see Generic - CSV file parser.

Where to go from here

Analyze the collected data:

1. Create an analysis or edit an existing analysis. For details, see Creating an analysis.
2. Configure the display of forecasted data in the analysis. For details, see Editing an analysis to display forecasted values.