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

This troubleshooting relates to "Analysis - The troubleshooting for the Analyzer has been moved here.

When opening Analysis

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.

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

My report and Analysis are opened in two Excel programs

You need to first open "Analysis for Microsoft Excel", then open your BW file ( by File --> Open or Recent ).

Go to Open a workbook ( saved on your local drive ) for more detail.

Error message "Cannot run the macro "CallbackAfterWorkbookClosed""

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".

When saving workbook

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

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.

When Refreshing

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:

When Filter by Member

Unable to see the list of all members

Problem : when you do "Filter by Member", you can't select from a list.

Solution 1 : Change the setting below.

Solution 2 : Choose "Paste from Clipboard" way as below.

Solution 3 : Click "Add" to get the "Find Members" window. Then do a search.

In Design Panel

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

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

Solution :

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