BW IP Input Ready Query - show total values at parent nodes automatically after data input in cells

[Former Member]

Hi Experts,

In Input Ready Query - total values needs to be displayed automatically (like in excel) at parent nodes after data input in planning cells without using Transfer or Save buttons, is this functionality possible ?

in Excel at sum formula totals will be updated after data input in reference cells, can same functionality available in Input ready queries without using Transfer or Save buttons ?

Input ready Query is based on WBS hierarchy with multiple levels, user will input data at base WBS and that input data at base WBS should be rolled up to parent levels and show data immediately after user input (without using Transfer or Save buttons) expectation is after looking at rolled up value at parent nodes, user will adjust data before data transfer to Planning buffer or save data to server.

Thanks in advance.

Sagar

[cornelia_lezoch · Accepted solution]

Hello Sagar,

i think you will need to create a macro that ist running with each "Enter" that starts the "Transfer Data".

Only with the "Transfer Data" the hierarchy sums are correctly calculated.

regards

Cornelia

[Anand71 · Accepted solution]

Hi Cornelia,

Good solution.

Regards,

Anand

[Former Member]

Hi Cornelia,

Thanks for the information.

Best Regards,

Sagar