Analysis for Office - Logon was successful - Loading Screen

[Lorenz_Diem]

Hello everyone,
We are working with SAP Analysis for Office and unfortunately some colleagues cannot log in or fetch data from the server. The following window appears and stays open all the time.

Has anyone ever had this problem and is there a solution?

External consultants have advised us to select the preferred platform, this setting has already been done, but this did not solve the problem.

Many thanks and best regards,
Lorenz

[filipe_zeuch]

Hi Lorenz,
I would suggest to record an AO trace using the latest version of the tool, which might help to identify why AO is hanging in the logon screen. You can download AO 2.8 SP21 by following the instructions in section #2 of Support Content page https://help.sap.com/docs/SUPPORT_CONTENT/sapao/3361385442.html.
Then refer to SAP Note 2129389 to record the traces. The AO traces can be opened in any text editor.

[stefan_dufter]

this helped us:

in Excel: 

File -> Analysis -> Configure Analysis -> Options -> Platform -> Clear Cache

Restart Excel (might be necessary to kill Excel via Task Manager)

Sorry, I can't provide the screenshot in english language.

[Henry_Banks]

Hi @tilted 

There’s information about a root cause in Note https://me.sap.com/notes/3481865  “The blocking was caused by a change on June 13 on BTP Token API on all landscapes. this change was reverted on June 14.”

regards, H 

[Henry_Banks]

Hi @Lorenz_Diem did you make a breakthrough on this?  How did you solve it? regards, H

[Lorenz_Diem]

Hi @Henry_Banks unfortunately, we were not able to solve this problem 100%. What helped us was to set the preferred platform and to empty the caches via the technical configuration. We noticed that this misbehavior occurs when the connection is briefly interrupted during login. We then restart Excel and it usually works.

[tilted]

We have the same problem! Is there any workaround?