I don't see in }StatsbyCube - elements Memory Used for Views and Number of Stored Views any information - it shows 0.
I opened views (at first they opened long but the second time much faster), used ViewConstruct (with the same results), I put VMT and VMM in }CubeProperties - in logs I saw
New Stargate created (sometimes I saw after it Destroying stargate - but not in all cases).
So everything shows that Stargate views are created but I can't see it in }StatsbyCube
May be somebody knows why and that can I do to see something more than zero in }StatsbyCube
Stargate views and }StatsByCube
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Stargate views and }StatsByCube
I presume you turned monitoring on for the server and waited a minute then refreshed.
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
Re: Stargate views and }StatsByCube
Of course PerformanceMonitorOn=T
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Stargate views and }StatsByCube
That doesn't actually start performance monitor, it just gives the option of starting it. You still have to right-click on the server in Architect or Perspective and choose Start Performance Monitor.EP_explorer wrote:Of course PerformanceMonitorOn=T
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Stargate views and }StatsByCube
Nope. This parameter does exactly that: automatically starts populating the }Stats control cubes when a server starts.tomok wrote:That doesn't actually start performance monitor, it just gives the option of starting it. You still have to right-click on the server in Architect or Perspective and choose Start Performance Monitor.
As to OP's problem... What is your CalculationThresholdForStorage setting? Maybe your cube calculations are simple enough that they are not getting cached? You can try bringing it below the default 50 to see if it changes the stats you are seeing.
Kamil Arendt
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Stargate views and }StatsByCube
The calculation threshold affects when individual calculated or aggregated cells are stored in the calculation cache, which is completely separate from the view cache, which is controlled by the VMM and VMT parameters.
In reality they are related as if you have cached stargates it can make individual calculations (involving e.g. aggregates from other cubes) take fewer steps and thus fall under the threshold. In a similar way if a view is an aggregation of calculated leaf cells and all the leaf cells are already cached it can take less time to create the view, and so fall under the VMT threshold.
The other thing is that changing a single cell in that cube or any upstream cube will clear out both kinds of cache.
In reality they are related as if you have cached stargates it can make individual calculations (involving e.g. aggregates from other cubes) take fewer steps and thus fall under the threshold. In a similar way if a view is an aggregation of calculated leaf cells and all the leaf cells are already cached it can take less time to create the view, and so fall under the VMT threshold.
The other thing is that changing a single cell in that cube or any upstream cube will clear out both kinds of cache.
-
- MVP
- Posts: 264
- Joined: Mon Nov 03, 2014 8:23 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2 PA2
- Excel Version: 2016
Re: Stargate views and }StatsByCube
Also, if you have TM1.Cube.Stargate.ViewStorage=DEBUG you should see a message similar to "ViewStorage::AddStargate: Stargate (0x1234567812345678) added to ViewStorage (0x1234567812345678)." In the logs when the stargate is cached. If you're not seeing this, you are likely seeing the calculation cache in use and not the view cache.
If I remember correctly, the stargate calc needs to take >5s to get cached anyway. Since nothing is ever simple with TM1 there are probably a number of other gotcha's too.
If I remember correctly, the stargate calc needs to take >5s to get cached anyway. Since nothing is ever simple with TM1 there are probably a number of other gotcha's too.