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

[kumar_kesireddy]

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

[henrikbaumann · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Thanks Henrik! It worked 🙂

[shivakrishnaj]

Hi Mithun,
What I observed in your given information you add value in the default commented line.
i.e <! ...> this indicates this information in commented in XML syntax.
Try to change your value as shown below example.

<!--default of 'AppBuilderDefaultProfilePath': value="" --> // this is default line which is commented
<AppBuilderDefaultProfilePath value="your_path"/> // here give your values.

Once the AO configuration files are updated.
Open AO with run as admin
From the Technical configuration browser, we can cross-check updated configuration information taken by AO or not

Thanks & Regards,
Shiva

[kumar_kesireddy]

Hi Shiva,

Thanks for reaching out. We did realize that and did removed the !-- and after looking at your script I even removed the ' '. So the script looks like this

<AppBuilderDefaultProfilePath value="C:\Users\Kumar\AppData\Roaming\SAP\Cof\User Interface\End User Profile.xml" />

<!--default of 'AppBuilderExcelDefaultCompanyProfilePath': value="" -->

<AppBuilderExcelDefaultCompanyProfilePath value="C:\Users\Kumar\AppData\Roaming\SAP\Cof\User Interface\End User Profile.xml"/>

<AppBuilderPptDefaultCompanyProfilePath value="C:\Users\Kumar\AppData\Roaming\SAP\Cof\User Interface\End User Profile.xml"/>

and

<CanCustomizeUserInterface: value="False" />

and opened the application with "Run as Administrator". Unfortunately no luck. I can still see the Standard profile and I'm able to create new profile and can default a different profile as well.

Thanks again for your time!

MK