cancel
Showing results for 
Search instead for 
Did you mean: 

Default user profile in Analysis for Office with Custom Profile & not allowing them to change?

kumar_kesireddy
Explorer
0 Kudos
1,594

Analysis for Office version 2.8

I have tried following the steps provided in the User Guide on page no. 241 and 242 to default a custom profile without allowing the users to change. I have attached the screenshots from the user guide that I followed. The syntax that I used is as follows.

<!--default of 'AppBuilderDefaultProfilePath': value="C:\Users\Kumar\AppData\Roaming\SAP\Cof\User Interface\End User Profile" -->

<AppBuilderDefaultProfilePath /> <!--default of 'AppBuilderExcelDefaultCompanyProfilePath': value="C:\Users\Kumar\AppData\Roaming\SAP\Cof\User Interface\End User Profile" -->

<AppBuilderExcelDefaultCompanyProfilePath /> <!--default of 'AppBuilderPptDefaultCompanyProfilePath': value="C:\Users\Kumar\AppData\Roaming\SAP\Cof\User Interface\End User Profile" -->

Also did the below to not let end user change or customize the profile:

I changed the below from True to False

<AppBuilderWrdDefaultProfilePath /> <!--default of 'CanCustomizeUserInterface': value="False" -->

But had no luck with this. Could anyone please help in telling what I'm missing here?

Thanks for your time in advance!

MK

View Entire Topic
henrikbaumann
Explorer
0 Kudos

Hi Mithun

The Ao_app.config and Cof_app.config stored in C:\ProgramData\SAP\Cof requires admin access to edit. If your users has that, you cannot prevent them from edit those files as well as the profile.

If your users don't have admin rights to those files, you can restrict the from doing changes through the Excel interface by the following:

Each of the settings, e.g. <AppBuilderDefaultProfilePath/> has a corresponding line in the top of the file named

<section name="AppBuilderDefaultProfilePath" type="String" configurationLevel="UserRoaming" />

Change UserRoaming to PerMachine and the users will no longer be able to edit that setting without having admin rights. You would need to do this for all the settings you want to restrict.

kumar_kesireddy
Explorer
0 Kudos

Hi Henrik,

Thanks for reaching out. Even after changing from UserRoaming to PerMachine the user is able to create a new profile and when opening the Analysis for Office it opens with Standard Profile and not the one we are giving.

Attached is the complete cof config file for reference.

cof.txt

Thanks again for your time!

MK

henrikbaumann
Explorer

Hi Mithun

The file you attached, I suppose is a copy? The real one needs to be named Cof_app.config and stored in C:\ProgramData\SAP\Cof

I believe the settings required for your setup are AppBuilderCompanyProfileDirectory, AppBuilderDefaultProfilePath and CanCustomizeUserInterface. They should have the "PerMachine" value in the configSections of the file. In the lower part of the file, they should have something like below:

<AppBuilderCompanyProfileDirectory value="C:\ProgramData\SAP\Cof\User Interface" />
<AppBuilderDefaultProfilePath value="C:\ProgramData\SAP\Cof\User Interface\[NameOfFile].xml" />
<CanCustomizeUserInterface value="True" />

Notice that in your file, CanCustomizeUserInterface contains a ":" - that should be removed. Also, your file should not contain any references to the AppData folders, but reference files stored within C:\ProgramData\SAP\Cof

The above settings should ensure that you cannot edit the profile or create one yourself, unless you have admin access to the files.

BR Henrik

kumar_kesireddy
Explorer
0 Kudos

Thanks Henrik! It worked 🙂