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

How to find some help ?

At first, please read carefully this Troubleshooting page. You'll find here the most common issues spotted by the users and the way to solve it by yourself.

In a second time, if you need further assistance, you can contatc BW Team at SBS Support

Please include in your mail: the description of the issue, whith screenshots, error messages. If possible, in case of wrong values indicate what the figures should be.

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 and click on "Enable".

   

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:

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

Error message "Installation error "Missing Active X"" 

Problem : the user is trying to use a reporting tool that is no more installed in his/her computer

Solution :

1. Check the tool you are trying to use is already installed (Start / All programms / ...)
2. If the tool is BW Analyser 3.x, please use Analysis tool instead.
3. If the tool is BW Analyser 7.x or Analysis, please contact your local Service Desk Infra to reinstall the tool
   

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 File >Analysis menu, 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.
   
   
   

Why the folder/query/labels names are not as usual when I logon BW Analysis?

Problem : The folder/query/labels names look as below

Analysis :

The reason might be the user's default logon language being not EN or FR or PT.

In the following example, it's ZH(Chinese), but the folder names in ZH are not well maintained.

Solution 1:

For long term, ask Helpdesk members to contact Authorization team to change the Logon Language to be EN or FR or PT.

For short term, when logging

via the SSO mode :

Change the language to EN as schown.

w/o  SSO mode :

clicks on "Options >>" , then a language box will be shown and  type in EN to select English.

SSO 

Solution 2:

The automatic logon with SSO select your native langage which is not English. The solution is to force Analysis to use EN language.

1. File / Analysis / Parameters / Advanced parameters
2. Check "Allow mandant and language selection for SSO connection"
3. Press "OK", close and restart Analysis. you can now select the "EN" language.

When insert data source, get errors like "Value cannot be null" ,"Index out of range", Item already ...

Problem :

Cause of these issues  : the SAPUILandscape.xml which contains the path to the server list is corrupted. 

Solution : Go to the directory   C:\Users\<UserID>\AppData\Roaming\SAP\Common

 delete  the existing SAPUILandscape.xml file, then opening the saplogon that  will automatically generate a new SAPUILandscape.xml file in the directory.

AppData is usually an hidden folder, so to display it you need to open the configuration panel > Folder Options

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:

The message "Size limit of result set exceeded" returns

Problem : when you refresh with a broad condition, there are a lot of data to retrieve, Analysis display "Size limit of result set exceeded" in the result cell.

Reason:  There can be a size limit on the number of cells that SAP BO Analysis Office should manage, either on server side, or on client (Analysis) side. This limit throws the above message when the number of cells increases above the threshold value. 

Solution: The Size limit can be set to a higher value either in individual Client PC ( Option1 and what you need to do ) and the BW Server side (Option2).

Option1 : This is to be done by altering the Windows Registry Parameter.

Run the following command in Command Prompt (cmd.exe):

REG ADD HKCU\SOFTWARE\SAP\AdvancedAnalysis\Settings\DataSource /v ResultSetSizeLimit /t REG_SZ /d 9000000

This would set set the limit to a much higher value: 9000000 Cells.

Then try again, it should be ok.

If still not working, please save the file as "xlsm" file instead of “xlsx” and try again. This needs to be confirmed.

Option2: To maintain Size limit centrally. Please refer to http://scn.sap.com/thread/3459138

I have the message "No authorization"

Problem : Since June 2015, you have an error message when you try to refresh a query/workbook : you do not have the correct authorization to execute the query or to select this perimeter. 

Due to the necessity to exclude Butachimie and Eco Services data from the BW scope, the Authorization management process has changed : it's now necessary to select, at least, one Company and Plant. Or for application WCAP and P&L, the Company PRS is also mandatory.

Solution : Be sure you select at least one Company and one Plant in the Prompt area, even if theses fields are not mandatory!

If you need to access all Companies or Plants, please fill the prompt with the following values :

• Values to use:

Please note that the issue only occurs if you open a workbook. If you open directly a query, the Company and Plant prompts will automatically be filled with all the values you are allowed to access. 

If necessary, please contact your BW Support team (SBS Support) to check your authorizations.

When Filter by Member

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
   
   

Can't click on the right Analysis Design panel

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

 ==> 

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

I want to dupplicate a table

Problem : You want to dupplicate an existing query to filter the new one on another perimeter. You have used Excel sheets dupplication functionality but you can't refresh the new query.

Analysis :

Using the Excel sheets Dupplication functionality only copy the data. The BW links are not copied. Thats' why you can't refresh the copied table.

1. Go to the right Analysis Panel / Components
2. Click on "By Sheet" to see the Excel sheets which are linked to a BW query (the ones which have a "+"). 
   In the example, only the sheet "Novecare" is linked to BW query.
   

Solution :

1. On excel, go to the new sheet (in the example, "Energy Serv"). 
   Please remind that your new table will be build where you have clicked.
2. Go to the right Analysis Panel / Components.
3. Click on "By Sheet".
4. Unroll the "+" to see the existing crosstab linked to BW query.
5. Right click on the crosstab and select "Copy"
   
6. Your excel file now have 2 similar queries that can be refreshed/filtered/modified independently.
   

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

Whenever Analysis is closed, a "MS Excel has stopped working" window will show

Problem: After Analysis is opened, when we try to close it, the following window shows. Then some seconds later, Excel was reopened without Analysis tab.

Solution : 

Same as the one above.

Go to Excel / File / Options / Add-ins, then select "Excel Add-ins" in "Manage", click Go.

Uncheck all the boxes below. 

Then the issue disappears.

When changing password, Analysis displays "Password not allowed".

It might be due to the following new rules :

must be at least 8 characters long
must include at least one letter
must include at least one number
must mix lower and uppercase characters
new password must be different from last 5 passwords

Other things about passwords

a newly created account has to be used within the 14 days
a user must be locked after 6 failed attempts
a password must be changed at the latest every 90 days

Why after upgrade of SAPLogon(to V7.40) and Analysis(to V2.1.3), Analysis becomes very slow to response ?

Solution :

How to open BW Analysis via RAAOE SAP transaction