Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
This blog describes how to configure SAP Analysis for Microsoft Office to use only BI Platform as preferred platform.

All these settings are executed with administrator permissions and cannot be changed by user without administrator rights.


  1. Search for Analysis Office



  1. Open Analysis Office as Administrator


  1. Open the Technical Configuration menu in Analysis Office


  1. Search for “prefer

Search for “prefer” to find all settings to define preferred platform.


  1. Set the following parameters:

  • PreferredPlatform = 1 (BI Platform)

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.


  • EnablePreferredPlatform = 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.


  • Set both parameters to configuration level “PerMachine”

Define if a user should be able to change a setting locally. In the configSections area, each setting has a configuration level defined. The default level is UserRoaming. This means that a user change the setting locally. If you change the configuration level to PerMachine, the setting can no longer be changed by a user locally.

After the configuration changes, the user is not able to change these settings; the options are greyed out and there is no possibility to change any entries.



Now if the user wants to insert a data source, he has to logon to the BI Platform, there is no possibility to skip this option.


Before the changes, the user had the possibility to skip the logon to the BI Platform:


  1. Please see documentation for more information on settings.

  2. For distributing the configuration files via SAPSetup, please see the documentation.