Analysis Office Hide Customize User Interface

In this thread on blogs.sap.com, Michael Hamm asked how to hide or deactivate the Customize User Interface button. At first, at the moment SAP doesn't offer any checkbox which you can check and uncheck in the settings.

But there is a solution how you can hide or deactivate the Customize User Interface button. It is called MinorVersion. The official admin guide define MinorVersion like this:

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.

The setting can only be maintained by an administrator and you find it in the file system under C:\ProgramData\SAP\Cof. If you set the value to 3, you can see how the Analysis Office Menu Change.

As you can see the Customize User Interface is gone but also the Protect Workbook functionality. So you have to decide if you need the protection or not. At my first review I didn't found other functions which are not available any more. I hope SAP will release parameters for the file system, so everybody can decide what the user can see and what not.

These posts might also be interesting:

• Settings for the Analysis Office Plug-in
• Analysis Office Get Calendar Week for SAPSetFilter
• Analysis Office 2.4 SP2 is released
• Analysis Office 2.5 - Technical Configuration

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.