You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Hybrid mode calcs, FRMLBOTTOMUP, and NONEMPTYTUPLE

in Planning 13 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!