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.

  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.

 

Installation and troubleshooting : Installation Check

If you receive a message error you can check the installation log file by the installation check as described below:

  • 1. Press Start - Run
  • 2. Enter nwcheckworkstation
  • 3. Continue the appearing wizard
  • 4. Before clicking Finish make sure Checkbox "Collect diagnostic
  • 5. information for SAP Support" is checked
  • 6. Press Finish

On this file you have much information and to find the specific one you will check at the error folder.

On the folder you will be able to see the below error:

Affichage de image.png en cours...

 

 

 

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

 

Can't access to SAP Logon

Problem : When opening a query/workbook, this screen is displayed, instead of the list of Servers.

Solution :

  1. Click on SKIP
  2. On the Analysis toolbar, go to SETTINGS
  3. On Platform settings, select "NetWeaver" as your Preferred Plaform
  4. Close all Excel files and restart Analysis to normally have access to the BW reports.

Can't click on the right Analysis panel

Problem : After opening a workbook, users receive an error message if they click on the Analysis Panel, at the right side of the screen

 ==> 

Solution : Refresh the workbook first, and then click on the Analysis Panel

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.

     

 

Analysis :  The reason for the two windows above is that the items number exceeds the Maximum number.

See below :

 

Solution 1 : Change the Maximum if it's too small. Otherwise,

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

   

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

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 : 

  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.

Red Cross in Columns

Problem :

Solution :

  1. Save your work
  2. Close all Excel files
  3. Restart Analysis tool
  4. Refresh your query/workbook

 

 

Miscellaneous

Mouse is always displayed as a Timer

Problem : Once the refresh is over, the mouse still appears as a Timer, even if the user can normally works on Analysis.

Solution :     

  1. In Excel, go to File / Options


  2. Check in the Add-ins – Excel Add-ins
     

  3. Untick the « Analysis Toolpak and the Analysis Toolpak-VBA


  4. Save you work