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.

Related topics

Overview-of-datasets-in-an-ETL-task

Dataset-reference-for-ETL-tasks

Configuring-the-Database-Cleaner-task

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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*