Import Blend Data

The Workflow has a new Workflow Name as Blend or Blend as Workspace. You load data the same as other OneStream Workflows that commonly result in Cube data. 

The configuration of BI Blend is managed in the Workflow Profile. However, some of the Stage Engine's Workflow Properties may not be valid, or used in BI Blend configurations. The primary configuration for BI Blend is done using the Workflow Name and BI Blend Settings. The BI Blend Engine's architecture, such as in-memory processing, makes some Workflow properties, such as the Append Default Load Method, an invalid selection. Such selections will not have an effect on Workflow Blend behaviors.

Data can be collected from:

  • Files (Fixed or Delimited)

  • Connectors

  • Other Workflow Stage Data

Delimited Files

When loading data to a BI Blend workflow using a delimited file, a bypass must be used if the first row of the file contains column headers. See the example in the image below. If the bypass was not used in this case, the file would fail to load and would display an error similar to that in the second screen shot.

How to Use a File Bypass

Use a bypass to prevent file load failures in cases where a delimited file contains column headers.

  1. Create a bypass:

    1. Navigate to Application tab > Data Collection > Data Sources.

    2. Under Delimited Files, select a data source.

    3. Click Create Source Dimension.

    4. From the Name drop-down menu, select Bypass.

    5. Click OK. The default Bypass Type is Contains Within Line.

    6. In the Bypass Value field, type the name of the first column header.

    7. Click Save.

  2. Load the delimited file into a BI Blend workflow.