08-15-2023 09:52 AM - last edited on 08-25-2023 08:50 AM by JackLacava
Hi OS experts,
I want to exclude a base entity - as it must not be affected by the derivative - from its parent for the purpose of this derivative. All entity under a specific parent (ie TDM) must be part of the derivative expression but excluding one base entity. Anyone knows how I can achieve this?
This is my derivative expression ->
08-16-2023 04:53 PM
Hi @Qiniso this might be best served as a Member Formula on a Flow member or Account after the Cube has been loaded. You do have the option of using a Complex Expression in the Derivative rule editor like such, and you can evaluate the Source Entity but after mocking this up I think it would be better in a Member Formula or Finance BR after the load.
Hope this helps.
08-17-2023 04:45 AM - edited 08-17-2023 04:46 AM
Good solution, and I agree that sometimes it might be better to do this in formulas, however it really depends on the situation - the amount of records to be evaluated, auditing requirements, whether you want to spend more time importing or calculating, etc. I'm not dunking! 😅 and I'm not a big fan of derivatives but I know some people really really want to do most of the work at import time. As usual, Onestream can do everything in at least two different ways, lol.
08-17-2023 04:54 AM
Thanks Mike. That's a good solution.
Alternatively, include all entities (I know it's tidious 😅) but don't include the one you want to exclude in the derivative expression.
Thanks,
Qiniso D