Page 1 of 1

How to use }StatsStatsByCube ?

Posted: Tue Sep 02, 2014 9:48 am
by beber005
Hey everyone :)

I would like to use this specific cube name }StatsStatsByCube !! My question is : we must activate something in TM1 to make it usable ? Or is it directly usable?
Because thank's to this cube I want to know what cubes were updated, what time and so on. Do you think is it possible ?

Re: How to use }StatsStatsByCube ?

Posted: Tue Sep 02, 2014 11:53 am
by Wim Gielis
beber005 wrote:I would like to use this specific cube name }StatsStatsByCube
What version of TM1 do you use? I don't have such cube.

For statistics like this, you should right-click the TM1 Server Name and choose "Start Performance Monitor".
Wait a minute or so and then you can start investigating in the relevant control cubes.

Re: How to use }StatsStatsByCube ?

Posted: Thu Sep 04, 2014 5:50 am
by beber005
I use the version 9.5.1 of TM1

No, "Start Performance Monitor" gives it to me just MY own performance. I want statistic for all users of TM1 in my service. I don't know if it's clear

Re: How to use }StatsStatsByCube ?

Posted: Thu Sep 04, 2014 5:59 am
by BariAbdul
Hi beber005 ,enabling permformance monitor gives you following control cubes:

The following control cubes are populated during performance monitoring. For details, see

Control Cubes.

}StatsByClient
Tracks the message count, average message size, total elapsed time, and other measures for each client on the server.
}StatsByCube
Tracks the memory used for each cube on the server.
}StatsByCubeByClient
Tracks the number and elapsed time of cell updates, cell retrievals, view calculations, and view retrievals for each client and cube on the server.
}StatsForServer
Tracks the connected clients, active threads, and memory used by the server.

Make sure logging is enabled in CFG file in order to data reflect in these control cube.Thanks