Page 1 of 1

Is it possible to purge a stargate view?

Posted: Tue Sep 19, 2017 8:54 am
by jwafro
Hi All

I have a question and apologies if it has been answered elsewhere, but I can't find a similar thread.

I am testing my model and want to refresh the same view; I want to see the time it takes to complete a full recalculation.

Is there an easy way barring turning the entire model off/on or changing the source data that can invalidate the cache?

I have tried taking off the settings for VMM/VMT but the views are still in memory.

Cheers
Josh

Re: Is it possible to purge a stargate view?

Posted: Tue Sep 19, 2017 9:00 am
by Elessar
Hello,

You can unload the cube by 2 ways:
  • Right-click on the cube in Architect, "Unload cube"
  • Use "CubeUnload(CubeName);" TI function
When you change VMM/VMT, the stargate view does disapear, but the calculation cache remains
You can find the details in Sachin's blog: https://everanalytics.wordpress.com/201 ... explained/

Re: Is it possible to purge a stargate view?

Posted: Tue Sep 19, 2017 9:26 am
by jwafro
Thank you!

Re: Is it possible to purge a stargate view?

Posted: Tue Sep 19, 2017 10:02 am
by jwafro
I note that Right-Clicking on Architect 'Unload Cube' also forces a reevaluation of feeders, does the TI script approach perform the same function?

J

Re: Is it possible to purge a stargate view?

Posted: Tue Sep 19, 2017 10:23 am
by Steve Rowe
Also you can just put a number into the cube, this is enough to purge the cache. Unloading the cube is a bit drastic and may break the model if there are feeders.