## 6.2.1  Analysis Settings
Analysis Settings
| Setting and Setting Value          | Setting Description                                                                                                                                                                                                                                                                                                                                           | Available for    |
|------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| AbapTrace = 1 or 0 (default value) | You use this setting to activate the trace tool environment of SAP BW. The default value is 0 , meaning that it is deactivated. With a value of 1 , you can activate this setting. You can also activate the setting in the Support Settings dialog with setting Enable BWServer Tracing . For more information, see Trouble­ shooting in Analysis [page 331]. | Analysis plug-in |
| Setting and Setting Value                                                  | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                    | Available for    |
|----------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ActivateFormulaRecognition OnExistingCells = true (default value) or false | You use this setting to specify whether formulas in input-enabled cells are saved as table design formulas. The default value is True . This means that the formulas added to input-ena­ bled cells are saved as table design for­ mulas. They are added to the formula section on the design rules tab in the design panel and can be changed there. If you change the value to False , the formulas are not saved in the design panel. | Analysis plug-in |
| AllowChangingAccessMode = true or false (default value)                    | You use this setting to specify whether the access mode for member display should be enabled. After installation, the default value is False . This means that the access mode is not enabled for the member display definition in the crosstab and for the Filter by Member dialog box. If you change the parameter value to True , the access mode option is dis­ played in the menu.                                                 | Analysis plug-in |
| Setting and Setting Value                                                                    | Setting Description                                                                                                                                                                                                                                                                                                                                                                        | Available for    |
|----------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| AllowInsecureConnections = Yes , No , NoInsecure , Prompt (de­ fault value) or PromptInsecure | You use this setting to specify which op­ tions should be available in Analysis if a connection isn't secure. The setting also checks if a connection isn't reach­ able (timeout exceptions, proxy issues, 404 http status code) or undefined (un­ authorized or other exceptions). A dia­ log could be displayed to decide to con­ tinue with an insecure connection or cancel the connection. | Analysis plug-in |
| Setting and Setting Value                                                   | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Available for    |
|-----------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| AllowLeavesViewInHierarchicalSelec­ tor= true (default value) or false       | Changing the display mode from hier­ archy to leaves can take a very long time depending on the number of lev­ els and leaves the hierarchy contains. Therefore you can use this setting to specify whether the leaves view should be enabled for hierarchies in the filter and prompts dialog. The default value is True . This means that the leaves view is enabled. If you change the parameter value to False , the leaves view will be disabled.                     | Analysis plug-in |
| AllowLiteralMemberForNodes InHana = true or false (default value)           | You open a workbook containing a HANAdata source that has a dimension filtered on hierarchy elements. You ob­ serve a high amount of HTTP calls to HANAfor retrieving the members of the hierarchy. You use this setting to specify whether the number of calls should be reduced. The default value is False . This means that the number of calls is not reduced. If you set the parameter value to True ,                                                              | Analysis plug-in |
| AllowLiteralMemberSelectionsInVaria­ blesHana= true (default value) or false | You use this setting to specify whether the values you enter for a variable, are validated against the HANAsystem or not. The default value is True . This means that the values are not validated against the HANAsystem, but Analysis still checks if the format and data type are correct. Not validating the values may improve the performance in Analysis. If you set the parameter value to False , Analysis validates the entered values against the HANAsystem. | Analysis plug-in |

| Setting and Setting Value                                                          | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Available for    |
|------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| AllowOverwritingOfDimensionNames= true (default value) or (default value) or false | You use this setting to specify whether users are allowed to overwrite and change the name of dimensions in the property view in the design panel. The default value is True . This means that users can overwrite the name of dimensions. If you change the parameter value to False , users can no longer overwrite dimension names in the property view.                                                                                                                                                                                 | Analysis plug-in |
| AllowOverwritingOfStrutureMember­ Names= true (default value) or false              | You use this setting to specify whether users are allowed to overwrite and change the name of structure members in the property view in the design panel. Structure members are single meas­ ures and attributes. The default value is True . This means that users can overwrite the name of members. If you change the parameter value to False , users can no longer overwrite                                                                                                                                                            | Analysis plug-in |
| AlwaysCallSheetIdUsingXlIn tl = true or false (default value)                      | This setting is only relevant if you use a Microsoft Office version below Office 365 version 2101. You use this setting to specify that an active Analysis won't cause any display errors in Excel when you work with VBA to create a new workbook and change the list separators. After installation, the default value is False . This means that the changes for the list separators aren't adapted. If you change the parameter value to True , the changed list separators are displayed correctly. For more information, see SAP Note | Analysis plug-in |
| Setting and Setting Value                                                                     | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Available for         |
|-----------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| AlwaysDoApplicationSteps = true or false (default value)                                      | You use this setting to specify when the statistics are written in table RSDDSTAT_OLAP. The default value is False . This means that the statistics are written when Analysis closed. If Analysis is termi­ nated unexpectedly, e.g. by time out on a citrix server, the entries are never written to RSDDSTAT_OLAP. If you change the parameter value to True , the entries are written after each action executed in Analysis without the need to close Analysis. Note that this might have a negative impact on the performance. | Analysis plug-in      |
| AoTenantSite = "" (default value)                                                             | This setting is used for Usage Tracking. After installation, the default value is "" . Werecommend not changing the value. You can deactivate Usage Tracking for Analysis with setting TrackUsage .                                                                                                                                                                                                                                                                                                                                | Analysis plug-in      |
| AppBuilderCompanyProfileDi rectory = "C:\ProgramData\SAP\Cof\Us er Interface" (default value) | You use this setting to specify the path to the directory which contains the company profiles. The default value is C:\ProgramData\SAP\Cof\Use r Interface . The company profiles are owned by an administrator. The current user is not the owner of these profiles and he won't be able to modify them. This setting can only be maintained by an administrator in the file system un­ der C:\ProgramData\SAP\Cof .                                                                                                               | Analysis add-in (COF) |
| Setting and Setting Value                                                                  | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Available for         |
|--------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| AppBuilderDefaultInterface Area = "" (default value), ContextMenu , Backstage or SidePanel | You use this setting to specify which user interface area is selected when you open the Customer User Interface dia­ log. After the installation, the default value is empty (""). This means that the user interface area Ribbon is selected when you open the dialog. You can enter ContextMenu to en­ able the user interface area Context Menu when you open the dialog, Backstage to enable the user inter­ face area File Menu, and SidePanel to enable the user interface area Side­ Panel View. Note that when you close the dialog, the currently active user interface area is saved as value in the setting. There­ fore, the next time you open the dialog again, the same interface area is ena­ bled. | Analysis add-in (COF) |
| AppBuilderDefaultProfilePa th = "" (default value)                                         | You use this setting to specify the path to the default profile that will be applied when Microsoft Excel is started. The path is set automatically as soon as a user defines a profile in the Customize User Interface dialog and then selects the Default Profile button.                                                                                                                                                                                                                                                                                                                                                                                                                                   | Analysis add-in (COF) |
| Setting and Setting Value                                      | Setting Description                                                                                                                                                                                                                                                                                                                                                                                    | Available for         |
|----------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| AppBuilderExcelDefaultComp anyProfilePath = "" (default value) | You use this setting to specify the path to the company profile for Microsoft Ex­ cel. After the installation no path is defined. Therefore the default value is empty (""). As an administrator, you can enter the path to the default company profile and provide it to your end-users.                                                                                                               | Analysis add-in (COF) |
| AppBuilderPptDefaultCompan yProfilePath = "" (default value)   | You use this setting to specify the path to the company profile for Microsoft PowerPoint. After the installation no path is defined. Therefore the default value is empty (""). As an administrator, you can enter the path to the default company profile and provide it to your end-users.                                                                                                           | Analysis add-in (COF) |
| AppBuilderPptDefaultProfil ePath = "" (default value)          | You use this setting to specify the path to the default profile that will be applied when Microsoft PowerPoint is started. The path is set automatically as soon as a user defines a profile in the Customize User Interface dialog and then selects the Default Profile button. After the installation no path is defined. Therefore the default value is empty (""). Wedonot recommend to change the | Analysis add-in (COF) |
| Setting and Setting Value                             | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Available for         |
|-------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| AppBuilderReadOnlyProfileD irectories = "path1;path2" | You use this setting to specify a direc­ tory or a list of directories where users can share profiles without having to make a copy. You can enter a single path to a direc­ tory or paths to several directories. The paths should then be entered with a semicolon-separated list. The current user is not the owner of these profiles and he won't be able to modify them.                                                                                                                                                                                                                                                 | Analysis add-in (COF) |
| AppBuilderUserProfileDirec tory = "" (default value)  | You use this setting to specify the path to the directory which contains the cur­ rent user profiles. The current user is the owner of these profiles and can modify them. Each time, the user creates a new profile in the Customize User Interface dialog, it will be stored in this directory. After the installation no directory is defined. Therefore the default value is empty (""). As soon as a user saves the first profile, the path to the directory is set automat­ ically- The path will be something like: C:\Users\<userID>\AppData\ Roaming\SAP\Cof\User Interface . A user can change the path manually to | Analysis add-in (COF) |
| AppBuilderWindowHeight = -1 (default value)           | You use this setting to define the height of the Customize User Interface dialog. The default value is -1 points. The value is automatically adapted if a user re­ sizes the height of the dialog manually in the application.                                                                                                                                                                                                                                                                                                                                                                                               | Analysis add-in (COF) |
| Setting and Setting Value                                               | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Available for         |
|-------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| AppBuilderWindowWidth = 900 (default value)                             | You use this setting to define the width of the Customize User Interface dialog. The default value is 900 points. The value is automatically adapted if a user resizes the width of the dialog manually in the application.                                                                                                                                                                                                                                                                                      | Analysis add-in (COF) |
| AutoCompleteFetchMemberLim it = 30 (default value) or any integer value | You can use an autocomplete input help for entering members in cells of new lines for planning. To use this help, en­ ter a string in the cell, for example the first letters of a member, then press Ctrl+Space. A dialog is opened contain­ ing all members matching the string. With this setting, you can define a limit for the number of members available as input help. The default value is 30 . This means that up to 30 members are offered in the input help. You can enter any integer value for this | Analysis plug-in      |
| Setting and Setting Value                                           | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Available for    |
|---------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| AutoConnectToLastSelectedS acSystem = true or false (default value) | This setting is relevant when working with Analysis, edition for SAP Analytics Cloud. In the Connect to SAC dialog, you can select to option Remember mydecision and use this connection from now on . The next time you start to insert a data source, you'll be automatically connected to the current SAP Analyt­ ics Cloud tenant without seeing the Connect to SAC dialog again. The default value is False . This means that you get the Connect to SAC dia­ log whenever you start to insert a data source. If you select to option Remembermy decision and use this connection from now on in the dialog or set this set­ ting to True , you're automatically con­ nected to the last selected SAP Ana­ lytics Cloud tenant without seeing the Connect to SAC dialog again. If you want to get the dialog again, you need to set the value for this setting to False . | Analysis plug-in |
| BexAdvancedMode = true or false (default value)                     | You use this setting to specify whether the 'Use Currency Translation from Query Definition' checkbox should be available in the currency translation dia­ log for measures. After installation, the default value is False . This means that the checkbox is not available. If you change the parameter value to True , the checkbox is displayed in the dialog.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Analysis plug-in |
| Setting and Setting Value                                                                          | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Available for    |
|----------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| BicsNewLineFillInitial = true (default value) or false                                             | You use settings to define how Analy­ sis handles empty cells in new linesthat are used for planning with new member combinations. The default value is True . This means that Analysis tries to derive missing member values. If a member value can­ not be derived, Analysis fills in Not As­ signed (Key: #). If you change the value to False , this behavior is stopped and Analysis does not try to derive missing member val­ ues. For more information on related SAP BWparameters, see SAP Note2508938 .                                                           | Analysis plug-in |
| BipSequentialDataTransferB ufferSize = 262144 bytes (default value) or any integer value for bytes | You use this setting to specify the num­ ber of bytes used for the UploadFile web service call when saving a work­ book on the BI platform. The default value is 262144 bytes per call. When working with larger workbooks, increasing the number of bytes per call could improve the performance, for ex­ ample, a value of 524288 bytes per call. If you change the value for this setting, you need to change accordingly the maximumChunkSize for the BI plat­ form at <InstallDir>\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\dswsb obje\WEB-INF\classes . | Analysis plug-in |
| Setting and Setting Value                                        | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Available for    |
|------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| BOESessionRefreshTime = -1 (default value) or any integer value. | You use this setting to specify the time in seconds Analysis is waiting to make a dummyHttp request to keep the BI platform session active. The default value is -1 . This means that the time taken is the session time out retrieved from the BI platform mi­ nus one minute: Analysis will send the dummyHttp request to the BI platform before the timeout value so that Analy­ sis remains active. You can enter any integer value for this setting to define the time for Analysis. | Analysis plug-in |
| BOESystems                                                       | This setting contains the configuration to the Business Intelligence Platform. For more information, see .                                                                                                                                                                                                                                                                                                                                                                              | Analysis plug-in |
| Setting and Setting Value                                         | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for    |
|-------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| CancelPopupDelay = 5 seconds (default value) or any integer value | You use this setting to specify after how many seconds the cancel dialog should be displayed when a data update is requested from the server (BW and HANA) and the crosstab is redrawn. This could be inserting a data source or navigating through the data, for exam­ ple filtering data or adding dimensions to the crosstab. The default value is 5 seconds. This means that the cancel dialog will ap­ pear after 5 seconds. You can enter any integer value for this setting. If the cancel dialog (Fetching data from server) is displayed, you have two op­ tions: • You press Cancel to cancel the server request. In the following Messages dialog, you can select Restart to go back to the workbook and refresh all the data sources in the workbook. Or you select Close to go back to the workbook and the data sources in the workbook are disconnected. Note that the refresh of all data sources that is started automati­ cally with the option Restart could take very long. • You do not cancel the server re­ quest. The dialog will disappear automat­ ically when the server request is completed. | Analysis plug-in |

| Setting and Setting Value                                                      | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                        | Available for         |
|--------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| CanCustomizeUserInterface = true (default value) or false                      | You use this setting to specify whether users are authorized to customize the user interface and define their own pro­ files. After installation, the default value is True . This means that are authorized to customize the user interface. If you change the parameter value to False , are no longer able to customize the user interface.                                                                              | Analysis add-in (COF) |
| ChangeNumberFormatToTextFo rFilterComponent = true or false (default value)    | You use this setting to specify whether Analysis should apply the cell format Text initially to cells defined on time-re­ lated dimensions with the SapSetFilter­ Component formula. After installation, the default value is False . This means that the cell format Text won't be applied. If you change the parameter value to True , the cell format Text will be ap­ plied. For more information, see SAP Note 2829371 . | Analysis plug-in      |
| CheckIfWorkbookIsInplaceWh enWindowIsActivated = true (default value) or false | This setting might only be relevant if you use the add-in with Microsoft Excel 2010 and at least two workbooks are used at the same time. Please see SAP Note 2463180 for more information.                                                                                                                                                                                                                                | Analysis plug-in      |
| Setting and Setting Value                                    | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Available for         |
|--------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| CheckInfoAreasAuthorizatio n = true or false (default value) | In BWsystems, you can define with au­ thorization object S_RS_FOLD if InfoAr­ eas should be displayed in dialogs of the BEx tools. If it is defined inaBW system that the InfoAreas are not dis­ played, they are still displayed in the Analysis Open Data Source dialog. You use this setting to specify whether the areas should be displayed in Analy­ sis. The default value is False . This means that the areas are displayed in Analysis. If you change the parameter value to True , the areas are no longer displayed in the Analysis Open Data Source dialog. | Analysis plug-in      |
| ClientLanguage = EN or any Analy­ sis language value          | You use this setting to specify the lan­ guage for all Analysis UI texts. The default value is EN. This means that the UI texts will be displayed in English. You can enter any Analysis language value for this setting. For more information on available lan­ guages and their values, please see Supported Languages [page 331]. Note that the setting Determi­ neClientLanguageFromOfficeLanguage overrules this setting as long as it has                                                                                                                         | Analysis add-in (COF) |
| ClientProfiling = true or false (default value)              | You use this setting to activate client profiling. After installation, the default value is False . With a value of True , you can activate this setting. You can also activate the setting in the Support Settings dialog with setting Enable Client Profiling . For more information, see Trouble­ shooting in Analysis [page 331].                                                                                                                                                                                                                                 | Analysis add-in (COF) |
| Setting and Setting Value                                    | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Available for         |
|--------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| ColumnsOfData = 12 (default value)                           | You use this setting to define the default number of columns. After installation, the default value is 12 .                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Analysis plug-in      |
| ContinousUsageDataUploadIn tervalInDays = 20 (default value) | This setting is used for Usage Tracking. After installation, the default value is 20 . Werecommend not changing the value. You can deactivate Usage Tracking for Analysis with setting TrackUsage .                                                                                                                                                                                                                                                                                                                                                                     | Analysis plug-in      |
| ConversionType = 0 (default value), 1 or 2                   | You use this setting to define which objects of a BEx workbook should be converted. The default value for this parameter is 0 . This means that all ob­ jects are converted. If you set the parameter value to 1 , data sources and crosstabs are converted. If you set the value to 2 , only data sour­ ces are converted.                                                                                                                                                                                                                                               | Analysis plug-in      |
| CpicTraceLevel = 0 (default value), 1 , 2 or 3               | This setting can be used for SAP error handling. CommonProgramming Inter­ face - Communication (CPIC) is the communication layer under JRFC (or JCo). You use this setting to specify the de­ sired level for tracing. The default value is 0 . This means no tracing takes place. You can change the parameter value to 1 , 2 or 3 , where 3 is the highest and most detailed level of tracing. If you now work with Analysis, log files will be created in the%temp% folder of windows. There you can find a nco_cpic_XXX.trc file that you can at­ tach to the message. | Analysis add-in (COF) |
| Setting and Setting Value                                     | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Available for         |
|---------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| CurrentCodePage = Encoding for the system's current code page | In some cases, the Open dialog shows system entries with unreadable charac­ ters when using saplogon.ini. This can be caused by the fact that the encoding of the saplogon.ini content is different from Windows default encoding. You use this setting to overrule the de­ fault code page by applying the appro­ priate code page number here.                                                                                                                                                                                                               | Analysis add-in (COF) |
| CurrentCodePage = Encoding for the system's current code page | In some cases, the Open dialog shows system entries with unreadable charac­ ters when using saplogon.ini. This can be caused by the fact that the encoding of the saplogon.ini content is different from Windows default encoding. You use this setting to overrule the de­ fault code page by applying the appro­ priate code page number here.                                                                                                                                                                                                               | Analysis plug-in      |
| DefaultBWQueryDesigner = 0 (default value) or 1               | You can access the BEx Query Designer or the BWModeling Tools directly from Analysis with the ribbon option Launch Query Designer . If both designers are available, you can open a drop down list to select one. You use this setting to specify which de­ signer is opened if the Launch Query Designer option is selected in the rib­ bon without opening the drop down list. After installation, the default value is 0 . This Launch Query Designer is selected directly. If you change the parameter value to 1 , the BEx Query Designer will be opened | Analysis plug-in      |
| Setting and Setting Value                                    | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Available for    |
|--------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| DefaultConnectionLimit = 10 or any integer value             | You use a workbook with several SAP HANAdata sources. When refreshing the workbook, a thread is created for each data source for retrieving the re­ sult set via HTTP (Note that the num­ ber of parallel threads might be limited by the Analysis setting MaxNumberOf­ ParallelThreads). Due to a limitation in the underlying .net framework, the SAP HANAserver gets at most two HTTP requests in parallel. You use this setting to overwrite the .net default value and specify The default value is 10. This means that Analysis can get up to 10 HTTP requests in parallel. You can enter any integer value for this setting. | Analysis plug-in |
| DefaultLauncherScheme = "" (default value) or https          | When logged on to BI Launchpad us­ ing HTTPS and trying to view an Analy­ sis workbook or presentation, an error message "Failed to launch with speci­ fied file!" is displayed. You can implement a BI platform with version 4.1 SP03 (or higher) or 4.1 Patch 2.2 (or higher) to solve the issue. Alternatively, you can also set this set­ ting to value https . All viewed Analy­ sis workbooks/presentations will then launch via HTTPS. Thus remove this registry value as soon as you have im­ plemented one of the requested BI plat­ form versions.                                                                            | Analysis plug-in |
| DefaultWorkbookPath = path to default workbook in directory. | You use this setting to define the path to the default workbook in the directory.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Analysis plug-in |
| Setting and Setting Value                                                  | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Available for         |
|----------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| DetermineClientLanguageFro mOfficeLanguage = true (default value) or false | You use this setting to specify whether the Microsoft Office language should determine the language for Analysis. This setting overrules the setting Clien­ tLanguage. The default value is True . This means that the Microsoft Office language de­ termines the language used for Analy­ sis. If you enter a different language value for the setting ClientLanguage, the Analysis texts are still displayed in your selected Microsoft Office lan­ guage. If you change the parameter value to FALSE , the Microsoft Office language no longer determines the language used for Analysis texts. If you enter a different language value for the setting ClientLanguage, the Analysis texts are displayed in the language specified in setting ClientLanguage. | Analysis add-in (COF) |
| DisableBWDirectSearch = true or false (default value)                      | You use this setting to specify whether the direct search or the classic search should be used for searching data sour­ ces in BWsystems. The direct search is faster but could lead to incomplete results in rare cases. In this case, we recommend switching to the classic search. To help us im­ nprove the direct search, please create an incident in the SAP Support Portal if you need to switch to classic search. After installation, the default value is False . This means that Analysis uses the direct search for BWdata sources. If you change the parameter value to True , the classic search will be used.                                                                                                                                  | Analysis plug-in      |
| Setting and Setting Value                             | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Available for    |
|-------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| DisplayCompoundAsKeys = true or false (default value) | You use this setting to define the dis­ play of variables in the summary view of the prompting dialog box. The default value is False . This means that the variables are displayed as dis­ play strings. For compound characteristics, the dis­ play string may not be unique. To dis­ play compound characteristics with the key instead of the display string, you can set the parameter value to True .                                                                                                                                                                                                                                        | Analysis plug-in |
| DocumentCacheFolderPath = "" (default value)          | You use this setting to overwrite the de­ fault cache directory path. Analysis workbooks are saved to the di­ rectory sapaocache which is located beneath the users Temp directory. It is not possible to add the specific workbooks path to Excel's Trusted Location section. This is due to the fact that Microsoft does not allow add­ ing paths to Trusted Location which points to a directory beneath the users Temp directory whenever work­ ing with MSOffice 2010 or higher. If you want to overwrite the default cache directory path, you can enter a path here. Note that the path must not be set to a OneDrive or SharePoint folder. | Analysis plug-in |
| Setting and Setting Value                                              | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Available for         |
|------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| DoSelectorHierarchyExplici tSelection = true or false (de­ fault value) | You use this setting to specify the be­ havior of the Filter By Member dialog for hierarchies. For hierarchies, the se­ lection of a node means also the selec­ tion of its children in the filter dialog box. And vice versa, the selection of all children means also the section of the corresponding node. This is the behavior for the default value False . If you change the value to True, the hier­ archy selection behaves different. The selection of a node still means the se­ lection of its children. But you can se­ lect all children without having selected automatically the corresponding node. If new children are available in the hier­ archy, they are not selected automati­ cally as long as the node is not selected. | Analysis plug-in      |
| DPPPopup_enforce = 1 (default value) or any integer value              | You use this setting to specify whether the data protection and privacy pop-up should be displayed when Analysis is started. The data protection pop-up will be displayed when starting Analysis as long as the value for this setting is higher than the value for setting DPPPopup_shown . Therefore, you can also re-enforce that the pop-up is displayed with setting the value for this setting to a higher value than DPPPopup_shown . 1 . This means that the pop-up will be displayed as the default value for DPPPopup_shown is 0 .                                                                                                                                                                                              | Analysis add-in (COF) |
| Setting and Setting Value                               | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Available for         |
|---------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| DPPPopup_shown = 0 (default value) or any integer value | You use this setting to specify whether the data protection and privacy pop-up should be displayed again when Analy­ sis is started. The data protection pop-up will be displayed again when starting Analy­ sis as long as the value for this set­ ting is lower than the value for set­ ting DPPPopup_enforce . Therefore, you can also re-enforce that the pop- up is displayed with setting the value for this setting to a lower value than DPPPopup_enforce . The default value isThe default value is 0 . This means that the pop-up will be displayed as the default value for DPPPopup_enforce is 1 . If you select the check box Do not show | Analysis add-in (COF) |
| Setting and Setting Value                                        | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Available for    |
|------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnableAdvancedFormulaRefer ences = true or false (default value) | Please note that this setting is currently not for productive use. Werecommend enabling it only for tests. You use this setting to specify that cell references that are referenced by formulas used in the crosstab can be located on other sheets of the same workbook. The standard behavior in Analysis is that the crosstab and the referenced cells must be on the same sheet of the workbook. The default value is False . This means that the referenced cell must be located on the same sheet as the crosstab. If you change the value to True , the crosstab and the referenced cells can be located on different sheets. The ref­ erenced cells can contain values and formulas. For example, your crosstab is on Sheet1 and you enter the values on Sheet2. Then you can reference the cells from Sheet2 in your crosstab on Sheet1. Please check the current limitations: • The referenced cells can be located on different sheets, but the cross­ tab and the referenced cells must be in the same workbook. • The referenced cell you use in your crosstab must not contain referen­ ces to other cells. For example, your crosstab is on Sheet1 and you reference cells from Sheet2 in your crosstab. Then, the cells on Sheet2 must not reference other cells. If you would like to provide feedback on this new feature, please open an inci­ dent in the SAP Support Portal. | Analysis plug-in |
| Setting and Setting Value                                     | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Available for    |
|---------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnableAnalysisViewConversi on = true or false (default value) | You use this setting to define whether the Conversion tab with the Analysis View Migration setting in the settings dialog is displayed. After installation, the default value is False . Nethertheless, the conversion tab with the Analysis View Migration is visible as long as the setting EnableWorkbookConversion is set to true . If you change the parameter value to True , the Conversion tab is ena­ bled and the Analysis View Migration is available even if the setting EnableWorkbookConversion is set to false . | Analysis plug-in |
| EnableDoubleClick = true (de­ fault value) or false            | You use this setting to specify whether filtering a member with a double click should be enabled. After installation, the default value is True . This means you can filter for one member with a double click on the member cell. If you change the parameter value to False , the function is disabled.                                                                                                                                                                                                                      | Analysis plug-in |
| Setting and Setting Value                                          | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Available for         |
|--------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| EnableImprovedAddInCompati bility = true or false (default value)  | If you use different Microsoft Office add-ins at the same time, you might en­ counter Microsoft Office crashes. The reason for this is that many of the add- ins use the Window Procedure Sub­ classing technique. You can improve the compatibility with other add-ins with this setting. It reduces the subclassing in Analysis. Note that you cannot use drag and drop to add or delete a filter in the crosstab when the setting is active. The default value is false . This means that the subclassing is not reduced and you can use drag and drop in the cross­ tab. If you change the parameter value to True , the subclassing is reduced to im­ prove the compatibility with other add- ins. As a consequence, you cannot use drag and drop in the crosstab. For more information, see SAP Note 2750514 | Analysis plug-in      |
| EnableIncludesInSapUiLands capeXml = True or False (default value) | You use this setting to specify whether includes in SapUiLandscape.xml files are loaded and parsed. The default value is False . This means that includes in SapUiLandscape.xml files are not loaded and parsed. If you change the parameter value to True , includes in SapUiLandscape.xml files will be loaded and parsed. Note that setting this setting to true may have a negative performance im­ pact since includes from remote loca­ tions will be loaded. Please be aware that nested includes (for example, includes in an included file) are not supported.                                                                                                                                                                                                                                          | Analysis add-in (COF) |
| Setting and Setting Value                                          | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Available for    |
|--------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnableMassDataSelector = true (default value) or false             | You use this setting to specify whether the filter dialog box for mass data should be enabled. After installation, the default value is True . This means that the filter dialog box for mass data is opened if the max­ imum number of members defined in the User settings is reached. If you change the parameter value to False , the function is disabled and the filter dialog box for mass data is not opened.                                                                 | Analysis plug-in |
| EnableNativeFormatting = true or false (default value)             | Analysis renders date, date time and time span values with format Text . It does not use the native Microsoft Excel fomats Date and Time . You use this setting to enable native Mi­ crosoft Excel formats for rendering in Analysis. The default value is False . This means that native Excel formats are not used for rendering.. If you change the value to True , Anal­ ysis renders date, date time and time span values as native Microsoft Exel                                | Analysis plug-in |
| EnableNodeTextClickInFilte rDialog = true (default value) or false | In the filter dialog in Analysis, you can select a member by clicking the check­ box or the text next to the checkbox. You use this setting to specify whether selecting a member with a click on the text should be enabled. After installation, the default value is True . This means that you can select a member by clicking the checkbox and the text next to the checkbox. If you change the parameter value to False , you can only select a member by clicking the checkbox. | Analysis plug-in |
| Setting and Setting Value                                       | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Available for    |
|-----------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnablePreferredDocumentSto rage = true (default value) or false | You use this setting to specify whether a user should be enabled to select a preferred comments storage in the platform options dialog box. After installation, the default value is True . This means that the Comments Storage section is visible in the plat­ form options dialog box and that the user can change the selection. If you change the parameter value to False , this section is hidden in the platform options dialog box, and the user cannot change the pre­ ferred comments storage. The user is therefore unable to change the comments storage defined in setting PreferredDocumentStorage . | Analysis plug-in |
| EnablePreferredPlatform = true (default value) or false         | You use this setting to specify whether a user should be enabled to select a preferred platform in the platform set­ tings dialog box. After installation, the default value is True . This means that the preferred platform section is visible in the plat­ form settings dialog box and that the user can change the selection. If you change the parameter value to False , this section is hidden in the platform settings dialog box, and the user cannot change the preferred plat­ form. The user is therefore unable to change the preferred platform defined in the Preferred Platform setting.            | Analysis plug-in |
| Setting and Setting Value                             | Setting Description                                                                                                                                                                                                                                                                                                                                     | Available for    |
|-------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnableResetDataSource = true (default value) or false | This setting is used in Analysis with mi­ nor versions ≤ 3 to specify whether the Launch Query Designer icon should be displayed in the ribbon. As of release 2.4, you customize the rib­ bon with the Customize User Interface dialog. Therefore, we recommend to use the Customize User Interface dialog to define the options displayed in the ribbon. | Analysis plug-in |
| Setting and Setting Value                                 | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Available for    |
|-----------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnableWarningForFailedSnc = true (default value) or false | If Analysis can't establish a secure con­ nection (SNC) to the selected BWsys­ tem, a dialog could be displayed where you can choose if you want to • Try again with SNCto establish a secure connection • Try without SNCto establish an in­ secure connection • Cancel without establishing a con­ nection Note that the setting AllowInsecureConnections in­ fluences the options in this dialog. If this setting is set to Yes or Prompt , the option Try without SNCwill be ena­ bled. If it is set to No , the option Try without SNCwill be disabled. You use this setting to specify whether the dialog that a secure connection couldn't be established should be dis­ played. The default value is True . This means that the dialog will be displayed. If you change the parameter value to False , the dialog won't be displayed and Analysis tries to es­ tablish an insecure connection au­ tomatically, even if the setting AllowInsecureConnections is set to No . Note that this setting can only be maintained by an administrator in the file system under C:\Program­ Data\SAP\Cof. | Analysis plug-in |
| Setting and Setting Value                                | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Available for    |
|----------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnableWorkbookConversion = true (default value) or false | You use this setting to define whether the conversion of BEx workbooks is en­ abled. The settings for the BEx work­ books conversion are available on the Conversion tab in the settings dialog. After installation, the default value is True . This means that conversion tab with the conversion settings and the menu entry for conversion are visible in Analysis. If you change the parameter value to False , the menu entry and conversion tab are hidden, and the user is not able to convert BEx workbooks. If you enable the setting EnableAnalysisViewConversi on , the conversion tab with the conver­ sion settings is visible in Analysis, but the menu entry for BEx workbook con­ version is hidden. | Analysis plug-in |
| EnableWorkspaces = true (default value) or false         | You use this setting to define whether the workspace options should be ena­ bled. After installation, the default value is True . This means that the workspace options are enabled and the menu en­ tries are visible in the ribbon. If you change the parameter value to False , the menu entries are not dis­ played in the ribbon, and the user is not able to use the workspace options.                                                                                                                                                                                                                                                                                                                        | Analysis plug-in |
| Setting and Setting Value                                                | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Available for    |
|--------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| EnforceDatePickerForCalend arDayVariable = true or false (default value) | You use this setting to specify whether the date picker for any variable of value type calendar / day should be enabled. After installation, the default value is False . This means that the date picker is not enabled and the dates are displayed in a flat list. Dates that are displayed in a flat list, are fetched from back-end and validated in Analysis. This could take longer than using the date picker. If you change the parameter value to True , the date picker is enabled. It is shown directly without fetching the date values from back-end. A validation does not take place and it is assumed that the selected date is valid. | Analysis plug-in |
| FailedPingCounter = 0 (default value)                                    | This setting is used for Usage Tracking. After installation, the default value is 0 . Werecommend not changing the value. You can deactivate Usage Tracking for Analysis with setting TrackUsage .                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Analysis plug-in |
| FetchMemberLimit = 1000 (default value) or any integer value             | You use this setting to define the max­ imum number of members displayed in the Filter by Member dialog box for selection. If you filter on a dimension that contains more members than de­ fined here, you only see the currently selected members (but you can search for all members). The default value is 1000 . This means that up to 1000 members will be dis­ played. You can enter any integer value for this setting. You can also define the maximum num­ ber of members in the user settings in                                                                                                                                                | Analysis plug-in |
| Setting and Setting Value                                  | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                             | Available for    |
|------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ForceFullyCompoundedKeys = true or false (default value)   | You use this setting to specify whether the display of the fully compounded keys for members should be forced when the compoundment ancestors are fixed. The default value is False . This means that the partially compounded keys are displayed. If you change the parameter value to True , the display of the fully com­ pounded keys is forced.                                                                                                             | Analysis plug-in |
| ForceHttpsScheme= true (default value) or false            | You use this setting to specify whether the SAP Analytics Cloud URLs should be converted to https for the logon. After installation, the default value is True . This means that the SAP Analyt­ ics Cloud URLs are converted to https before the logon window is shown.. If you change the parameter value to False , the the SAP Analytics Cloud URLs won't be converted to https .                                                                            | Analysis plug-in |
| ForceRefreshConnectionInfo = true or false (default value) | You use this setting to specify whether the SNC(Secure Network Communi­ cations) information is read from the launcher file or from the local SAPUI­ Landscape.xml installation. The default value is False . This means that the SNCinformation is read from the launcher file. If you change the parameter value to True , only the SNCinformation in the local SAPUILandscape.xml is used. Therefore we do not recommend changing this setting to value True . | Analysis plug-in |
| Setting and Setting Value                                                               | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Available for    |
|-----------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ForceWriteOlapConnectionIn formationDuringWorkbookSav e = true or false (default value) | You use this setting to fix workbooks with OLAP connections saved on the BI platform using an Analysis version 2.5 SP1 or lower. With these workbooks, it is possible that precalculation does not work and you get a message from the server like 'Document does not contain OLAP con­ nections'. To fix the workbook, set the value to True. After setting the value to true, restart Analysis and open the workbook from the BI platform to overwrite the existing one. | Analysis plug-in |
| FormulaExpressionValidatio nInterval = 2 (default value)                                | You can add a new measure based on a free-form calculation to a crosstab. The new measures are defined in the New Calculation dialog box. The formula that you enter in the dialog box is checked on a regular basis. You use this setting to specify the num­ ber of seconds. The default value is 2 . This means that the formula is checked two seconds after your last change in the formula editor. You can enter any integer value for this setting.                 | Analysis plug-in |
| Setting and Setting Value                                            | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Available for    |
|----------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| GatewayServiceNo = -1 (default value)                                | You can use this setting to define a gateway service number. After installation, the default value is -1 . This means that no gateway service number is defined. If you change the parameter value to a number greater than 0 and a Gateway host is also defined, the value is added as the gateway port (GatewayService­ Number or GWSERV) while establishing any RFC connection. If the value of the gateway service num­ ber is already set in the RFC parame­ ters (e.g., coming from a launcher/lo­ cal connection), Analysis won't override that value.                            | Analysis plug-in |
| HanaHttpConnectionTimeout = -1 (default value) or any integer value. | You use this setting to specify the time Analysis is waiting to get a connection to a HANAHTTPserver. The default value is -1 . This means that there is no timeout for connecting to a HANAHTTPserver. You can enter any integer value for this setting to define the time Analysis is waiting to get a connection. The unit is millisecond. If you specify value 60000, for example, Analysis is waiting 60000 milliseconds to establish the connec­ tion. If it is not possible to connect to a HANAHTTPserver in the defined time­ out period, a message is displayed in Analysis. | Analysis plug-in |
| Setting and Setting Value                           | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for    |
|-----------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| HanaHttpSessionPingInterva l                        | You use this setting to specify the time Analysis is waiting to send a regular HTTP ping request to HANAXStokeep the session alive. The default value is 180 . This means that Analysis is sending the request ev­ ery 180 seconds. You can enter any integer value for this setting to define the time for the next ping request. There is a correlation of the session timeout defined in HANAXS. This ses­ sion timeout value can be configured in the HANAXSconfiguration under xsen­ gine.ini -> httpserver -> sessiontimeout (value in seconds). | Analysis plug-in |
| HierarchyCollapsePaddingCo ls = " " (default value) | You use this setting to specify the in­ dent in columns when the node is ex­ panded with space characters. The default value is " " (five spaces). You can enter any number of spaces here to define the indent. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin gs is activated with value True.                                                                                                                                                                                                        | Analysis plug-in |
| HierarchyCollapsePaddingRo ws = " " (default value) | You use this setting to specify the in­ dent in rows when the node is expanded with space characters. The default value is " " (five spaces). You can enter any number of spaces here to define the indent. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin gs is activated with value True.                                                                                                                                                                                                            | Analysis plug-in |
| Setting and Setting Value                          | Setting Description                                                                                                                                                                                                                                                                                                                                                                   | Available for    |
|----------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| HierarchyCollapseSymbolCol s = [-] (default value) | You use this setting to specify the char­ acter to be used as a symbol for col­ lapsing hierarchy nodes in columns. The default value is [-] . You can use Unicode codepoints to specify other symbols, e.g. \u25bc for a black down- pointing triangle. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin gs is activated with value True.  | Analysis plug-in |
| HierarchyCollapseSymbolRow s = [-] (default value) | You use this setting to specify the char­ acter to be used as a symbol for col­ lapsing hierarchy nodes in the rows. The default value is [-] . You can use Unicode codepoints to specify other symbols, e.g. \u25bc for a black down- pointing triangle. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin gs is activated with value True. | Analysis plug-in |
| HierarchyExpandPaddingCols = " " (default value)   | You use this setting to specify the in­ dent in columns when the node is ex­ panded with space characters. The default value is " " (five spaces). You can enter any number of spaces here to define the indent. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin                                                                           | Analysis plug-in |
| Setting and Setting Value                        | Setting Description                                                                                                                                                                                                                                                                                                                                                                                | Available for    |
|--------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| HierarchyExpandPaddingRows = " " (default value) | You use this setting to specify the in­ dent in rows when the node is collapsed with space characters. The default value is " " (five spaces). You can enter any number of spaces here to define the indent. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin gs is activated with value True.                                                          | Analysis plug-in |
| HierarchyExpandSymbolCols = [+] (default value)  | You use this setting to specify the character to be used as a symbol for expanding hierarchy nodes in the col­ umns. The default value is [+] . You can use Unicode codepoints to specify other symbols, e.g. \u25bc for a black down- pointing triangle. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin gs is activated with value True.             | Analysis plug-in |
| HierarchyExpandSymbolRows = [+] (default value)  | You use this setting to specify the char­ acter to be used as a symbol for ex­ panding hierarchy nodes in the rows (e.g. \u25ba). The default value is [+] . You can use Unicode codepoints to specify other symbols, e.g. \u25bc for a black down- pointing triangle. The value for this setting is only applied in Analysis if setting UseAdvancedHierarchySettin gs is activated with value True. | Analysis plug-in |

| Setting and Setting Value                                                   | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for    |
|-----------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| HierarchyLevelHideAutoOffs et = Default (default value), ""(empty) , X or R | You use this setting to optimize the per­ formance for the Show Levels function­ ality. Depending on your require­ ments, you can specify values for the RSADMIN parameter BICS_HRY_LVL_HIDE_AUTO_OFFSET to optimize the Show Levels functional­ ity. The parameter values can be set in the backend and in Analysis. For more information, please see SAP Note 2864360 .                                                                                                                                                                                                                               | Analysis plug-in |
| IgnoreCaseForNewLineCharac teristics = true or false (de­ fault value)       | You use settings to specify whether the text for a characteristic member that you enter in a new line cell should be treated as case sensitive data. The default value is False . This means that the text will be treated as case sen­ sitive and a member value which only is different in an upper or lower case from the expected value on the server is not accepted. If you change the value to True , the entered text will be treated as upper case text. Also here, a member value which only is different in an upper or lower case from the expected value on the server is not accepted. | Analysis plug-in |
| Setting and Setting Value                                                 | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Available for    |
|---------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| IgnoreQueryDesignerVersion Check = true or false (default value)          | You use this setting to define if the de­ signer version on the machine should be checked. The default value for this setting is False . This means that the designer version will be checked. The Setting Show 'Launch Designer' in Tools Group in the user settings is only selectable if the correct designer version is installed. If you change the parameter value to True , the designer version will not be checked and the setting Show 'Launch Designer' in Tools Group is always se­ lectable.                                                                                                                                                                                                                                                                                                                                                 | Analysis plug-in |
| IncludeInstancesInInfoObje ctSearchResult = true or false (default value) | When you search for a workbook stored on the BI platform in Analysis (in the Excel Backstage -> Analysis -> Open Workbook -> Open Workbook from the SAP BusinessObjects BI Platform), the search results might include more than one instance of the same workbook. But the additional instances might have different file sizes. However, when you search for the same workbook in the Central Management Console (CMC) in the BI platform, only the original workbook is included in the search results. You can use this setting to specify whether the additional instances should be part of the search result in Analysis. The default value is False . This means that the additional search results are not part of the search result in Analysis. If you set the value to True , the ad­ ditional instances will be shown in the search result. | Analysis plug-in |

| Setting and Setting Value                                               | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                      | Available for         |
|-------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| InputReadyCellsValueHelpMe mberAccessMode = P                           | You use this setting to specify the mem­ ber access mode (value help) for input- ready cells. The default value is P (Planning). For more information on the existing modes, see 2180059 .                                                                                                                                                                                                                                                | Analysis plug-in      |
| InsertCopiedProfilingResul tsToNewSheet = true (default value) or false | You use this setting to specify whether the client profiling statistics can be cop­ ied to a new workbook. The default value is True . This means that you can choose the option Copy to a New Workbook in the Client Profiling Statistics dialog. If you change the parameter value to False , it is no longer possible to copy the profiling statistics to a new work­                                                                   | Analysis add-in (COF) |
| IsCachingDocuments = true (de­ fault value) or false                     | You use this setting to specify whether caching should be enabled. After installation, the default value is True . This means that caching is ac­ tive. If you change the parameter value to False , the function is disabled and caching cannot be used.                                                                                                                                                                                 | Analysis plug-in      |
| KeepAliveTimeoutInSeconds = 60 (default value)                          | You use this setting to set the keep-alive value. You set the value to the time interval (in seconds) between each re­ quest, so that the session stays alive. Werecommend that you enter a value below the value of the server timeout. For example, if the server timeout is set to 1200 seconds, enter the value 900 in this setting. The default value is 60 . This means that the time interval between each re­ quest is 60 seconds. | BPC plug-in*          |
| Setting and Setting Value                                  | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Available for    |
|------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| LastContinousUsageDataUplo ad = 01.01.0001 (default value) | This setting is used for Usage Tracking. After installation, the default value is 01.01.0001 . Werecommend not changing the value. You can deactivate Usage Tracking for Analysis with setting TrackUsage .                                                                                                                                                                                                                                                                           | Analysis plug-in |
| LastPeriodicUsageDataUploa d = 200000 (default value)      | This setting is used for Usage Tracking. After installation, the default value is 200000 . Werecommend not changing the value. You can deactivate Usage Tracking for Analysis with setting TrackUsage .                                                                                                                                                                                                                                                                               | Analysis plug-in |
| LastSelectedSacSystem = "" (default value)                 | This setting is relevant when working with Analysis, edition for SAP Analytics Cloud. After the installation, the default for this setting is "" . This means that no con­ nection to an SAP Analytics Cloud has been established so far. After connecting to one or several SAP Analytics Cloud tenants, Analysis re­ members the last connection you used for the next session. This connection is then preselected in the Connect to SAC dialog when you use Analysis the next time. | Analysis plug-in |
| LastUsedBpfConnections                                     | This setting lists all the latest connec­ tions you have used. This setting is fil- led automatically and you should not change its value.                                                                                                                                                                                                                                                                                                                                             | BPC plug-in*     |
| LinesOfData = 12 (default value)                           | You use this setting to define the default number of rows. After installation, the default value is 12 .                                                                                                                                                                                                                                                                                                                                                                              | Analysis plug-in |
| Setting and Setting Value                             | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Available for    |
|-------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| LogType = 0 (default value), 1 or 2                   | You use this setting to define whether a log should be created during conver­ sion. The default value for this parame­ ter is 0 . This means that no log will be created. If you set the parameter value to 1 , a log is created and displayed on a work­ book sheet. If you set the value to 2 , a log is created and stored on a hidden workbook sheet.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Analysis plug-in |
| MatchDimensionsByText = true or false (default value) | For grouping crosstabs and linking di­ mensions, Analysis uses the dimension names to match master and dependant dimensions. Therefore, these options are not enabled if the queries contain dimensions with different names but with the same description. You use this setting to specify whether the dimension descriptions should also be used to match the dimensions be­ tween master and dependant. After installation, the default value is False . This means that only the di­ mension names are used to match the master and dependant dimension. If you change the parameter value to True , the dimension names and de­ scriptions are used to match the di­ mensions between master and depend­ ant. In the first step, Analysis tries to match the dimension names. If there's no match, Analysis tries to match the dimension descriptions. | Analysis plug-in |
| Setting and Setting Value                                            | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Available for    |
|----------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| MaxNumberOfParallelThreads = 10 (default value) or any integer value | You use this setting to define the max­ imum number of parallel threads that Analysis can use to open theSAPHANA data sources of a workbook. The default value is 10 . This means that up to 10 SAP HANAdata sources can be opened with parallel threads. You can enter any integer value for this setting. If you set the value to 1 or lower, no parallel threads will be used. The data sources will be opened sequentially.                                                                 | Analysis plug-in |
| MergeVariables = true or false (default value)                       | You use this setting to specify whether or not the Merge Variables check box in the Components tab in the design panel is selected when you create a new workbook. After installation, the default value is False . This means that the check box is not selected when you create a new workbook. You can change this manually by select­ ing the check box for single workbooks or setting the parameter value to True . The check box is then always selected when you create a new workbook. | Analysis plug-in |
| Setting and Setting Value                                                                                                       | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Available for         |
|---------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| MessagePopupSeverity = "" (de­ fault value), Error , Warning or Success                                                          | You use this setting to specify whether messages should be displayed in a pop- in or in a dialog box, depending on the message severity. Critical is the most severe cate­ gory, Success is the least severe. The severity Success corresponds to se­ verity Information in Analysis. The default value is "" . This means that after the installation no value is de­ fined and only messages with severity Critical are displayed in a dialog box. Messages with lower severities (Error, Warning or Success) are displayed in a pop-in dialog. You can change the parameter value to Error , Warning or Success . If you select a severity, all messages are displayed which have this severity or higher. If you enter Warning , for example, all messages with severity Warning , Error and Critical are displayed in a dialog box. Messages with severity Success are displayed in a pop-in dialog. | Analysis plug-in      |
| MinorVersion = <integer value of the installed version> (default value) or any in­ teger value lower than the installed ver­ sion | You use this setting to specify the minor version that should be used. The default value is the integer value of the installed version, for example value 3 for version 2.3. If you change the value to 1 , version 2.1 will be used. This setting can only be maintained by an administrator in the file system un­ der C:\ProgramData\SAP\Cof .                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Analysis add-in (COF) |
| Setting and Setting Value                                 | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for         |
|-----------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| NcoTraceLevel = 0 (default value), 1 , 2 , 3 or 4         | This setting can be used for SAP error handling. Analysis uses the .Net con­ nector (NCO) for calling ABAP RFCs from client. NCOsupports logging of RFC traces. You use this setting to specify the de­ sired level for tracing. The default value is 0 . This means no tracing takes place. You can change the parameter value to 1 , 2 , 3 or 4 . If you now work with Analysis, log files will be created according to the selected level in the %temp%folder of windows. There you can find a dev_nco_rfc.log file and a number of files "nco_rfc_XXXX_Y.trc". Additionally, there is the Analysis log file "SAPAdvan­ cedAnalysisXLS.log". You can zip all of them to attach them to the message. | Analysis add-in (COF) |
| NewLineCheckMode = NONE (default value), MEMBERS or LINES | You use this setting to specify whether a check for new or changed data in new lines is done. The default value is NONE . This means that no automatic check is executed. You can enter MEMBERS to run a check whenever a member was changed or added in new lines. Or you use the value LINES to run an automatic check whenever a line or a cell in a line was changed, and the der­ ivation is done automatically. The deri­ vations can only work if the character­ istic relationship is modeled in theBW system.                                                                                                                                                                                 | Analysis plug-in      |
| Setting and Setting Value                                           | Setting Description                                                                                                                                                                                                                                                                         | Available for         |
|---------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| NoSystemMessages = true or false (default value)                    | You use this setting to specify whether back-end system messages should be displayed or not. The default value for this setting is false . This means that back-end sys­ tem messages will be displayed. If you change the value to true , back- end system messages will not be dis­ played. | Analysis plug-in      |
| NrOfSingleCellsInContext = greater or equal 1 , default value = 100 | This setting defines the maximum num­ ber of crosstab cells that can be se­ lected to execute analysis options, for example filtering. If more cells are se­ lected in a crosstab, the analysis op­ tions are disabled.                                                                         | Analysis plug-in      |
| NumberOfNewLines = 5 (default value)                                | You use this setting to define the default number of new lines. The default value is 5 . This means that 5 new lines will be added to the cross­ tab. You can enter any integer value for this setting.                                                                                      | Analysis plug-in      |
| NwbcTicketIssuerPath = /sap/ bc/nwbc/TicketIss uer                  | This setting defines the standard path to the SAP NetWeaver Business Client ticket issuer on the server. The default value is /sap/bc/nwbc/ TicketIss . Wedonot recommend to change the path manually.                                                                                      | Analysis add-in (COF) |
| Setting and Setting Value                                        | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Available for    |
|------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| OpenDSTreeView = true or false (default value)                   | You want to insert a new data source in Analysis and open the Select Data Source dialog. The selectable data sources are displayed in a list. This set­ ting can be used to define the view for the selectable data sources. The op­ tions are list view and tree view. The default value is false . This means that the data sources are displayed in the list view. Werecommend not changing the value. You can switch to the tree view in the Select Data Source dialog at any time.                                                                                                                             | Analysis plug-in |
| OperatorContainsPattern = true or false (default)                | You use this setting to define whether the operators Contains Pattern (CP) and Excludes Pattern ( !CP) should be enabled for prompting. The default value is False . This means that the contains pattern operators cannot be used for prompting. To enable the contains pattern opera­ tors for prompting, you can set the pa­ rameter value to True .                                                                                                                                                                                                                                                             | Analysis plug-in |
| PasteMemberParsingOptions = All (default value) or SingleMembers | You use this setting to specify how signs like the minus sign (-) are inter­ preted when using the options 'Paste from Clipboard' and 'Paste from File' in the filter by member dialog. The default value is All . This means that values with a minus sign, for exam­ ple 'abc-xyz', are interpreted as ranges. If you change the parameter value to SingleMember, the example 'abc-xyz' will be interpreted as one single mem­ ber with the name 'abc-xyz'. If you want to define a range with this parameter value, you can use spaces: abc - xyz. For more information about using signs, see SAP Note 2422924 . | Analysis plug-in |
| Setting and Setting Value                                           | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for    |
|---------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| PlanningFunctionUploadFold er = "" (default value)                  | When using planning objects (functions and sequences), you can upload the values for executing planning objects from a file. You use this setting to define a default folder that is opened to select a file when you execute a planning ob­ ject. The default value is "" . This means that no default folder is defined. In this case, Analysis opens the folder you used the last time for selecting a file. If you enter a path to a folder for this setting, this folder is always opened to select a file when you execute a plan­ ning object. | Analysis plug-in |
| PreferDirectAssertionTicke ts = true (default value) or false       | When you try to establish a second OLAP connection or open a workbook from the BI platform, Analysis waits for the backend RFC call to get a new re-entrance ticket RSAO_GET_RE­ ENTRY_TICKET against the BWsystem. If the ticket does not return, Analysis could freeze and become unresponsive. That is the behavior if this setting is set to True (default value). If you set the value to False , the ticket is obtained via the BI platform. To use this option, an active BI platform con­ nection must be available.                          | Analysis plug-in |
| PreferLeavesOverNodesInInp utString = true (default value) or false | You use this setting to define whether an input string should select a leaf or node if both have the same string. The default value is True . This means that the leaf will be selected.                                                                                                                                                                                                                                                                                                                                                            | Analysis plug-in |
| Setting and Setting Value                            | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for    |
|------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| PreferredDocumentStorage = 0, 1 or 2 (default value) | You use this setting to define the prefer­ red document storage for comments in Analysis. After installation of Analysis, the default value of this parameter is set to 2. This means that the preferred document storage is SAP Business Warehouse. If you set the parameter value to 1, the SAP BusinessObjects Business Intelli­ gence Platform is used as document storage for comments. If you set the value to 0, comments are not stored on platform.                                                                                                                                                                                                                                                                          | Analysis plug-in |
| PreferredPlatform = 0 (default value), 1 , 2 or 3    | You use this setting to define the prefer­ red platform for your Analysis installa­ tion. After installation of Analysis, the default value of this parameter is set to 0 . This means that all platforms are enabled. If you set the parameter value to 1 , the SAP BusinessObjects Business Intelligence Platform is enabled. If you set the value to 2 , SAP BWis enabled as platform. With parameter value 3 , the SAP BusinessObjects Business Intelligence Platform with compatibility mode is en­ abled. This means that the workbook is saved as Analysis Workbook (Com­ patibility Mode). The Analysis Work­ book (Compatibility Mode) object cor­ responds to the Microsoft Excel object used with former BI platform releases. | Analysis plug-in |
| Profiling = true or false (de­ fault value)           | You use this setting to activate the query runtime statistics of SAP BW. For more information, see . You can also activate the setting in the Support Settings dialog with setting Enable Workbook Profiling . For more information, see Trouble­ shooting in Analysis [page 331].                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Analysis plug-in |
| Setting and Setting Value                                       | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for    |
|-----------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| PromptForCertificate = true or false (default value)            | You use this setting to specify whether the certificate should be searched for automatically or entered manually. The default value for this setting is False . This means that the certificate will be searched fo automatically. If no certificate can be found, you have to enter a user ID and a password. If you change the parameter value to True , you have to enter the certificate manually.                                                                                                                              | Analysis plug-in |
| PromptWhenInsertingDataSou rce = true (default value) or false  | You use this setting to define the behav­ ior of the prompting dialog box when inserting a new data source. After installation, the default value is True . This means that the prompt­ ing dialog box always appears automat­ ically when you insert a data source containing variables. If you set this parameter to False , the prompts dialog only appears when the data source contains mandatory varia­                                                                                                                           | Analysis plug-in |
| PropagateSelectionInStruct ures = true or false (default value) | You use this setting to define the behav­ ior of hierarchical structures in the filter dialog box. In characteristic hierarchies the selec­ tion of a node leads to the selection of all its children and vice versa. For hierarchical structures, selection of a node is independent to the selection of its children in the filter dialog box. This is the behavior for the default value False . If you change the value to True , hier­ archical structures will behave like char­ acteristic hierarchies in the filter dialog box. | Analysis plug-in |
| Setting and Setting Value                               | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Available for    |
|---------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ReadOnlyBoeSystemsList = tru e or false (default value) | When a workbook is launched from BI Platform/Launchpad, the existing BIP Web Service (Logon) URLs and authen­ tication types in the Analysis Logon to SAP BusinessObjects Enterprise dia­ log are overwritten. They can also be changed manually by the user. You can avoid this behavior and keep the existing Web Service URLs and authentication types read- only, as maintained in the Anal­ ysis user configuration file at %appdata%\SAP\Cof\Ao_user_roam­ ing.config. Please see setting BoeSystems . You can use this setting to specify whether the BIP Web Service (Logon) URLs and authentication types should be editable. The default value is False . This means that the BIP Web Service (Logon) URLs and authentication types are editable.. If you set the value to True , the BIP Web Service (Logon) URLs and authen­ tication types are read-onlay. | Analysis plug-in |
| Setting and Setting Value                                              | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Available for    |
|------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ReassignPFLinkFilterOnInit ialRefresh = true or false (de­ fault value) | You use this setting to specify whether the initial refresh of the planning func­ tion should link all dimensions to the filter object or data source with non- empty filter values. The default value is False . This means that the dimensions are not linked to the filter object or data source with non-empty filter values. If you change the value to True , the initial refresh of the planning function links all dimensions to the filter object or data source with non-empty filter values. Such a link of a dimension is not done if the dimension already uses a link or cell configuration or if a non-empty Mem­ ber value is configured. For more information, see SAP Note 2851131 | Analysis plug-in |
| RecentListSize = greater or equal 1 , default value = 10               | This setting defines the number of en­ tries in the list of last opened data sour­ ces in the Insert Data Source dialog box. You can also define this number in the User Settings in the Settings dialog box. By pressing the Delete Recently Used List button, you can delete the history of the recently used data sources.                                                                                                                                                                                                                                                                                                                                                                        | Analysis plug-in |
| RefreshType = 0 (default value), 1 or 2                                | You use this setting to define whether the workbook should be refreshed after conversion. The default value of this pa­ rameter is set to 0 . This means that the workbook is always refreshed. If you set the parameter value to 1 , the workbook is not refreshed. If you set the value to 2 , the workbook is refreshed after conversion if the corre­ sponding properties are selected on the components tab in the design panel.                                                                                                                                                                                                                                                                | Analysis plug-in |
| Setting and Setting Value                                | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Available for    |
|----------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| RememberSearchObjectType = true or false (default value) | In the Select Data Source dialog, you can search for all objects of a system or objects of one object type. For example, in BWsystems, you can search for all objects, InfoProvider, Queries, or Query Views. You use this setting to specify whether your selection for the object type should be remembered the next time you use Analysis. The default value for this setting is False . This means that the selected object type in the Select Data Source dialog won't be remembered. If you change the parameter value to True , the selected object type in the Select Data Source dialog will be re­ membered. | Analysis plug-in |
| RemoveDataBeforeSaving = tru e or false (default value)  | You use this setting to define whether the check box Remove Data Before Saving on the Components tab in the design panel is selected as default for new workbooks. If the check box is selected, it is saved without data. When you reopen the workbook, no data is displayed. To display the data, you have to refresh the data sources manually by choosing Refresh All in the menu. The default value is False . This means that the check box on the Components tab is not selected as default. If you change the parameter value to True , the check box is selected as de­ fault when you open a new workbook.   | Analysis plug-in |
| Setting and Setting Value                                           | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Available for    |
|---------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ReResolveDependentHierarch yNodeVariables = true or false (default) | When entering values for a hierarchy node variable in the prompts dialog where the hierachy is set via a hierarchy variable, the hierachy node variable can have a wrong value if entered before the hierarchy variable. Re-resolving of de­ pendent hierarchy node variables can be necessary because the input string is parsed and processed regardless of the processing order. You use this setting to define whether re-resolving of the dependent hierarchy node variables should be enabled. The default value is False . This means that the re-resolving is disabled. If you set the parameter value to True , the dependent hierarchy node variables will be re-resolved before the variable values are finally submitted. | Analysis plug-in |
| ResultSetSizeLimit = -1 , n or empty (default)                      | This setting defines the maximum num­ ber of crosstab cells that are loaded from the server for one data source. If a data source contains data for more cells than defined here, a message dis­ plays. The standard value for this setting is empty and the maximum number of cells is 500000. If you set the parameter to a specific number greater than or equal to 0, you define the maximum number of cells                                                                                                                                                                                                                                                                                                                       | Analysis plug-in |
| Setting and Setting Value                                 | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | Available for    |
|-----------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| RetrieveMultilingualTexts = true (default value) or false | On the BI platform, the name and de­ scription of documents and folders can be translated. You use this setting to specify if the translated texts should be available in Analysis. The default value is True . This means that the translated names are available in Analysis. Depending on the selected language, you see the original version or a translated version. If you set the value to False , only the original version is available in Analysis.                                                                                                                                                                                                                                                                                                             | Analysis plug-in |
| ReverseVariableProcessingO rderForHanaFromOldXml          | This setting is relevant for workbooks saved with Analysis 2.7 SP0 or lower. You use this setting to specify whether the variable order will be reversed dur­ ing the initial processing for all work­ books that are saved with an Analysis version 2.7 SP0 or lower. The default value is False . This means that the variable order will not be re­ versed. This might have a negative ef­ fect on performance. If you change the parameter value to True , the variable order will be reversed. Independent of the setting value when saving the workbook, it will be serialized in the correct order and with a new document version. The new document version will ensure that the variable order will not be reversed again when you open the workbook the next time. | Analysis plug-in |
| RfcBundling = true (default value) or false               | This setting is recommended when working in an WANenvironment to re­ duce network traffic. After installation, the default value is True .                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Analysis plug-in |
| Setting and Setting Value                  | Setting Description                                                                                                                                                           | Available for    |
|--------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| RGBValueColumns = #808080 (de­ fault value) | You use this setting to define the color for the columns that represent the start and end values. The default value is #808080 . This means that the columns display in grey. | Analysis plug-in |
| RGBValueNegative = #FF000C (default value) | You use this setting to define the color for the negative delta values. The default value is #FF000C . This means that the negative values display in red.                    | Analysis plug-in |
| RGBValuePositive = #90CE00 (default value) | You use this setting to define the color for the positive delta values. The default value is #90CE00 . This means that the positive values display in green.                  | Analysis plug-in |
| Setting and Setting Value                                                                            | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Available for    |
|------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| RouterStringCopyOption = None (default value), SystemIdMatch , ExtendedPropertyMatch , Auto or Force | In Analysis, you don't have the option to maintain an additional SAP Router string in OLAP connections. You can maintain additional router strings in the SAP GUI landscape, but Analysis can't copy them from the respective system entry. You can use this setting to specify whether Analysis should copy the router string from the SAP GUI land­ scape's respective system entry. The default value is None . This means that the router strings aren't copied from the SAP GUI landscape. If you change the value to SystemIdMatch , Analysis matches the remote BWsystem entry to the lo­ cal SAP GUI Landscape by its system ID. If a match is found, Analysis copies the router string from the local match. If you change the value to ExtendedPropertyMatch , Analy­ sis matches the remote BWsystem en­ try to the local SAP GUI Landscape by other properties like MessageServer or ServerGroup. If a match is found, Anal­ ysis copies the router string from the local match. If you change the value to Auto , Analysis tries to find a match with ExtendedPropertyMatch . If no match is found, Analysis uses SystemIdMatch to find a match in the SAP GUI landscape. If you change the value to Force , Anal­ ysis tries to find a match with Auto . If no match is found, it overwrites the existing router string in the remote BWsystem entry (for example, coming from the launcher). Note that this setting can only be maintained by an administrator in | Analysis plug-in |
| Setting and Setting Value                                              | Setting Description                                                                                                                                                                                                                                                                                                                                                                                    | Available for         |
|------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| SacHttpSessionPingInterval = 180 (default value) or any integer value. | You use this setting to specify the time Analysis is waiting to send a regular HTTP ping request to SAP Analytics Cloud to keep the session alive. The default value is 180 . This means that Analysis is sending the request ev­ ery 180 seconds. You can enter any integer value for this setting to define the time for the next                                                                     | Analysis plug-in      |
| SapWebGuiPath = /sap/bc/gui/ sap/its/webgui                            | This setting defines the standard path to the SAP Web GUI on the server. The default value is /sap/bc/gui/sap/its/ webgui . Wedonot recommend to change the path manually.                                                                                                                                                                                                                             | Analysis add-in (COF) |
| SaveAs1xByDefault = true or false (default value)                      | You use this setting to define whether a workbook should be saved by default with 1.x format in Analysis 2.x versions. The default value is False . This means that the checkbox Save as 1.x format is not selected by default in the saving dialog in Analysis. If you change the parameter value to True , the checkbox Save as 1.x format is selected by default in the saving dia­ log in Analysis. | Analysis plug-in      |
| Setting and Setting Value                                          | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Available for    |
|--------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| SearchFetchMemberLimit                                             | You use this setting to define the maxi­ mumnumberof members displayed in the Filter by Member dialog as result for a search. The default value is 10000 . This means that up to 10000 members will be dis­ played. You can enter any integer value for this setting. If the result contains more members than defined here, you get an informa­ tion in the dialog.                                                                                                                                                                           | Analysis plug-in |
| SetEmptiedDoubleDataCellsT oValue0 = true (default value) or false |  Note This setting is deprecated and is planned to be removed with next minor Analysis release > 2.5 as True seems to be the only rele­ vant value. Please contact the Analysis team, if you need this setting in future. You use this setting to specify whether empty planning data cells are saved as 0(zero) or with their old value. The default value is True . This means that empty planning data cells are saved as 0. If you change the value to False , the empty planning data cells are not saved as 0. The old value remains. | Analysis plug-in |
| Setting and Setting Value                                                                | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Available for    |
|------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| SetFilterComponentApplyToA llDataSources = true (default value) or false                 | In Analysis, you can insert a filter com­ ponent using the ribbon. If your work­ book contains more than one data source, the Select Data Source dialog box appears where you can define the data sources for the filter. You use this setting to specify if the check box Apply filter to all data sources should be selected by default. After installation, the default value is True . This means that the filter is ap­ plied to all data sources. If you change the parameter value to False , the filter will only be applied to the selected data source. | Analysis plug-in |
| ShowAllHierarchies = true (de­ fault value) or false                                      | You use this setting to specify whether all time-dependent hierarchies for a di­ mension should be available in the de­ sign panel. After installation, the default value is True . This means that all hierarchies are available in the design panel. If you change the parameter value to False , the hierarchies are no longer available in the design panel.                                                                                                                                                                                                 | Analysis plug-in |
| ShowBracketsForVirtualEntr iesOfNonCumulativeKeyfigur es = true (default value) or false | You use this setting to specify whether Analysis shows brackets for non-cu­ mulative measures that don't have a booked value in the corresponding time interval. In SAP BWbrackets for non-cumulative key figures are always shown. After installation, the default value is True . This means that Analysis shows brackets for non-cumulative measures. If you change the parameter value to False , Analysis will not show brackets for non-cumulative measures.                                                                                              | Analysis plug-in |
| Setting and Setting Value                                              | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Available for    |
|------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ShowConvertToForumulaInToo lsGroup = true (default value) or false     | This setting is used in Analysis with mi­ nor versions ≤ 3 to specify whether the Convert To Formula icon should be dis­ played in the ribbon. As of release 2.4, you customize the rib­ bon with the Customize User Interface dialog. Therefore, we recommend to use the Customize User Interface dialog to define the options displayed in the ribbon.  Note When switching to a version greater than 3, for example Anal­ ysis 2.4, Analysis takes your defi- nition from this setting. If the pa­ rameter value for this setting was True , the Convert To Formula icon is displayed in the standard profile | Analysis plug-in |
|                                                                        | for the ribbon. If it was False , it is not displayed.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                  |
| ShowCreateWebApplicationIn ToolsGroup = true or false (de­ fault value) | This setting is used in Analysis with mi­ nor versions ≤ 3 to specify whether the Create Web Application icon should be displayed in the ribbon. As of release 2.4, you customize the rib­ bon with the Customize User Interface dialog. Therefore, we recommend to use the Customize User Interface dialog to define the options displayed in the ribbon.                                                                                                                                                                                                                                                     | Analysis plug-in |
|                                                                        |  Note When switching to a version greater than 3, for example Anal­ ysis 2.4, Analysis takes your defi- nition from this setting. If the pa­ rameter value for this setting was True , the Create Web Application icon is displayed in the standard profile for the ribbon. If it was False , it is not displayed.                                                                                                                                                                                                                                                                                            |                  |
| Setting and Setting Value                                             | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Available for    |
|-----------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ShowCutCopyPasteInGridCont extMenu                                    | In Microsoft Excel, the context menu for each cell contains entries to cut, copy and paste cell content. You can use this setting to specify whether these entries should be available for Analysis cross­ tab cells. The default value is false . This means that the context menu on Analysis crosstab cells does not contain the Mi­ crosoft Excel Cut, Copy and Paste op­ tions. If you change the parameter value to True , the Cut, Copy and Paste options are available in the context menu for Analysis crosstab cells. | Analysis plug-in |
| ShowDSVariantsForWorkbooks WithOneDS = true or false (de­ fault value) | You use this setting to specify the mode for the prompting dialog when you open a document from the BWserver that contains exactly one data source. The default value is False . This means that the prompting dialog is opened in document mode. If you change the parameter value to True , the prompting dialog is opened in data source mode..                                                                                                                                                                           | Analysis plug-in |
| Setting and Setting Value                             | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Available for    |
|-------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ShowGroupedDimensions = true or false (default value) | You use this setting to define whether dimensions are displayed grouped or as a flat list on the Analysis tab in the de­ sign panel. The default value is False . This means that the dimensions are displayed as a flat list. You can change the view in the ribbon. The selected view remains in the design panel until you deselect it again, even if you close Excel mean­ while. If you change the parameter value to True , the dimensions are displayed in groups by default. Note that the dimension grouping is done in the corresponding backend sys­ tem,SAPBWorSAPHANA. | Analysis plug-in |
| ShowNewLinesOnTop = true or false (default value)     | You use this setting to specify whether the new lines should be added to the bottom or to the top of the crosstab. The default value is False . This means that new lines are added to the bottom of the crosstab. If you change the value to True , the new lines are added to the top of the crosstab.                                                                                                                                                                                                                                                                         | Analysis plug-in |
| Setting and Setting Value                           | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Available for    |
|-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ShowPlanningToolbar = true or false (default value) | This setting is used in Analysis with mi­ nor versions ≤ 3 to specify whether the planning group should be displayed in the ribbon. As of release 2.4, you customize the rib­ bon with the Customize User Interface dialog. Therefore, we recommend to use the Customize User Interface dialog to define the options displayed in the ribbon.  Note When switching to a version greater than 3, for example Anal­                                                                     | Analysis plug-in |
| ShowProperties = true or false (default value)      | You use this setting to define whether the Property View in the design panel is displayed by default. The default value is False . This means that the Property View is not displayed when you open the design panel. You can open the property view in the rib­ bon. The property view remains in the design panel until you deselect it again, even if you close Excel. If you change the parameter value to True , the Property View is displayed in the design panel by default. | Analysis plug-in |
| Setting and Setting Value                             | Setting Description                                                                                                                                                                                                                                                                                                                                                                             | Available for    |
|-------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ShowSaveDialog = true or false (default value)        | You use this setting to specify whether the save dialog box should be displayed after a workbook conversion. The default value is False , meaning that the save dialog box will not display after conversion. If you change the parameter value to True , the save dialog box will be dis­ played after conversion.                                                                              | Analysis plug-in |
| ShowSsoLogonDialog = true or false (default value)    | You use this setting to specify whether the Logon dialog box should be dis­ played when using SSO with the SAP BWplatform. The default value is False . This means that the logon dialog box is not dis­ played. If you change the parameter value to True , the logon dialog box is displayed and the user can change the client and the logon language. You can also enable this setting in the | Analysis plug-in |
| ShowSsoLogonDialogBip = true or false (default value) | You use this setting to specify whether the Logon dialog box should be dis­ played when using SSO with the BI plat­ form. The default value is False . This means that the logon dialog box is not dis­ played. If you change the parameter value to True , the logon dialog box is displayed and the user can select one of the avail­ able BI platforms and change the logon language.            | Analysis plug-in |
| Setting and Setting Value                                     | Setting Description                                                                                                                                                                                                                                                                                                                                     | Available for    |
|---------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| ShowSuppressedMessages = true or false (default value)        | You use this setting to specify whether messages that are suppressed with API method SAPSuppressMessage should be displayed. The default value is False . This means that the suppressed messages are not displayed. If you change the parameter value to True , the messages that are suppressed with API method SAPSuppressMessage will be displayed. | Analysis plug-in |
| ShowUtcTimeStampsInDataCel ls = true or false (default value) | You use this setting to specify whether the UTC timestamps or localized time­ stamps are displayed in the data cells. The default value is False . This means that localized timestamps are displayed in the data cells. If you change the value to True , the UTC timestamps are displayed.                                                             | Analysis plug-in |
| SidePanelWidth = 250 (default value)                          | You use this setting to define the width of the Activity pane in the BPC plug-in. The default value is 250 points. The value is automatically adapted if a user resizes the width of the pane manually in the application.                                                                                                                              | BPC plug-in*     |
| Setting and Setting Value                                                         | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Available for    |
|-----------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| SkipPreferringSystemIpAddr essOverHostName = true or false (default value)        | You use this setting to specify whether the launcher file for the BEx Query De­ signer is generated using the IP address of the relevant BWsystem or its host name. The default value is False . This means that the IP address is used for gener­ ating the launcher file. When the IP ad­ dress of the BWsystem is not accessi­ ble from the client where Analysis is in­ stalled, you might run into an RFC error. If you change the parameter value to True , the launcher file for the BEx Query Designer will be generated using the host name of the relevant BWsys­ tem. | Analysis plug-in |
| StylesCountPerformanceTres hold = 2000 (default value) or any in­ teger value.     | The number of cell styles used in a workbook can decrease the perform­ ance in Analysis. You use this setting to specify the number of styles that can be used in workbook before a warning message is displayed. The default value is 2000 . This means that a warning message will appear if more than 2000 celll styles are used in a workbook. You can enter any integer value for this setting. With value 0 , the warning is dis­ abled and no message will be displayed.                                                                                              | Analysis plug-in |
| SubsequentRefreshDefault = TransactionDataOnly (default value) or LogOffReconnect | You use this setting to specify the de­ fault behavior for executing Refresh All . After the installation, the default value is TransactionDataOnly . This means that for all data sources that are online in a workbook, the transactional data is updated when Refresh All is exe­ cuted. If you change the parameter value to LogOffReconnect , executing Refresh All loggs off an reconnects all data sources that are online.                                                                                                                                           | Analysis plug-in |
| Setting and Setting Value                              | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                       | Available for    |
|--------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| SupportAutomatedOffice = true or false (default value) | You use this setting to specify whether the Analysis Plug-in should be sup­ ported if the Microsoft Office tools are running in embedded mode (also called automated mode). The default value is False . This means that the Analysis Plug-in is not sup­ ported. If you change the parameter value to True , the Analysis Plug-in will be sup­ ported. This setting is only evaluated if you set SupportEmbeddedMode in the | Analysis plug-in |
| Setting and Setting Value                           | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Available for         |
|-----------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| SupportEmbeddedMode = True or False (default value) | You use this setting to specify whether the Analysis Add-in should be sup­ ported when the Microsoft Office tools are running in embedded mode (also called automated mode). The default value is False . This means that the Analysis Add-in is not sup­ ported. If you change the parameter value to True , the Analysis Add-in will be sup­ ported. If you set the setting to True , you can disable the Analysis Plug-in using the setting SupportAutomatedOffice in the Ao_app.config file. | Analysis add-in (COF) |
| SupportEmbeddedMode = True or False (default value) |  Note Microsoft does not support Add-ins if the MSOffice tool is running in embedded mode. This is the case if the tool is embedded into a host­ ing window, for example in another MSOffice tool or ABAP GUI, or when the MSOffice tool is started with excel.exe -Embedding by Windows. Wedonot recommend changing this setting because in many sce­ narios, for example if the tool is em­ bedded in a hosting window, some issues can occur which cannot be resolved.                       | Analysis add-in (COF) |
| SupportEmbeddedMode = True or False (default value) |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Analysis add-in (COF) |
| SupportEmbeddedMode = True or False (default value) |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Analysis add-in (COF) |
| Setting and Setting Value                                          | Setting Description                                                                                                                                                                                                                                                                                                                          | Available for    |
|--------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| SupportsSaveAs1x = true or false (default value)                   | You use this setting to define whether a workbook could be saved with 1.x for­ mat in Analysis 2.x versions. The default value is False . This means that it is not possible to save a work­ book with 1.x format. If you change the parameter value to True , the checkbox Save as 1.x format is available in the saving dialog in Analy­ sis. | Analysis plug-in |
| SynchronizeRuleEditorWithC rosstab = true (default value) or false | You use this setting to specify whether a table design rule is highlighted in the design panel when you select the cell or line in the crosstab containing the rule. The default value is True . This means that the rule is highlighted in the design panel. If you change the parameter value to False , the rules will not be highlighted | Analysis plug-in |
| TaskPaneDockPosition = 1 (de­ fault value)                          | You use this setting to define where the design panel should be inserted. The default value is 1 . This means that the design panel is inserted on the right. You can change the parameter to 2 to insert it on the left, to 3 to insert it on the top, or to 4 to insert it at the bot­ tom. If you change the parameter to 0 , the          | Analysis plug-in |
| TaskPaneHeight = 975 (default value)                               | You use this setting to define the height of the design panel. The height is only relevant if the design panel is inserted at the top or bottom. The default value is 975 points.                                                                                                                                                            | Analysis plug-in |
| Setting and Setting Value                                                  | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Available for    |
|----------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| TaskPaneWidth = 498 (default value)                                        | You use this setting to define the width of the design panel. The width is only relevant if the design panel is inserted on the left or right. The default value is 498 points.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Analysis plug-in |
| TextKeyDisplay = Default (de­ fault value), TextKey , KeyText , Key or Text | You use this setting to define the mem­ ber display in the design panel. The default value is Default . This means that the selection made in the query designer defines the member display. You can change the parameter value to one of the listed values, for example Key .                                                                                                                                                                                                                                                                                                                                                                                                                                               | Analysis plug-in |
| TimerDialogDisplayTime = 60 (default value) or any integer value.          | With the setting TimerSetPlanQueriesToDispl ayMode , you can define the time Anal­ ysis is waiting to set planning queries from change mode to display mode. Be­ fore the switch to display mode, a dia­ log is shown to inform the user. You use this setting to specify the time in seconds the information dialog is dis­ played before the queries are set to dis­ play mode. The default value is 60 . This means that the dialog will be displayed for 60 seconds. A user can cancel the dialog and the queries stay in change mode. If the di­ alog isn't canceled, the queries will be set to display mode when the defined time is over. You can enter any integer value for this setting to define the time in seconds. | Analysis plug-in |
| Setting and Setting Value                                                           | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Available for         |
|-------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| TimerSetPlanQueriesToDispl ayMode = -1 (default value) or any in­ teger value.       | You use this setting to specify the time in minutes Analysis is waiting to set planning queries from change mode to display mode. The default value is -1 . This means that Analysis won't set planning queries to display mode. You can enter any integer value for this setting to define the time for the switch in minutes. For example, if you enter the value 5, Analysis will show a dialog after 5 minutes without navigation informing that the queries will be set to display mode. A user can cancel the dialog and the queries stays in change mode. If the di­ alog isn't canceled, the queries will be set to display mode. With the setting TimerDialogDisplayTime , you can define the time the dialog is shown before the switch. | Analysis plug-in      |
| TraceLogLevel = Debug (default value), Fatal , Error , Warn , Info , Verbose or Off | Analysis uses Apache log4net to record log and trace information. You use this setting to define the amount of log and trace information that should be stored in the log.config file. The default value is Debug . You can change the value to Fatal , Error , Warn , Info or Verbose . If you change the value to Off , no log and trace information will be stored. For more information about the values, see the Apache log4net documenta­ tion. This setting can only be maintained by an administrator in the file system un­ der C:\ProgramData\SAP\Cof .                                                                                                                                                                                   | Analysis add-in (COF) |
| Setting and Setting Value                                                    | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                           | Available for    |
|------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| TrackUsage = true (default value) or false                                   | You use this setting to define whether Usage Tracking for Analysis should be enabled. After installation, the default value is True . This means that Usage Tracking is active. If you change the parameter value to False , Usage Tracking for Analysis is deactivated.                                                                                                                                                                      | Analysis plug-in |
| TransferFilterValuesWhileA ssigningHierarchy = true or false (default value) | You use this setting to define whether filter values of a dimension are transfer­ red when a different hierarchy or a flat presentation is assigned to the dimen­ sion. The default value is False . This means that filter values will not be transferred. If you change the parameter value to True , the filter values will be transfer­ red as far as possible when flat pre­ sentation or a different hierarchy is as­ signed to a dimension. | Analysis plug-in |
| TwoFactorAuthenticationCer tificate = <certificate>                          | After the first usage of the two-factor authentication, you can see here the se­ lected certificate.                                                                                                                                                                                                                                                                                                                                           | Analysis plug-in |
| TwoFactorAuthenticationDis abled = true or false (default value)             | You can use this setting to disable the two factor authentication. The default value is False . This means that the two-factor authen­ tication is enabled as soon as a URL is available in setting TwoFactorAuthenticationUrl . If you set the value to True , the two- factor authentication is disabled and you can log on to another BI platform. You have to enter the BI platform and                                                    | Analysis plug-in |
| Setting and Setting Value                       | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Available for    |
|-------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| TwoFactorAuthenticationUrl = <URL>              | You can enter the URL of the BI plat­ form that should be used for two-factor authentication (single-sign on). If you enter a URL of a BI platform, two- factor authentication is used for logon and no logon dialog is displayed after the first usage. For the first usage, the user has to select a client certificate. If you need to log on to another BI plat­ form, you can disable the two-factor au­ thentication with setting TwoFactorAuthenticationDis abled . | Analysis plug-in |
| UndoStackSize = 10 (default value)              | You use this setting to specify the num­ ber of steps that can be undone or redone with the Analysis Undo/Redo function. The default value is 10 .                                                                                                                                                                                                                                                                                                                       | Analysis plug-in |
| UsageDataPauseDate = 01.01.0001 (default value) | This setting is used for Usage Tracking. After installation, the default value is 01.01.0001 . Werecommend not changing the value. You can deactivate Usage Tracking for Analysis with setting TrackUsage .                                                                                                                                                                                                                                                             | Analysis plug-in |
| Setting and Setting Value                                     | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Available for    |
|---------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseAdvancedHierarchySettin gs = true or false (default value) | You use this setting to activate the lay­ out improvement for hierarchies. When using hierarchies in Analysis that have hierarchy nodes that span across multiple lines (most likely structures where the elements can contain line wraps) the lines are not indented. The resulting layout of the crosstab doesn't look very pleasant. Independent form the missing indent for wrapped lines the default symbols for expanding and collapsing hierarchy nodes (also known as expander) can only be displayed as [+] and [-]. This is only relevant for hierarchical structures that have members with texts contaning a new line character (e.g. \n, \r or a combination of the two) that is displayed as a line break. You can fix the missing indent by pre­ fixing the lines after the line wrap with space characters. This will improve the layout. But note that as the text in the cell that contains the hierarchy node will be changed by this action Excel for­ mulas that reference the text might be broken. The default value is False . This means that the layout improvement is not ena­ bled. If you change the parameter value to True , the layout improvement will be enabled. | Analysis plug-in |
| Setting and Setting Value                                                             | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Available for    |
|---------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseDataSourceDeltaUpdate = true (default value) or false                              | You use this setting to specify whether only the delta data or the complete data of a data source should be reloaded and updated in Analysis. After installation, the default value is True . This means that only the delta data of the data source is updated in Analysis. If you change the parameter value to False , the complete data of the data source is reloaded to Analysis.                                                                                   | Analysis plug-in |
| UseDocumentDescriptionToCo nstructBIPDocumentFileName = true or false (default value) | You use this setting to specify whether the description or the technical name of a workbook is used to construct the file name for workbooks saved on the BI platform. The file name is shown in the Microsoft Excel title bar, for example. The default value for this setting is False . This means that the techni­ cal name is used to construct the file name. If you change the parameter value to True , the description will be used to                            | Analysis plug-in |
| UseDocumentDescriptionToCo nstructBWDocumentFileName = true (default value) or false  | You use this setting to specify whether the description or the technical name of a workbook is used to construct the file name for workbooks saved on an SAP BWplatform. The file name is shown in the Microsoft Excel title bar, for exam­ ple. The default value for this setting is True . This means that the description is used to construct the file name. If you change the parameter value to False , the technical name will be used to construct the file name. | Analysis plug-in |
| Setting and Setting Value    | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Available for    |
|------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseKeyForHierarchySelectio n | You use this setting to specify whether the selection of hierarchy variables is text-based or key-based in the prompts dialog. The default value is False . This means that selection of hierarchy variables in the dialog is text-based: • The texts are placed in the first column, the keys in the second col­ umn. • The list of available hierarchies is sorted by text. • The autocompletion of the textbox within the dropdown uses texts. If you change the parameter value to True , the selection of hierarchy varia­ bles in the dialog is key-based: • The keys are placed in the first col­ umn, the texts in the second col­ umn. • The list of available hierarchies is sorted by key. • The autocompletion of the textbox within the dropdown uses keys. | Analysis plug-in |
| Setting and Setting Value                                            | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Available for    |
|----------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseLegacyModeForFormulaCon text = true or false (default value)      | You use this setting to specify the mode for creating formulas with Table Design. When you create a formula with Table Design, only the inner dimensions de­ fining a cell are used for the context, the column and the nearest dimension member ,for example. If the dimension member appears several times in the inner dimension, the formula is applied several times in the table. In earlier Analysis versions, all dimension mem­ bers that define the context of a cell were part of the formula and not only the innermost one. The default value is False . This means that only the innermost dimension is part of the context for the formula. If you change the value to True , the earlier behavior is applied and all di­ mension members of a cell are used to define the context for the formula. | Analysis plug-in |
| UseLocalSncInfoForRemoteCo nnections = true (default value) or false | You can't maintain Secure Network Communication (SNC) information in the OLAP connections on the BI plat­ form. But Analysis can read the SNCinfor­ mation from the SAPUILandscape. You can reuse the SNCinformation for your connection if the same system is main­ tained in the OLAP connection on the BI platform and in the SAPUILandscape. To enable the reuse of the SNCinforma­ tion, the setting UseLocalSncInfoForRemoteCo nnections must be set to true. This is the default value for this setting. If you set the value to False , the reuse of the SNCinformation for OLAP con­ nections is disabled.                                                                                                                                                                                                  | Analysis plug-in |
| Setting and Setting Value                                      | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Available for    |
|----------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseNewLinesLegacyMode = true or false (default value)          | You use this setting to specify which mode for entering planning data in new lines is used. After installation, the default value is False . This means that current mode will be used for entering planning data in new lines. This mode is valid forBW systems of type SAP BW/4HANA SP8 or higher and SAP BW7.50 SP12 or higher. For former BWversions, the leg­ acy mode will be applied automatically. If you change the parameter value to True , the legacy mode will be used for data sources of all BWsystems.                                                                                                                                                                                                                                                                                                     | Analysis plug-in |
| UseOlapHanaCubeAsHanaInsta nce = true (default value) or false | In the Select Data Source dialog,HANA Cubes can be mapped to an OLAP con­ nection, instead of being mapped to the HANAtenant itself. You use this setting to specify whether you can open a HANACube mapped to an OLAP connection directly as a data source, or if you can search for further queries available in the corresponding HANAtenant. The default value for this setting is True . This means that both options are enabled: With Next , you can log on to the HANAtenant and search for further queries. With selecting OK , the cube will be inserted as a data source to the workbook. If you change the parameter value to False , you have only the option to select OK in the dialog, and theHANA cube node in the Select Data Source di­ alog will directly be inserted as a data source to the workbook. | Analysis plug-in |
| Setting and Setting Value                                         | Setting Description                                                                                                                                                                                                                                                                                                                                                                           | Available for    |
|-------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseQueryVariantsForViews = true or false (default value)          | You use this setting to specify whether you see the variants of the view or the variants of the query used for the view in the prompts dialog. The default value is False . This means that you will see the variant of the view in the prompts dialog. If you change the parameter value to True , you will see the variants of the query used for the view the prompts dialog.              | Analysis plug-in |
| UseSacLiveHostnameInBwConn ection = true or false (default value) | For SAP Analytics Cloud live data connections, Analysis downloads a launcher from the BWLive instance. This launcher may contain the host­ name/IP which is accessible only from the internal network. But Analysis can always access the URL for the BWsys­ tem from the SAP Analytics Cloud live data connection. You use this setting to specify whether the hostname from the SAP Analytics | Analysis plug-in |
| Setting and Setting Value                                | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                              | Available for    |
|----------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseSapUILandscapeComApi = tr ue or false (default value) | For Analysis versions ≤ 2.8 SP10, you can use this setting to define whether Analysis uses the SAP GUI SAPUI­ LandscapeLib to access information about system data or its own parsing logic. As of Analysis 2.8 SP11, we do not rec­ ommendchanging the default value. The default value is False . This means that Analysis uses its own parsing logic, which makes it independent from the SAP GUI version. If you change the parameter value to | Analysis plug-in |
| Setting and Setting Value                                                  | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | Available for    |
|----------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------|
| UseSeparateDisplaySettings ForFilterDialog = true or false (default value) | In Analysis, the filter dialog uses the same display settings as the crosstab when you open the filter dialog for the first time. For example, if the members of a dimension are shown as Key and Text in the crosstab and the filter dialog is opened on that dimension, the filter dialog will display the members also with Key and Text. You can change the display settings for the members in the filter dialog and if the dialog is closed and opened again later in the session it will show the last used display settings independent from what is currently set in the crosstab. But if the workbook has been saved and closed and is opened again, the filter dialog will again take the display settings from the crosstab. You use this setting to specify whether the display settings defined in the filter dialog should be saved with the work­ book. After installation, the default value is False . This means that the display settings for the filter dialog are not saved with the workbook. If you change the parameter value to True , the display settings for the filter dialog are saved with the workbook. | Analysis plug-in |
| Setting and Setting Value                                         | Setting Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Available for         |
|-------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------|
| UseSingleConnectionPerDestination = true or false (default value) | You use this setting to specify whether only one connection per backend sys­ tem should be established in the follow­ ing scenario: • You use two or more data sources of the same backend system in your workbook. • The workbook property Merge Variables on the Components tab is selected. • A hierarchy node variable is used in the data sources having merged variables applied. The default value is False . This means that a separate connection is estab­ lished for each data source, targeting the same backend system. This could cause program errors while executing client side variable merging. If you set the parameter value to True , only one connection per backend sys­ tem will be established, and the variable merging can be successfully executed on the server side | Analysis plug-in      |
| UseUnicodeCodepageInNco = True or False (default value)           | You use this setting to specify whether a password for an ABAP system may contain special characters such as €. The default value is False . This means that special character ares not sup­ ported. If you change the parameter value to True , special characters are sup­ ported. You should only set the setting to True if all your ABAP systems use UniCode.                                                                                                                                                                                                                                                                                                                                                                                                                               | Analysis add-in (COF) |
*Please note: Analysis, edition for SAP Analytics Cloud, does not include the BPC plug-in. Therefore, you don't see these settings when using the SAP Analytics Cloud edition.