Stargate views and }StatsByCube

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Stargate views and }StatsByCube

Post by EP_explorer »

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
Duncan P
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

Post by Duncan P »

I presume you turned monitoring on for the server and waited a minute then refreshed.
EP_explorer
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

Post by EP_explorer »

Of course PerformanceMonitorOn=T
tomok
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

Post by tomok »

EP_explorer wrote:Of course PerformanceMonitorOn=T
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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
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

Post by qml »

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.
Nope. This parameter does exactly that: automatically starts populating the }Stats control cubes when a server starts.

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
Duncan P
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

Post by Duncan P »

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.
BrianL
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

Post by BrianL »

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.
Post Reply