Workflow and Cube Settings

The Cube Dimensions assigned to the Cube are used by the BI Blend Stage Cache Engine to define the target for transforming records.  The assigned Cube Dimension’s hierarchies will generate the aggregation points for the resulting BI Blend Relational Table.  This is a primary difference between the BI Blend Model and a Standard OneStream Cube Model.  Within each Data Unit, the parent levels, such as an Account parent, are derived dynamically in the Standard OneStream Cube Model.  The BI Blend Model will derive these totals and save them as stored values in the output relational table.

The interface to the BI Blend Model is the OneStream Workflow interface. Workflow is a key element of BI Blend. Workflow BI Blend settings establish the Cube Dimensions that are used to derive the metadata and aggregation points in the resulting BI Blend Relational Tables.

The data integration used by the BI Blend Engine uses dimensionality based on cube dimensions, stage attributes, and BI Blend extended dimensions. This array of properties, which is available for data integration, lets the designer enrich the source data for reporting.

BI Blend extended dimensions are a component of the BI Blend engine Blend X extended architecture which consists of three dimensions that provide an additional 57 fields to capture text, numeric values, and time. The Blend X extended architecture uses the Attribute DateTime dimension to deliver time-awareness to the data set which is then used by calculations to enrich data for reporting:

  • 13 cube dimensions let transformation rules align source records to cube data and to generate aggregation points based on the dimension hierarchies.

  • 20 stage text attributes text records support cube dimension aggregations when the records are aligned with metadata in a User Defined 8 dimension. They do not support the use of transformation rules.

  • 12 stage value attributes support numeric records.

  • 3 label dimensions are text-based fields. The SourceID field is the key record attribute used to partition the records for multi-threading aggregations and for the processing of derivative rules.

  • 13 Blend X Attribute DateTime Dimension fields are designed to capture time-based fields. The xBlendDateTime field usage is extended to function as the time-based property in Derivative Rule computational math functions.

  • 20 Blend X text attributes expand the scope of the data set.

  • 24 Blend X value attributes capture numeric data or time-series values in a matrix load format.

In the below example, the Integration settings on the cube are enabled for Attribute1 and Attribute2 to expand the details to be collected for BI Blend analytic reporting, such as and Invoice Number and Customer Code.