​AFO: Workbook refresh issue

[DebjitSingha]

Hi,

I am facing an issue refreshing an AFO Workbook based on an input-ready query.
When I change a value in a cell without save it and then I refresh the workbook (Refresh Prompt or “Refresh All” button), I continue to see the new entered value in the cell, although it was not saved. If I close and open again the workbook, the cell shows me the correct value. The refreshing issue happens only if the Workbook is based on input-ready query.

Can anyone help me on how refresh correctly the Workbook?

Thanks.

[DebjitSingha]

What version of AFO you are using and what is the backend system?

Thanks,

Debjit

[gregor_dieckmann]

Hi Gabriele,

why do you think this is an issue? Changing a cell value in an input-ready query and then calling some command with implicitly trigger a 'Recalculate'; so if nothing is wrong with the changed value the value is send to the planning buffer and 'refresh' will simply re-read the most recent data from the buffer.

Why is this behavior reasonable?

After changing a cell value and the pressing a button to execute a planning function you don't want to execute 'Recalculate' first; the same is true if you change the query view, e.g. drill-down an additional characteristic in the rows etc.

So refresh just follows this general rule.

Regards,

Gregor