how to force the cubes don't run automatically

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

Post by kiss351523 »

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!
Last edited by kiss351523 on Tue Nov 04, 2014 7:56 am, edited 1 time in total.
Aruis.yu
Posts: 39
Joined: Tue Oct 21, 2014 10:20 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: TM1 log in issue

Post by Aruis.yu »

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 have no idea about this, but I also want to know this answer.
I think you can modify the subject to such as" how to force the cubes don't run automatically", thing like that.
Paul Segal
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

Post by Paul Segal »

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
Paul
Gabor
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

Post by Gabor »

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

Post by kiss351523 »

tks for your help!! :D
kiss351523
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

Post by kiss351523 »

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.
TKS for you help!
mvaspal
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

Post by mvaspal »

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
blackhawk
Community Contributor
Posts: 136
Joined: Thu May 29, 2008 2:29 pm

Re: how to force the cubes don't run automatically

Post by blackhawk »

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