Performance Issue with N_CONNECT macro

[nhavis]

Hi,

I have a front-end which makes use of the N_CONNECT macro to log in to TM1.

I've been trying to debug some performance issues when the workbook loads and it appears as if this macro is taking about 13-14 seconds to complete:

Open "C:\test1.txt" For Output As #1
Print #1, Time
vTemp = Run("N_CONNECT", ParamServerName, ParamUsername, ParamPassword)
Print #1, Time
Print #1, "Return Value: " & vTemp
Close #1

Here's the output:

4:17:05 PM
4:17:18 PM
Return Value:

As you can see it has taken about 13 seconds and has completed without error (indicated by no return value).

Does anyone know why this could be taking so long?

Regards.

[Martin Ryan]

I'd be surprised if it was this particular macro. It's more likely to be something that's merely showing symptoms when you use this macro.

How fast is your connection time if you log on to TM1 directly? How long does it take to refresh a slice?

My own system takes a while to log on which I put down to quite complex security settings which take a while to load. It could also be a slow network.

Are you finding other areas of your system give slow response times?

Martin

[nhavis]

Logging on to the server (running on my own pc) is instant, however when the spreadsheet is open and I then log in it often crashes as I get the spreadsheet automatically trying to load and Server Explorer gives me the 'Switch To' option.

Win XP,
TM1 9.4.

[ScottW]

Sounds suspiciously like an auto calc issue.

Have you made absolutely sure that XL calculation mode is manual before running N_Connect?

Application.Calculation = xlManual

[vdag001]

Hi all,

I too was getting this issue.
Was running 9.4 hotfix 3 and then upgraded to 9.4 MR1
This supposedly 'fixed' the login speed and stopped crashing On the N_Connect/N_Disconnect when logging on or off TM1 server explorer if Excel Perspectives was open.

However - its back!

Not sure if MR1 was just a temporary fix or what but the same issues are happening and we are going to deploy our model soon (which is obviously not user friendly now!)

Not sure what it can be??
And yes we have the workbooks set to Calculation = xlManual on Open

Vicky