Is it possible to purge a stargate view?

Post Reply
jwafro
Posts: 25
Joined: Thu Sep 07, 2017 8:31 am
OLAP Product: TM1
Version: 10.2.2 / 9.5.1
Excel Version: 2003 2010

Is it possible to purge a stargate view?

Post 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
User avatar
Elessar
Community Contributor
Posts: 331
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?

Post 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/
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
jwafro
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?

Post by jwafro »

Thank you!
jwafro
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?

Post 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
User avatar
Steve Rowe
Site Admin
Posts: 2410
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?

Post 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.
Technical Director
www.infocat.co.uk
Post Reply