The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Derivative logical operator issue
Trying to create simple rule based on value greater than or less than zero, however only my Negative rule successful.
A#[ACC1]=ACC1_POS | Create If > x | Final and A#[ACC1]=ACC1_NEG | Create If < x...
Got to the bottom of this with the help from Francisco (Curro) Tores of Inlumi.
The specific cube we are submitting into, was setup with specific Integration settings on some Scenario members, where it has 4 additional Attribute Value Dimensions.
On the Data Source config side, these fields had no reference associated with it, i.e. column number linked to an Amount. When specifying this detail, and then also flagging each field as False for 'Zero Suppresion', the derivative rules started working as expected.
I have it setup in the manner you replicated. On the rule that works, I have it setup as follows:
As soon as I change the value to only 0, it doesn't create the _NEG account.
I'm uploading a CSV file, which nothing looks out of place on, as I can see all the values being Imported.
The positive rule that's not triggering, I have setup similarly:
I am working with a provided CSV file, so perhaps I'll continue testing with a newly created 2 line file.
New CSV file with only 4 lines of data results in similar outcomes. Only negative values are transformed to desired account.
I am having this same issue, when 0 is used as the math value then the negative data rows don't come through, (positive rows are correct and working). I have ensured that the Value attributes are referencing data columns and the Suppression settings are false as per the solution above, but issue remains. Any other known solutions to resolve? Interestingly, this only works if I use 1 as the Math Value, 0.1 or 0.01 don't work either. Thanks!
