Staging the result of a formula in an input ready query

Hi folks,

Has anybody found a way to write back to DB the result of a Formula in an Input-Ready query?

In a simple scenario, I have 3 members of 1 dimension (or in embedded terms, 3 values of 1 InfoObject):

• BASE = Baseline
• ADJ = Adjustment
• ADJ_BASE = Adjusted Baseline

where ADJ_BASE = BASE + ADJ

Using "Inverse Formula" functionality I can build an Input-Ready query with 3 key figures

• BASE (Not Input-Ready)
• ADJ (Input-Ready)
• Formula = BASE + ADJ (Input-Ready)
• ---- Inverse Formula ADJ = Formula - BASE

I'd like to be able to write back the result of the Formula into the 3rd member ADJ_BASE

I was wondering if this is possible to be achieved from the Query definition itself.

I'm aware there are other workarounds like using FOX formulas or VBA Macros, but it'd be really amazing if this functionality was delivered similarly to "Inverse Formulas" where you can just say the result of this formula is to be post against this Input-Ready Key Figure.

Thanks for your time.

Gab