SAP Analysis for Office is one of the top thick client tools in SAP BI Suit. As it resides in client local machine configuring the application and maintaining is bit difficult for Administrators. Here are some tips that are useful for administrators to setup AO.
AO settings are maintained in file system of client machine. In earlier versions of AO (1.x) these are maintained in system registry.
These settings are useful for Admins to define default configurations for users.
Apply Same settings for all users
Customized settings will be stored in .xml file. By copying over .xml file and “Cof_user_roaming.config” files same settings can be applied to other users.
.xml file will be located under “C:\Users\
BOBJ systems can be defined from “BOESystems” parameter located in file “Ao_user_roaming.config” .
System ID : Unique ID. Can use CMS Name
System Name : DEV or QA or PROD
Host Name : CMS Name
Port : Web server port (8080)
Protocol : http
SessionServiceUrl : dswsbobje/services/Session
After defining the settings relaunch AO. In BOBJ system defined values will be populated. We can add multiple systems by duplicating xml node from
Most common error users will be facing is number cells returned to cross tab. By default AO returns 500000 cells.
This parameter can be changed in “Ao_user_roaming.config” located under “C:\Users\
Check for parameter ResultSetSizeLimit. If it doesn’t exit add the parameter to the desired value.If parameter value as -1 then BW max cell limit will be applied.
Datetime values displayed in AO workbooks uses source datetime format by default. To display Excel format date update “EnableNativeFormatting” value to True.
Time displayed in Workbook are local machine time zone. To display UTC time update “ShowUtcTimeStampsInDataCells” value to true.
Troubleshooting of Analysis Office issues can be done by enabling the logging mode from AO workbook. Three types tracing is available in AO - “Support Mode”, “Profiling Mode” & “Advanced Mode” .
To enable tracing launch Analysis Office > File > Analysis.
Click on “Troubleshoot” you will see three different options.
Click “Advanced Mode”. In this mode we can define what types of logs we would like to capture. We can change the Log file location from General tab
BW tracing, NCO tracing and CPIC tracing can be enabled from “Analysis” tab. Once enable click OK and relaunch Analysis Office. Logs will be created under the folder defined earlier.