Wednesday, March 13, 2019

Managing settings of AfO

Settings or configuration of Analysis for Office (AfO) was done via adjusting an registry settings for AfO of version 1.x in a client machine. However, this was changed and as of version, 2.x the configuration of the AfO tool can be done via maintaining XML configuration files. There are the config files available for Administrator and regular user. There are 2 files available for each of user:

Files for administrator are located in folder: %PROGRAMDATA%\Sap\Cof

And for user in folder: %APPDATA%\Sap\Cof

Another way to access the settings is via Excel menu File -> Analysis -> Customize Analysis -> Technical Configuration.

More info:
2083067 - How to maintain settings for Analysis Office 2.x

No comments: