Forum Discussion

Jones's avatar
Jones
Contributor
2 years ago
Solved

Split BiBlend table based on dimension value

Hey Community,  So I am wondering if anyone has any smart idea how to split into multiple BiBlend tables when loading a file into workflow with workflow name Blend. My current DataSource is using...
Application Properties
  • JackLacava's avatar
    JackLacava
    2 years ago

    Instead of risking with Event Handlers, we could use a "Blend, Workspace" profile, so that we get a Dashboard after the blend operation - have a button there that triggers an Extender via Data Management, and do the SQL splitting in the Extender.

ckattookaran's avatar
ckattookaran
VIP
2 years ago

It is not straightforward. You can use a TransformationEventHandler, check whether the operation is Case Is = BREventOperationType.Transformation.BiBlend.EndBiBlendProcessing and then split your Table using SQL. I had to do this one for archiving purposes. The client didn't want it to be always an overwrite.

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

Instead of risking with Event Handlers, we could use a "Blend, Workspace" profile, so that we get a Dashboard after the blend operation - have a button there that triggers an Extender via Data Management, and do the SQL splitting in the Extender.

  • Jones's avatar
    Jones
    Contributor
    2 years ago

    Thank you Jack,

    I actually ended up with doing exactly this, so happy to hear that this was recommended process!