Hi there, I have used Analysis for Office 2.8 SP0 and created several workbooks with BW Queries. Then I have upgraded to AFO 2.8 SP8 and today also to 2.8 SP11 (which has the same error).
The problem after upgrading AFO is that if I open an existing Excel AFO file which was created with 2.8 SP0 and I am at that time not yet logged in to our BW, that the login after choosing 'Refresh' or 'Prompts' does not work. The login screen comes, I enter my password and then I receive the following error message after typing in the right password:
What I have to do now is going the long road. I have to click in an empty Excel area, choose Insert Data Source, Select Data Source for Analysis. Choose our BW server and then login. This works. Afterwards I just cancel the Insert Data source and up from that time I can refresh the existing Query without error.
Means I have to login to BW via Insert Data Source. Otherwise I get for the Login the above error message.
- For Queries which I created with SP8 or later, this issue does not exist. Here I can directly login in the refresh procedure without problem
Anyone an idea what I can do to fix it?
BW Server used is Netweaver 7.50 SP10
- SAP Managed Tags:
Accepted Solutions (1)
In case anybody else is having this issue, the only way to fix it is a one time action per each locally saved AFO Excel file. You need to open the AFO Design Panel, go to ribbon 'Components' and right click on the file name. Then say "Replace System" and choose the right BW Server. Afterwards save the file and it will not happen again for this workbook.
I don't know why this happened just due to a new Analysis for Office version. It must have happened anytime between 2.8 SP0 and SP5.
Answers (0)
| User | Count |
|---|---|
| 79 | |
| 9 | |
| 9 | |
| 7 | |
| 7 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.