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
Is it possible to purge a stargate view?
- Elessar
- Community Contributor
- Posts: 340
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Is it possible to purge a stargate view?
Hello,
You can unload the cube by 2 ways:
You can find the details in Sachin's blog: https://everanalytics.wordpress.com/201 ... explained/
You can unload the cube by 2 ways:
- Right-click on the cube in Architect, "Unload cube"
- Use "CubeUnload(CubeName);" TI function
You can find the details in Sachin's blog: https://everanalytics.wordpress.com/201 ... explained/
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 25
- Joined: Thu Sep 07, 2017 8:31 am
- OLAP Product: TM1
- Version: 10.2.2 / 9.5.1
- Excel Version: 2003 2010
Re: Is it possible to purge a stargate view?
Thank you!
-
- Posts: 25
- Joined: Thu Sep 07, 2017 8:31 am
- OLAP Product: TM1
- Version: 10.2.2 / 9.5.1
- Excel Version: 2003 2010
Re: Is it possible to purge a stargate view?
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
J
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Is it possible to purge a stargate view?
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.
Technical Director
www.infocat.co.uk
www.infocat.co.uk