Forum Discussion

Richard_Mayo's avatar
Richard_Mayo
New Contributor III
2 years ago

Where text field is not blank (data buffer)

Good morning all! I'm hoping somebody can put me on the right path...! I'm writing a rule with a data buffer. I want to filter the data buffer so it only runs where needed. I put in the followi...
  • MarcusH's avatar
    6 months ago

    I always use derivative transformation rules for creating additional data like that - it can be audited and is created based on rules that are easily managed. If you use a BR or member formula you lose the transparency.

  • MarcusH's avatar
    MarcusH
    6 months ago

    Derivative Rules are a separate type - they are listed at the end of the UD8 Dimension rules. You select the source for the extra records: 

    The you specify how the extra records will be created and what label the new member will have eg

    A#[COGS]=COGS_TEMP

    That will create a new record for every source record where the Account member is COGS. The extra records will have the member COGS_TEMP. The Design and Reference guide has a section called: BI Blend Derivative Rules. And you can also search OneCommunity for derivative to get a lot more help.