elcome 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, contact  SBS Support 

Please do not forget to describe as accurately  you can your  issue,  insert screenshot(s), error messages...

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 one 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 reactivated.

   

"The launcher is exited with error... " when opening "Analysis for Microsoft Excel"

Problem :  With the version 2.1.3, for some users, when they open Analysis by the icon "Analysis for Microsoft Excel", the following error message will be displayed. 

Solution : So far, we haven't found. A temporary solution is asking users to open Excel ("Microsoft Excel 2010") instead of "Analysis for Microsoft Excel". After Excel is opened, Analysis add-in is opened also. So users can continue to use Analysis.

Installation and troubleshooting : Installation Check

How to check your installation in case of an error message :

• 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
• 7 when the process is finished you get that screen  
• 8 Click  to end it. 

By clicking on the Error report you get a list of  errors as referred hereunder.

If you get that list the installation is a correct one, if the list is different an installation must be redone. 

:

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 SAP Servers list.

Solution :

1. Click SKIP button
2. On the File >Analysis menu, go to Settings :
   
3. On Platform Settings, select option "NetWeaver" as your Preferred Plaform.
   
4. Close all eXcel files and restart Analysis (or eXcel) to get that screen
5. 
6. then select the server either PQ1 or WBP to access 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 :

Click on "Options >>" , then language box appears and so type in EN to select the English language.

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"

1. Press "OK", close eXcel, restart Analysis.  you can select the "EN" language via the following popup .

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

In case of the following messages :

Value cannot be null, Index out of range, An Item with the same Key has already been added 

The 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 first the configuration panel > Folder Options and click the corresponding unhide option.

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 variants can not be used

Problem : when refreshing a query, it's not possible to use, modify or save a variant

Reason : The option "Merge variable" is selected on Analysis Design Panel. That's the default value setting on Analysis.

Solution :

1/ Uncheck the "Merge variable"

2/ Refresh one query at a time

3/ You can now use variants

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, the message "Size limit of result set exceeded" is displayed in AO instead of the data.

Reason:  In Analysis for Office, there is a default limit of 500.000 data cells for the result set. This limit exists because of a memory limitation in .NET framework.
When the report retrieves too much data from the backend and end up reaching the limit of data cells, the message "Size limit of result set exceeded" will be shown in AO instead of the expected data.

SAP does not recommend to change the result set default limit of Analysis for Office.

• However, it is possible to change the default limit.
• The limit of data cells has been set up to take into account the the BW backend system parameter
  • , BWP : size limit = 1 000 000 cells. 
  •   PQ1 size limit is  = to the default value 500000 because no rule has been set up in the backend PQ1 server . 

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

In Design Panel the windows width of Rows and Background Filter are not maximized

Problem : Unable to maximize the with of the windows.

Solution : 

1. Right click on desktop, and select "Personalize".
2. alternative : Open the Windows Control Panel, then navigate: Appearance and Personalization > Display.

1. Click on Display.
   
   
2. Select "Smaller - 100%(default)", and apply. You need to relog 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 duplicate a crosstable

Purpose:  You want to duplicate an existing query to filter the new one on another perimeter.

You have used eXcel sheets duplication functionality but you can't refresh the new query.

Solution: 

By using the eXcel sheets Duplication functionality you only copy the data, and so the BW links are not copied.

It is the reason 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.

Workbook takes several minutes to open or crash when Analysis for Office is activated

Opening a workbook with Analysis, edition for Microsoft Office is very slow or causes Analysis, edition for Microsoft Office to crash.

Opening the sameworkbook with the Analysis addin disabled works fine.
Depending on the number of cell styles in a workbook the performance of Analysis, edition for Mircosoft Office decreases as certain calls to Excel get very slow.

The amount of cell styles can be checked via the Home ribbon's Styles section where there is a drop down button called Cell Styles.

Clicking on this button opens the drop down that shows the styles in the workbook.

If this drop down contains a large number (hundereds or thousands) of styles that clearly entlighten the performance degradation.

There are cases where Copying and Pasting cells from one workbook to another cause Excel to add new styles to the workbook.

This is sometimes referred to as "Custom Style Explosion".

Usually the majority of the styles is not even used in the workbook. Therefore deleting the styles will solve the problem.

How to check if you are in such a case.

1. Open the workbook (wait until it is opened);

1. Click on "Home" tab in Excel;

1. Click on the "More" button in the "Styles" ribbon

The drop down with the styles of the workbook will open :

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

It might be due to the following 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

How to index a cell from an Analysis crosstab in a new sheet 

When you are on a non Analysis  tab and wish  to define a formula in a cell using symbol  = and  go to an Analysis  tab for obtaining the reference of the needed cell, this operation doesn’t work because of the behavior of the Analysis tool which deceives eXcel.

The workaround solution to solve that “bug” : on the bad tab (Analyis one) select the cell where you deposit the link and before erasing it, copy the needed reference from the bar of formula at the top under the ribbon of icons.

Then paste this formula in the appropriate cell.

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