Settings for the Analysis Plug-in
The following tables describe the Analysis Plug-in file system settings that you can define. The settings are delivered in the Ao_app.config file.
For more information about maintaining file system settings, see To Maintain Settings in the File System
| Setting and Setting Values | Setting Description |
|---|---|
| BOESystems | This setting contains the configuration to the Business Intelligence Platform. For more information, see To define a system connection to SAP BusinessObjects Business Intelligence. |
| RetrieveMultilingualTexts= true (default value) or false | On the BI platform, the name and description 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. |
| DefaultLauncherScheme= "" (default value) or https | You use this setting to specify the launcher scheme. The launcher scheme can be
http or https.
After the installation, no value is defined "". This means that http is used as the default launcher scheme. If you want to use https as the scheme, you can change the value here. |
| Setting and Setting Values | Setting Description |
|---|---|
| PreferredPlatform= 0 (default value), 1, 2 or 3 | You use this setting to define the preferred platform for your
Analysis installation. 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 NetWeaver is enabled as platform. With parameter value 3, the SAP BusinessObjects Business Intelligence Platform with compatibility mode is enabled. This means that the workbook is saved as Analysis Workbook (Compatibility Mode). The Analysis Workbook (Compatibility Mode) object corresponds to the Microsoft Excel object used with former BI platform releases. |
| EnablePreferredPlatformSetting= 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 settings dialog box.
After installation, the default value is True . This means that the preferred platform section is visible in the platform 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 platform. The user is therefore unable to change the preferred platform defined in the Preferred Platform setting. |
| SupportsSaveAs1x=true or false (default value) | You use this setting to define whether a workbook could be saved with
1.x format in Analysis 2.x versions.. The default value is False. This means that it is not possible to save a workbook 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 Analysis. |
| RecentListSize= greater or equal 1, default value = 10 | This setting defines the number of entries in the list of last opened
data sources 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. |
| ResultSetSizeLimit = -1, n or empty (default) | This setting defines the maximum number 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 displays.
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 with this value. If you set the parameter to -1, the setting uses the values defined in the BW system. In a BW system, the parameter is set in the RSADMIN table for object BICS_DA_RESULT_SET_LIMIT_MAX. |
| 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 system messages will be displayed. If you change the value to true, back-end system messages will not be displayed. |
| RfcBundling= true (default value) or false | This setting is recommended when working in an WAN
environment to reduce network traffic. After installation, the default value is True. |
| MaxNumberOfParallelThreads= 10 (default value) or any integer value | You use this setting to define the maximum number of parallel threads
that Analysis can use to open the SAP HANA data sources of a
workbook. The default value is 10. This means that up to 10 SAP HANA data 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. |
| 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 dialog in Analysis. |
| 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. |
| IgnoreQueryDesignerVersionCheck=true or false (default value) | You use this setting to define if the query designer version on the
machine should be checked. The default value for this setting is False. This means that the query designer version will be checked. The Setting Show 'Launch Query Designer' in Tools Group in the user settings is only selectable if the correct query designer version is installed. If you change the parameter value to True, the query designer version will not be checked and the setting Show 'Launch Query Designer' in Tools Group is always selectable. |
| AllowChangingAccessMode= true (default value) or false | You use this setting to specify whether the access mode for member
display should be enabled. After installation, the default value is True. This means that the access mode is enabled for the member display definition in the crosstab and for the Filter by Member dialog box. If you change the parameter value to False, the access mode option is not displayed in the menu. |
| Setting and Setting Values | Setting Description |
|---|---|
| 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 selecting 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. |
| PrompWhenInsertingDataSource= true (default value) or false | You use this setting to define the behavior of the
prompting dialog box when inserting a new data source. After installation, the default value is True. This means that the prompting dialog box always appears automatically 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 variables. |
| DisplayCompoundAsKeys= true or false (default value) | You use this setting to define the display of
variables in the summary view of the prompting dialog box. The default value is False. This means that the variables are displayed as display strings. For compound characteristics, the display string may not be unique. To display compound characteristics with the key instead of the display string, you can set the parameter value to True. |
| OperatorContainsPattern= true or false (default value) | You use this setting to define whether the operator Contains Pattern (*
Contains Pattern / !* Excludes Pattern) should be enabled for
prompting. The default value is False. This means that the operator Contains Pattern cannot be used for prompting. To enable the contains pattern operator for prompting, you can set the parameter value to True. |
| PreferLeavesOverNodesInInputString= 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. |
| ShowDSVariantsForWorkbooksWithOneDS= true or false (default value) | You use this setting to specify the mode for the prompting dialog when
you open a document from the NetWeaver server 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.. |
| Setting and Setting Values | Setting Description |
|---|---|
| TextKeyDisplay= Default (default value), TextKey, KeyText, Key or Text | You use this setting to define the member display in the crosstab. 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. |
| 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. |
| MessagePopupSeverity= "" (default 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 category, Success is the least severe. The severity Success corresponds to severity Information in Analysis. The default value is "". This means that after the installation no value is defined 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. |
| ForceRefreshConnectionInfo= true or false (default value) | You use this setting to specify whether the SNC (Secure Network Communications)
information is read from the launcher file or from the local
saplogon.ini installation. The default value is False. This means that the SNC information is read from the launcher file. If you change the parameter value to True, only the SNC information in the local saplogon.ini is used.. Therefore we do not recommend changing this setting to value True. |
| Setting and Setting Values | Setting Description |
|---|---|
| FetchMemberLimit= 1000 (default value) or any integer value | You use this setting to define the maximum number of members displayed in the
Filter by Member dialog box for
selection. If you filter on a dimension that contains more members
than defined 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 displayed. You can enter any integer value for this setting. You can also define the maximum number of members in the user settings in Analysis. |
| 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 maximum 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. |
| PropagateSelectionInStructures= true or false (default value) | You use this setting to define the behavior of hierarchical structures in the filter
dialog box. In characteristic hierarchies the selection 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, hierarchical structures will behave like characteristic hierarchies in the filter dialog box. |
| Setting and Setting Values | Setting Description |
|---|---|
| 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 crosstab. You can enter any integer value for this setting. |
| 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. |
| InputReadyCellsValueHelpMemberAccessMode= P | You use this setting to specify the member access mode (value help) for input-ready
cells. The default value is P (Planning). For more information on the existing modes, see
2180059 |
| Setting and Setting Values | Setting Description |
|---|---|
| DefaultWorkbookPath= path to default workbook in directory. | Use this setting to define the path to the default workbook in the directory. |
| DocumentCacheFolderPath= "" (default value) | You use this setting to overwrite the default cache directory path. Analysis workbooks are saved to the directory 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 adding paths to Trusted Location which points to a directory beneath the users Temp directory whenever working with MS Office 2010 or higher. If you want to overwrite the default cache directory path, you can enter a path here. |
| IsCachingDocuments= true (default 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 active. If you change the parameter value to False, the function is disabled and caching cannot be used. |
| Setting and Setting Values | Setting Description |
|---|---|
| ShowConversionWizard= true or false (default value) | You use this setting to specify whether the conversion of BEx workbooks should be
enabled. After installation, the default value is False . This means the conversion is not enabled. |
| 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 displayed after conversion. |
| 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 objects 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 sources are converted. |
| LogType= 0 (default value), 1 or 2 | You use this setting to define whether a log
should be created during conversion. The default value for this
parameter 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 workbook sheet. If you set the value to 2, a log is created and stored on a hidden workbook sheet. |
| 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 parameter 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 corresponding properties are selected on the components tab in the design panel. |
| EnableWorkbookConversion= true (default value) or false | You use this setting to define whether conversion
of BEx workbooks should be enabled. After installation, the default value is True. This means that workbook conversion is enabled, and the menu entry and conversion settings in the platform settings dialog are visible in Analysis. If you change the parameter value to False, the menu entry and conversion settings are hidden, and the user is not able to convert BEx workbooks. |
| Setting and Setting Values | Setting Description |
|---|---|
| EnableWorkspaces= true (default value) or false | You use this setting to define whether the
workspace options should be enabled. After installation, the default value is True. This means that the workspace options are enabled and the menu entries are visible in the ribbon. If you change the parameter value to False, the menu entries are not displayed in the ribbon, and the user is not able to use the workspace options. |
| Setting and Setting Values | Setting Description |
|---|---|
| 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 Support Settings. |
| Profiling= true or false (default value) | You use this setting to activate the query runtime statistics of
SAP NetWeaver BW. For more information, see Query runtime statistics. You can also activate the setting in the Support Settings dialog with setting Enable Workbook Profiling. For more information, see Support Settings. |
| SupportAutomatedOffice= true or false (default value) | You use this setting to specify whether the Analysis Plug-in shoud be
supported 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 supported. If you change the parameter value to True, the Analysis Plug-in will be supported. This setting is only evaluated if you set SupportEmbeddedMode in the Cof_app.config file to True. |
| ShowPlanningToolbar= true (default value) or false | You use this setting to specify whether the planning group should be
displayed in the ribbon. After installation, the default value is True. This means that the planning group displays in the ribbon. If you change the parameter value to False, the planning group is not displayed in the ribbon. |
| AbapTrace= 1 or 0 (default value) | You use this setting to activate the trace tool environment of
SAP NetWeaver 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 BW Server Tracing. For more information, see Support Settings. |
| NcoTraceLevel= 0 (default value), 1, 2, 3 or 4 | You use this setting to specify a default level for NCO Tracing. The default value is 0, meaning that it is deactivated. With a value of 1, 2,3 or 4, you can activate this setting. Level 4 is the most detailed one. For more information, see Support Settings |
| UndoStackSize= 10 (default value) | You use this setting to specify the number of steps that can be undone or redone with
the Analysis
Undo/Redo function. The default value is 10. |
| ShowConvertToForumulaInToolsGroup= true (default value) or false | You use this setting to specify whether the Convert To
Formula icon should be displayed in the ribbon tools
group. After installation, the default value is True . This means that the icon displays in the ribbon. If you change the parameter value to False, the icon does not display in the ribbon. |
| ShowCreateWebApplicationInToolsGroup= true or false (default value) | You use this setting to specify whether the Create Web
Application icon should be displayed in the ribbon
tools group. The setting is selectable only if an SAP
BusinessObjects Design Studio with a minimum release
version of 1.1 is installed. After installation, the default value is False . This means that the icon does not display in the ribbon. If you change the parameter value to True, the icon displays in the ribbon. |
| ShowSsoLogonDialog= true or false (default value) | You use this setting to specify whether the Logon dialog box
should be displayed when using SSO with the SAP NetWeaver platform.
The default value is False. This means that the logon dialog box is not displayed. 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 Advanced Settings dialog in Analysis. |
| Setting and Setting Values | Setting Description |
|---|---|
| FormulaExpressionValidationInterval= 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 number 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. |
| Setting and Setting Values | Setting Description |
|---|---|
| TaskPaneDockPosition= 1 (default 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 right, to 3 to insert it on the top, or to 4 to insert it at the bottom. If you change the parameter to 0, the design panel is free-floating. |
| 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. |
| 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. |
| Setting and Setting Values | Setting Description |
|---|---|
| SetFilterComponentApplyToAllDataSources= true(default value) or false | In Analysis, you can insert a filter component using the ribbon. If
your workbook 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 applied to all data sources. If you change the parameter value to False, the filter will only be applied to the selected data source. |
| Setting and Setting Values | Setting Description |
|---|---|
| ShowAllHierarchies= true(default value) or false | You use this setting to specify whether all time-dependent hierarchies
for a dimension should be available in the design 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. |
| Setting and Setting Values | Setting Description |
|---|---|
| NrOfSingleCellsInContext= greater or equal 1, default value = 100 | This setting defines the maximum number of crosstab cells that can be
selected to execute analysis options, for example filtering. If more
cells are selected in a crosstab, the analysis options are
disabled. The default value is 100. |
| EnableDoubleClick= true (default 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. |
A waterfall chart is a specialized type of bar chart. The start and end values are always displayed in a column as totals. The individual interim values are not displayed as subtotals, but as delta values. You can use the following settings to define colors for displaying the three types of values.
| Setting and Setting Values | Setting Description |
|---|---|
| RGBValueColumns= #808080 (default 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. |
| 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. |
| 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. |
In Analysis, edition for Microsoft PowerPoint, you can insert data sources as tables. You can use the following settings to define default numbers for rows and columns. You can change the number of rows in the Fit Table dialog in Analysis.
| Setting and Setting Values | Setting Description |
|---|---|
| LinesOfData= 12 (default value) | You use this setting to define the default number of rows. After installation, the default value is 12. |
| ColumnsOfData= 12 (default value) | You use this setting to define the default number of columns. After installation, the default value is 12. |