Error message "Single Sign On Failed. Please change client and language." when you open the file and try to refresh or enter new prompt

1. Open directly the xlsx file, and cancel all the messages and go to tab Components, and right click the file name, and choose "Replace System"
2. Choose the WBP system
3. Save the file. Then, you should be able to refresh and change prompt normally. 

 This is require only one time but it is important that the file must be saved. 

Server list is not available (Blank page). 

Add the favorite to trigger the server list in BW analysis

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

To solve this you need to reactivate the Analysis add-in which has been deactivated by the Excel application.

To avoid that we recommend when you get the following message to answer No instead of Yes

Clicking Yes button disable the add-in Analysis, No button bypass that and it's what we need.

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. 

So far, we haven't found*.

Workaround  : the user need only to open Excel application  ("Microsoft Excel 2010/13") instead of the Analysis for Microsoft Excel one.

After Excel is opened, Analysis add-in is enabled  and so available too. 

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

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

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

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

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

The folder/query/labels names look as below

Apply the following process

SAP BW User : Language

For short term, when logging change the language to EN as shown.

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 Client and Language Selection for SSO Logon"
3. Activate the option by ticking it
4. Press "OK", close eXcel, restart Analysis.  you can select the "EN" language via the following popup >>

In case of the following messages :

Value cannot be null, Index out of range, An Item with the same Key has already been added, Object reference is not an instance of an object 

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 (see process herebelow).

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.

If that process doesn't solve the issue, need to ask for Infradesk local team for a reinstallation of the SAP Analysis tool

Rootcause is the cache on the PC is damage somehow.

Delete all the file under folder C:\Users\<user ID>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\cache  (SAP  Note 2436298)

One of the reason is that program error in Excel and it causes excel creating a lot of custom styles. Analysis will try to read them all before opening the file, which may cause more than 10 minutes to open the file

The solution is SAP note 1899658

1. Open the problem file
2. Goto source code 

3. Copy the coding below and run following macro to delete the custom styles

   Sub DeleteStyles()
     Dim style As style
     Dim counter As Long
     counter = 0
     For Each style In ActiveWorkbook.Styles
       If style.BuiltIn = False Then
         style.Locked = False
         style.Delete
         counter = counter + 1
       End If
    Next
     MsgBox (counter & " styles were deleted.")
   End Sub

4. After run the marco (may spend a few minutes depending on how many styles in the file), it will show result like this

5. Delete the macro and save the file as .xlsx the same. If macro is not deleted, it may be force to save as .xlsm

Note: the standard program is also available but the problem sometime Solvay network is not allow to download .EXE file.

Users can't save a workbook onto the WBP server (My documents or role folder)

Message is due to the fact that No permission has been granted to any user onto either the BW production server WBP or BW Quality one WBQ

To save a personal document  you need to use the Save or Save As Windows options

Why there is no data after I save the workbook ?

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.

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

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 refreshing a query, it's not possible to use, modify or save a variant

The option "Merge variable" is selected on the Analysis Design Panel (components tab), so you need to deselect that option to enable the variants.

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.

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.

The limit of data cells has been set up to take into account the BW backend system limitation parameter. Size limit = 1 000 000 cells. 

You get that error message when you try to refresh a query/workbook because you do not have the correct authorization to execute the query or to select this perimeter. 

You are trying to access an entity to which you do not have access. It is recommended to narrow your selection to one Company , one Plant or one PRS code in the Prompt area, even if the field description indicates it as optional.

If you need to access all Companies or Plants, fill the prompt with an authorization scope = SOLVAY & # (from 01 Jul 2023 the Aurhorization scope SOLVAY is replaced by ECO & SCO)

As a Solvay employee, you can only see the data of legal entities included in the authorization scope = SOLVAY (ECO & SCO from 01 Jul 2023).

When a legal entity is sold, it is excluded from the authorization scope = SOLVAY and included in a new authorization scope for instance: 

• ACETOW
• BUTACHIMIE
• DAIKIN
• ECOSERVICE
• INDUPA
• LANXESS
• SPARROW
• VINYTHAI
• ...

When downloading into Excel a BW report/query file from Drive, is not possible to run “Analysis”  --->  the Prompts  icon is  “gray out” and a new tab appears in the file named “_com.sap.ip.bi.xl.hiddensheet” Image Added

The BW report file has to be loaded into Drive in Office format to avoid having BW issues when downloading.

When you do "Filter by Member", you can't select from a list.

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

So open the Settings and look at the  "Maximum Number of Members Displayed in Filter Dialog" 

Change the Maximum if it's too small. 

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

Choose "Paste from Clipboard".

Unable to maximize the width of the windows.

Open the Windows Control Panel, then navigate: Appearance and Personalization > Display.

There is a red cross in the frame "Columns" or "Row"

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

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

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

You want to duplicate your existing query to filter the new one in an other way (ex a different  perimeter, a different lay out).

You have duplicated the eXcel sheet to get a new sheet, but you are unable to refresh the new one (query).

By using the eXcel sheets Duplication functionality you only copy/paste Data but none BW links. 

So you can't refresh the copied crosstab. 

1. Go to the  Components tab within the Analysis Panel 
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.

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.

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

Untick the « Analysis Toolpak and the Analysis Toolpak-VBA

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

Uncheck "Add-Ins"

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

There’s a glitch in Excel 2010 and 2007 (fixed in Excel 2013) that can be the source of the problem

Are you affected ? 

Open your Excel Files, go to the

1. Home Ribbon 
2. Click on the drop down Image Addedfor Cell Styles.

If you have hundreds of weirdly named styles as shown in the illustration then it's indicative of problems to come. 

To restore cell styles to the default setting you need to ask someone in the IS team to run the program XLcleanerDotNET4.0.exe and follow the procedure.

In case, you can't download .EXE file, you may do it manually by this solution

When opening Microsoft Word you get the error message >>

To fix locally the trouble, you need to open The Word Options tab

Root cause is Analysis version 2.1 is not support.  How to check Analysis version 

Solution You need to ask your local helpdesk infrastructure team  to install Analysis 2.5 or higher, which is in SAP GUI 7.5 package