Connexion time very long

[former_member644785]

Hello,

When we try to connect to Analysis for Excel, response time is very long before executing the querie.

I mean screen with connexion parameters and then screen to choose BICS connexion.

Is there a way to accelerate the connexion ?

Thank you in advance

Regards,

Nicolas 

[Former Member]

Hi Nicolas, If this persists in SP8 you could try to change a setting in Internet Options. For me it has worked, however I do connect to Netweaver not BI platform, but I think the issue could be the same.

Open IExplorer, Internet Options, Advanced and de-select the option "Check for publisher's certificate revocation" under Security. Then try again and see if there is any difference.

[former_member644785]

Hello Kyriakos,

I've just tested your tip with version 1.4.8.3163 but unfortunatly no difference.

Have you got another idea ?

Regards

Nicolas

[Former Member]

Hi Nicolas,

We experienced similar issues but only on selective machines, in our case
note 1781616 solved our issue (Same as Farmakis comment)

I think it has something to do with your proxy/internet explorer setup. Can
you run a trace route and check your hops.

To do a trace rout, at the command prompt, type tracert YourBOBJserver.com

You may need some assistance from your network team to confirm the servers
it hops to before going to your bobj server.

Have you checked your browser is setup to bypass proxy for local servers and
that your bobj server list listed in your local servers list?

[Former Member]

Hi Nicolas,

Are you talking about the time it takes from when you select ok button on the login screen till the time it shows you a list of OLAP connections you have defined in your bobj server?

[former_member644785]

Hi Mickal

yes I'm talking about this time.

I've just tested the new version 1.4.8.3163 and this is the same response time and some time it doesn't work (error message) .

But when I select a querie in my historical list, it's ok.

Thank you in advance if you have any idea.

regards,

Nicolas

[TammyPowlas]

Hi Nicolas - are you on the latest release for Analysis Office?  Every release they make performance improvements.

Which version of the BI platform?

[former_member644785]

Hello Tammy,

We use version 1.4.6.2960 with BI 4.1 SP2 patch 6 (We're testing BI 4.1 SP3 patch 5)

Is there a new version of analysis for excel ?

Regards,

Nicolas

[TammyPowlas]

Hi Nicolas - yes, Analysis Office 1.4 SP8 is out

Could you try with the latest patch?

Tammy