Hello,

Suppose I have four panels on a dashboard. Panel A calculates X (as well as some other calculations). Panel B calculates Y (as well as some other calculations). Panel C needs to show X and Y. And the fourth is a filter panel with some drop downs and a submit button (we'll call this panel D). The other three panels update whenever this submit button is clicked and they all respect whatever filters are selected.

Now I really hate using redundant code, so ideally for me, panel C will only update when both A and B run and save the results to some place (global variable or maybe a hold file). And I don't want to create a bunch of extra code to achieve this either. The solution I'm looking for should simplify the coding.

I know this can be done with INCLUDE statements, but this can become spaghetti-ish too but more importantly we end up running the same code/query multiple times (though modular code is great, I get it). I'm trying to write code that won't be hard to maintain, neat and efficient.

Any options out there?

Thank you!

This message has been edited. Last edited by: FP Mod Chuck,

You can store your results in FOCCACHE. FOCCACHE is a session storage and will be active from login to logout.

I would't drive the redundant code thing too far and try to keep thing transparant and easy.

Thanks for the quick reply... But...

...when the Submit button is hit, how can I control that panel C only uses the values in FOCCACHE after panels A and B were run (and updated the values in FOCCACHE)?

Shingles

I am not sure that is possible you may want to pose that question to techsupport to see if there is a way.