BI Blend Processing and Performance

The requirements related to the BI Blend environment will vary widely by the volume of source records together with the BI Blend Settings definition. 

Default Server Selection

BI Blend processes will be queued across the available Stage servers.  On the BI Blend WorkFlow Settings, a defined server can be assigned to dedicate all BI Blend processing.

Learning Mode

Learning Mode occurs during the first process instance of BI Blend and the design related to the choice of Blend Unit.   This mode restricts multi-threading to two threads by two Blend Units to generate predictive statistics based on the number of records generated from the BI Blend settings. Subsequent processes will be optimized to multi-thread each Blend Unit.  Should the Blend Unit be changed, the Learning Mode again be enabled.  Additionally, if the number of aggregating dimensions is increased from the prior settings, the Learning Mode will again be enabled.

  • Only two threads run

  • Default mode when BI Blend Task is run for the first time

  • Limited multi-threading is done to help ensure free memory is not exceeded

Log File Statistics

  • Blend Unit

  • Base Rows

  • Parent Factorial

  • Explosion Factor

Second Pass Processing

After successful learning mode, the same thread can be evaluated.  BI Bend processing will observe the current number of rows in each Page Dimension (Blend Unit) and apply the Explosion Factor to determine if the process will exceed the amount of free memory available on the server.

  • If a new Blend Unit is added to the file, the calculation estimations for logging and memory usage will use an average across the Page member statistics in its calculations.