Dear all,
I have one question:
There is a TM1 system which has 128 cubes built in, when I try to log in, it takes more than 2 minutes to load those cubes, I just wondering that is it any method to force those cubes do not automatically loading, only when I click the cube it starts loading instead.
Thanks for your help!
how to force the cubes don't run automatically
-
- Posts: 51
- Joined: Thu May 05, 2011 2:05 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007 and 2003
- Location: Asia
how to force the cubes don't run automatically
Last edited by kiss351523 on Tue Nov 04, 2014 7:56 am, edited 1 time in total.
-
- Posts: 39
- Joined: Tue Oct 21, 2014 10:20 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: TM1 log in issue
I have no idea about this, but I also want to know this answer.kiss351523 wrote:Dear all,
I have one question:
There is a TM1 system which has 128 cubes built in, when I try to log in, it takes more than 2 minutes to load those cubes, I just wondering that is it any method to force those cubes do not automatically loading, only when I click the cube it starts loading instead.
Thanks for your help!
I think you can modify the subject to such as" how to force the cubes don't run automatically", thing like that.
-
- Community Contributor
- Posts: 306
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
Re: TM1 log in issue
I'm no google master, but "tm1 load on demand" gets me this. It's a clue.
http://publib.boulder.ibm.com/infocente ... 81325.html
http://publib.boulder.ibm.com/infocente ... 81325.html
Paul
-
- MVP
- Posts: 170
- Joined: Fri Dec 10, 2010 4:07 pm
- OLAP Product: TM1
- Version: [2.x ...] 11.x / PAL 2.0.9
- Excel Version: Excel 2013-2016
- Location: Germany
Re: how to force the cubes don't run automatically
If we talk about the time it takes to just log in to TM1 using a pure TM1 interface, then Load on demand has no effect on it. This parameter simply moves the cube load time from server startup phase to the point when you try to open the cube (the click/double click on the cube ).
Furthermore, if I assume your TM1 server is already up and running during the test, then you should get the list of objects (incl. cubes) displayed immediately after login.
The critical issue here is that a slow network will cause such a delay, which is valid for clients like Architect & Perspectives, while TM1 Web can still work properly.
So, the primary question is, what type of client are you talking about? Having the chance to connect remote to the server box and start Architect there would give the quickest answer to the network topic.
Furthermore, if I assume your TM1 server is already up and running during the test, then you should get the list of objects (incl. cubes) displayed immediately after login.
The critical issue here is that a slow network will cause such a delay, which is valid for clients like Architect & Perspectives, while TM1 Web can still work properly.
So, the primary question is, what type of client are you talking about? Having the chance to connect remote to the server box and start Architect there would give the quickest answer to the network topic.
-
- Posts: 51
- Joined: Thu May 05, 2011 2:05 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007 and 2003
- Location: Asia
Re: how to force the cubes don't run automatically
tks for your help!!
-
- Posts: 51
- Joined: Thu May 05, 2011 2:05 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007 and 2003
- Location: Asia
Re: how to force the cubes don't run automatically
TKS for you help!Gabor wrote:If we talk about the time it takes to just log in to TM1 using a pure TM1 interface, then Load on demand has no effect on it. This parameter simply moves the cube load time from server startup phase to the point when you try to open the cube (the click/double click on the cube ).
Furthermore, if I assume your TM1 server is already up and running during the test, then you should get the list of objects (incl. cubes) displayed immediately after login.
The critical issue here is that a slow network will cause such a delay, which is valid for clients like Architect & Perspectives, while TM1 Web can still work properly.
So, the primary question is, what type of client are you talking about? Having the chance to connect remote to the server box and start Architect there would give the quickest answer to the network topic.
-
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: how to force the cubes don't run automatically
Hi
I fully agree with Gabor. We had a system with a very fast WAN connection where all query times, drill downs in cube views, DBS formulas etc. worked within seconds, but during login, simply listing all server explorer objects (cubes, dims, processes, etc.) took for 5 minutes. We couldn't do too much about it unfortunately (other than workarounds like terminal clients, web, etc.)
So it can happen that even with ana cceptable WAN speed the listing of server objects is a way too slow.
I also had another thread about this issue here on the forum
I fully agree with Gabor. We had a system with a very fast WAN connection where all query times, drill downs in cube views, DBS formulas etc. worked within seconds, but during login, simply listing all server explorer objects (cubes, dims, processes, etc.) took for 5 minutes. We couldn't do too much about it unfortunately (other than workarounds like terminal clients, web, etc.)
So it can happen that even with ana cceptable WAN speed the listing of server objects is a way too slow.
I also had another thread about this issue here on the forum
Re: how to force the cubes don't run automatically
One question...do you have 'Display Control Objects' on? If you do, try turning this off to see if it may help.
Another interesting artifact that I have noticed that leads me to believe the issue is actually the Perspectives/Architect UI not TM1; but I have not really investigated it deeply. If you perform a login with control objects on, and say login takes 10 seconds. To turn OFF 'Display Control Objects' now takes 40-50 seconds. This indicates that the problem may not be TM1 necessarily, but how the UI is handling adding and removing nodes from the tree control they are using.
Again, I have not investigated this deeply because my work around is log out, then turn off 'Display Control Objects' and then log back in. That seems to be much faster, though more clicks.
Another interesting artifact that I have noticed that leads me to believe the issue is actually the Perspectives/Architect UI not TM1; but I have not really investigated it deeply. If you perform a login with control objects on, and say login takes 10 seconds. To turn OFF 'Display Control Objects' now takes 40-50 seconds. This indicates that the problem may not be TM1 necessarily, but how the UI is handling adding and removing nodes from the tree control they are using.
Again, I have not investigated this deeply because my work around is log out, then turn off 'Display Control Objects' and then log back in. That seems to be much faster, though more clicks.