How to use }StatsStatsByCube ?

Post Reply
beber005
Posts: 57
Joined: Mon Mar 03, 2014 2:18 pm
OLAP Product: Cognos
Version: 9.5.1
Excel Version: 2010

How to use }StatsStatsByCube ?

Post 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 ?
Wim Gielis
MVP
Posts: 3230
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How to use }StatsStatsByCube ?

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
beber005
Posts: 57
Joined: Mon Mar 03, 2014 2:18 pm
OLAP Product: Cognos
Version: 9.5.1
Excel Version: 2010

Re: How to use }StatsStatsByCube ?

Post 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
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: How to use }StatsStatsByCube ?

Post 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
"You Never Fail Until You Stop Trying......"
Post Reply