Refreshing }PerfCubes &}PerfClients
-
- Posts: 141
- Joined: Wed Mar 09, 2011 1:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2003 2007 2010 2013
Refreshing }PerfCubes &}PerfClients
Hi all
Is there any possible way other than rebooting the system to refresh these Dimensions?
}PerfCubes &}PerfClients
When I add new clients to the system they do not show in this dimension and the same for cubes
thanks all
Is there any possible way other than rebooting the system to refresh these Dimensions?
}PerfCubes &}PerfClients
When I add new clients to the system they do not show in this dimension and the same for cubes
thanks all
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Refreshing }PerfCubes &}PerfClients
The new elements are only added when an event that triggers logging occurs (at least in 9.5.2, probably the same in 10.1). They aren't added at the time that you create the cube or the client, as the case may be.Darkhorse wrote: Is there any possible way other than rebooting the system to refresh these Dimensions?
}PerfCubes &}PerfClients
When I add new clients to the system they do not show in this dimension and the same for cubes
(I also haven't checked whether StatsByCubeByClient is still borked in 10.1 but shall when I get a chance. Regardless, the cubes that aren't should still trigger the element addition.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- 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: Refreshing }PerfCubes &}PerfClients
That looks like a YES based on my experience (currently using bare 10.1.1 in prod and testing 10.1.1 FP1). It is still broken, no surprises there.Alan Kirk wrote:I also haven't checked whether StatsByCubeByClient is still borked in 10.1 but shall when I get a chance.
Kamil Arendt
-
- Posts: 141
- Joined: Wed Mar 09, 2011 1:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2003 2007 2010 2013
Re: Refreshing }PerfCubes &}PerfClients
Im finding stats by cube by client is working in 10.1 here.
How do i create a logging in the system to jump start these Dimensions? any Ideas?
How do i create a logging in the system to jump start these Dimensions? any Ideas?
-
- 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: Refreshing }PerfCubes &}PerfClients
Log in as that client and interact with the cube(s). That's the only way I know of.Darkhorse wrote:How do i create a logging in the system to jump start these Dimensions? any Ideas?
-
- Posts: 141
- Joined: Wed Mar 09, 2011 1:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2003 2007 2010 2013
Re: Refreshing }PerfCubes &}PerfClients
Ive been interacting with the cube for days its still not showing.
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Refreshing }PerfCubes &}PerfClients
Isn't it just. The one and only decent method that we have of effectively monitoring who uses cubes and when, and it's been forked since 9.4. Oh well, guess it's not important for sales presentations, then.qml wrote:That looks like a YES based on my experience (currently using bare 10.1.1 in prod and testing 10.1.1 FP1). It is still broken, no surprises there.Alan Kirk wrote:I also haven't checked whether StatsByCubeByClient is still borked in 10.1 but shall when I get a chance.

The best part is this:
Code: Select all
Admin }StatsByCubeByClient Elapse Time (ms) View Calculation 18 44
Admin }StatsByCubeByClient Elapse Time (ms) View Retrieval 28789527375 5.0321E+12
Maybe the }StatsByCubeByClient cube is actually a top sekrit test bed for a new random number generator.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Refreshing }PerfCubes &}PerfClients
Define "interacting".Darkhorse wrote:Ive been interacting with the cube for days its still not showing.
Interestingly in 10.1.1 I didn't have to wait for a loggable event; the cube and client both showed up in the dimensions immediately after creation. I didn't even have to wait for the minute barrier to tick past.
However, at the risk of belabouring the obvious...
(a) You have checked that Performance Monitor is running, yes? That when you right click on the server the menu option is "Stop Performance Monitor", not "Start Performance Monitor"? Because obviously Performance Monitor is not going to update its dimensions if it's asleep.
(b) You have opened the dimension and punched the All Elements button, yes?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 141
- Joined: Wed Mar 09, 2011 1:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2003 2007 2010 2013
Re: Refreshing }PerfCubes &}PerfClients
Alan Not to want to argue with someone who is unquestionably the leading man in information on all that is Tm1 but i use this cube daily just to see who is logged in and which cube there in n the last hour. I dont use the values just the Who and it is by all personal reconciliations Correct 100% for this purpose, agreed i pay no merit to the actual data in the cube just the fact there is data.
and in answer to your two questions Performance monitoring is on and i have over the last few days been using the dimensionds for a week, I ended up rebooting instead
and in answer to your two questions Performance monitoring is on and i have over the last few days been using the dimensionds for a week, I ended up rebooting instead
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Refreshing }PerfCubes &}PerfClients
Hang on, which of the PM cubes are you using? It's only StatsByCubeByClient that is borked, AFAIK. I checked this, and the question of whether the dims updated on 10.1.1 before I posted so if you're experiencing something different then something interesting is afoot. Do you have any hot fixes applied?Darkhorse wrote:Alan Not to want to argue with someone who is unquestionably the leading man in information on all that is Tm1 but i use this cube daily just to see who is logged in and which cube there in n the last hour. I dont use the values just the Who and it is by all personal reconciliations Correct 100% for this purpose, agreed i pay no merit to the actual data in the cube just the fact there is data.
and in answer to your two questions Performance monitoring is on and i have over the last few days been using the dimensionds for a week, I ended up rebooting instead
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 141
- Joined: Wed Mar 09, 2011 1:25 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2003 2007 2010 2013
Re: Refreshing }PerfCubes &}PerfClients
to be fair i believe its 10.1.2 I think I need to update my profile, apologies for the confusion