Forum Discussion

Oscar's avatar
Oscar
Contributor
4 months ago
Solved

Derivative Rule

Alo I’m trying to create a Source Derivative Rule that takes each inbound Stage row and produces **two** output rows. The first row should remain completely unchanged. The second row should be an e...
Data Integration
Data Sources
  • Oscar's avatar
    Oscar
    4 months ago

    Hi ! Thank you for your response!

    The duplicated record is accomplished by simply referencing the attribute that holds the dimension member (Location for example) A8#[*]

    Now we are trying to copy the value of attribute A8 into the U2# dimension field for the duplicated line but we have not been able to identify the correct logical expression.

    We have tried:

    • A8#[*]:U2#[*]=A8#[*]
    • A8#[*]:U2#[*]<<A8#[*]
T_Kress's avatar
T_Kress
Icon for OneStream Employee rankOneStream Employee
4 months ago

I believe you can use the multiply by 1 to create a duplicate record.  It would be something like this:

 

Oscar's avatar
Oscar
Contributor
4 months ago

Hi ! Thank you for your response!

The duplicated record is accomplished by simply referencing the attribute that holds the dimension member (Location for example) A8#[*]

Now we are trying to copy the value of attribute A8 into the U2# dimension field for the duplicated line but we have not been able to identify the correct logical expression.

We have tried:

  • A8#[*]:U2#[*]=A8#[*]
  • A8#[*]:U2#[*]<<A8#[*]