How to get an automatic cubeview refresh with TI Process

[jjramirez]

Good Mornig Everybody

I have a master TI Process that is calling 12 subprocess inside (one for each month of the year) and all of them is writing the same cube but in differents sections. I created a cubeview that allows me to monitor what processes are runing and what processes are completed but i need to refresh the view manually using the cubeviewer button to see the last update.

I would like to know if is there anyway to put a code line in the Epilog of each TI Proccess that refresh the view after finish all the actions.I think this way i will see the updates after each process finish.

is it possible?

If not, how can i do that?
This is the cubeView, it's like control table, maybe you can recomend something different to do it:



Thank you so much in advanced!

[Wim Gielis]

Unless I'm mistaken, you will always have some sort of refresh or recalculate action.

[tomok]

What exactly do you mean by "refresh the view". Do you mean change values in the underlying cube or do you mean recalculate the view automatically so you don't have to click on the recalculate button. If it is the latter then sorry, a TI process can't do that.

[jjramirez]

yes TomoK, i mean recalculate the view automatically without any click on the recalculate button.

i need to show to other users the masterProcess progress in the cubeviewer. Another option is create and publish a websheet and put a VBA Code that recalculate the excel sheet every X seconds or mins. But TM1 web doesn't support excel macros.

If you know other ways to do this, please let me know where i can read about it.

thanks for your answers

[lotsaram]

The CLIENT is independent of the SERVER.

Client requests data, server responds and sends data, client renders data for viewing. And that is how it stays until the client makes another request.

Any "automatic refresh" needs to be triggered from the client side. What you want is achievable in Excel (with some VBA) but not in cube viewer or TM1 Web. You could do it fairly easily in a custom html page getting the data via the Rest API.

[jjramirez]

I'll give it a try with vba first, Thank you very much for your answer lotsaram