Welcome to the Business Warehouse troubleshooting. You will find here most of the error messages, their meaning and solutions.

After an Excel crash, the Analysis menu is no longer visible.

Problem: After a Microsoft Excel crash, you reopen Analysis but the Analysis bar is no longer visible in the menu with the following error message :

Solution: To solve this you need to re-active the Analysis plug-in which has been deactivated by Excel.

1. Open Excel  -> File - >Options

   
2. Open "Options" -> Add-Ins" -> In Manage, select "Disabled Items“ -> Go.
   
3. In the "Disabled Items" dialog box, select the Analysis Add-In.
   
4. In Manage box, select "COM Add-ins", press Go
   
5. Check the box in front of "Analysis", then click OK.
   
6. Then Analysis ribbon is activated.

Unable to see the workbook structure in Design Panel / Components tab

Problem : Unable to see the workbook structure in Design Panel / Components tab

Solution : 

1. Right click on desktop, and select "Personalize".
   
2. Click on Display.
   
   
3. Select "Smaller - 100%(default)", and apply. You need to relogon to make the change effective.

Can't save workbook onto WBP server

Problem: Users can't save a workbook onto the "My documents" folder in WBP server

Solution : No solution at the moment. It's like that

Can't refresh a workbook from others

Problem : I can't refresh a workbook from my colleague with error message :

Solution : 

The issue is due to your SAPLogon.ini being different from your colleague. You may need to ask local IT to upgrade your SAPLogon.ini.

Or a temporary solution :

In Design panel / Components tab, relocate the data source:

Why there is no data after I save the workbook ?

Problem : Why there is no data after I save the workbook ?

Solution :

In Design Panel / Components tab, on workbook level, uncheck the "Remove Data Before Saving" option.

BW team use this option to save a template ( with no real data ) on the server. So for many workbooks on the server, this option is checked by default.

Error message "Cannot run the macro "CallbackAfterWorkbookClosed"" when opening Analysis

Problem : Get the following error when opening Analysis, and the mouse cursor is all the time in "refreshing" status even no refreshing at all.

Solution : In Analyzer 7 , change the following Workbook setting to "Run Macro on Refresh".