launcher errors  :

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. 

Image Removed

Solution : 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. 

The Launcher fails with TYPE_E_LIBNOTREGISTERED message

Problem :With the version 2.5.2 you try to start Analysis Office by using the launcher (e.g. from the Windows start menu :Analysis for Microsoft Excel).

Excel is started but the launcher shows an error.

The log file contains the entry:

ERROR|addins.launcher|Com.Sap.Cof.Launcher.CrLauncherUtils.GetOfficeAddin|1

|System.Runtime.InteropServices.COMException (0x8002801D): Library not registered.

(Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) at Microsoft.Office.Interop.Excel._Application.get_COMAddIns()

reason : Microsoft Office 2010 (Win7) or Microsoft Office 2013 (Win10).Additionally Skype for Business 2016 is installed.

Thus :  installation of Skype for Business creates an invalid registry node that causes this error.

Solution : follow the following  excerpt of a Microsoft article about that

1. In the registry check the nodes below HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101BBDE5-00AA0044DE52}
2. For Excel 2010 there is a node "2.5", for Excel 2013 there are "2.6" and "2.7".
3. Skype for Business 2016 creates an empty node "2.8".
4. Remove the node "2.8".

Finally start the launcher of Analysis Office again.

Follow all these instructions from above only when using version of Excel (2010 or 2013)!

Message : Customization does not have the permissions required to create an application domain

Problem :With the version 2.5.2 you try to start Analysis Office by using the launcher and  you get a pop up with that message.

The result is it's  not possible to add the Analysis tool in Excel. 

To fix that issue related to the VSTO Office component  you must ask your local infrateam to add the following keys in the registry .

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VSTO Runtime Setup\v4  

"EnableVSTOLocalUNC"=dword:00000001

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VSTO Runtime Setup\v4

"EnableVSTOLocalUNC"=dword:00000001

"EnableVSTOLocalUNC"=dword:00000001

"EnableVSTOLocalUNC"=dword:00000001

Can't run BW report/query after downloading file into Excel from google drive 

Warning
title Problem
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

Image Added

Can't access to SAP Logon

Problem :

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

Image Removed

Solution :

On Platform Settings tab, select option "NetWeaver" as Preferred Plaform.
Image Removed

Image Removed

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

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

Image Removed Image Removed

Image Removed

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.

Image Removed

Solution 1:

Apply the following process

For short term, when logging

via the SSO mode :

Image Removed

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.

Image Removed

Image Removed

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 Client and Language Selection for SSO Logon"
3. Activate the option by ticking it

Image Removed

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

Image Removed

When insert Data source, get errors like "Value cannot be null" ,"Index out of range", "Item already ..., "Object reference is not an instance...

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 

Image Removed Image Removed

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.

Image Removed

Open SAPLogon
Image Removed

 Click on "Connexions" folder and its sub-folder, make sure there is a list of servers here. If there is no server list here, please contact IS Infra-structure team to install it.
 
  Image Removed

Analysis is very slow for opening file

Image Removed

Solution

The solution is SAP note 1899658 :

Image Removed

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

Image Removed

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

Image Removed

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.

Can't save workbook onto WBP server

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

Image Removed

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 ?

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.

Image Removed

The variants can not be used

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

Image Removed

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

Solution :

1/ Uncheck the "Merge Variables"

Image Removed

2/ Refresh one query at a time

Image Removed

When you open a Core Query or a document saved locally containing a unique Data Source to access the "Use Variant" functionnality within the prompt you must select the Prompts for Data Souce option.

In case you choose The Prompts for Workbook the "Use Variant " will be unabled.

To get the both options, your cursor must be in a crosstab cell, if not only the Prompts for Workbook will be available and so the variant option greyed .

Example on the left screenshot no choice (cursor cell I1), on the right one "Prompts for Data Souce option" is available and so the varaint option is ungreyed (cursor cell A1)

3/ You can now use variants

Image Removed

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.

Image Removed

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.

The limit of data cells has been set up to take into account the BW backend system limitation parameter

• • , BWP : size limit = 1 000 000 cells. 

I Get the message "No Authorization"

Problem : 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. 

In order to exclude divestments from Solvay's scope, the Authorization management process has changed : it's now necessary to select, at least, one Company and Plant

For applications WCAP and P&L, the Company PRS is mandatory too.

Solution : Be sure you select at least one Company , one Plant or one PRS code in the Prompt area, even if the field description indicates it as optionnal!

Depending to the Application rules you need to fulfill either one code (ex PRS one) or several ones (ex Company & Plant)

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

• Values to use before the update done on WBP (before Wednesday 18th July 2018) :

to remind : How to fill an interval  of autorized values in your local Workbook  :

Image Removed

---

Tip

Image RemovedAlternative :

title Solution

1. Right click on desktop, and select "Personalize".

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

1. Right click on desktop, and select "Personalize".

Problem :

Image Removed

Image Removed

Image Removed

Image Removed

Image Removed

Image Removed

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

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

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

Image Removed

Image Removed Image Removed