Reuse a Data Flow

In a data flow, you can add parameters so you can reuse the data flow with a different source data set or use different criteria to process and select data. Parameters help you identify the type of data appropriate for the data flow and if you want to select an alternative data set when running or scheduling the data flow. You can also apply parameters to modify default values when creating an Essbase cube.

For example, using a parameter you can:

  • Process a new data set that has the same format as the default input data set.
  • Process and store different aspects of a large data set based on date range, individual departments, or regions into alternative target data sets.

In the Step editor pane, you can apply parameters for the following steps:

Step Name Parameter Field
Add Data
  1. Select the When Run Prompt to select Data Set option.
  2. Provide the Name and Prompt values for the parameter.
Save Data
  1. Select the When Run Prompt to specify Data Set option.
  2. Provide the Name and Prompt values for the parameter.
Create Essbase Cube
  1. Select the When Run Prompt to specify Data Set option.
  2. Provide the Cube name, Application name, and Prompt value for the parameter.