Hybrid mode calcs, FRMLBOTTOMUP, and NONEMPTYTUPLE
This isn't really a question, more of a PSA! I found a unique relationship between Hybrid mode in calc scripts, FRMLBOTTOMUP, and NONEMPTYTUPLE when working with complex member formulas. Here's the example:
In this snipped of the business rule, I am FIXed on OFS_Direct Input, but using a cross-dim to OFS_Calculated in the 400160 member formula to ensure the block is created. Normally, this works fine with FRMLBOTTOMUP. However, if I enable HYBRIDBSOINCALCSCRIPT with it, the business rule will populate data at 910015→OFS Direct Input and 910015→OFS_Calculated, which is a very unexpected result given the construction of the script.
Tagged:
3