Performance handling tips in Analysis for Office
- Common refresh
It is recommended to choose Refresh all when multiple data sources are used in a workbook. This prevents from occurrence of data irregularity.
- Sheet by Sheet choice
The type of sheets Non-COF is not checked by the Analysis Add-In which will improve performance. This is helpful in case of analysis reports which does not involve calculations on it.
Large number of style set usage would lead to poor performance.
When inserted a new cross tab in a workbook, the styles in the current default style set are used to format the cross tab cells.
- Check Profiling statistics
Track performance of a workbook for every step that has been performed in an attempt to increase performance. Statistics can be traced with respect to workbook as well as Client.
- Log Severity to “Support“
Settings –>Support settings
The system writes the trace information to the log file until the file reaches the maximum size of 2048 KB. The log file can be PC-specific (per installation) or user-specific, depending on the folder path in the file system.
The “Debugging Information” is the most detailed LOG file and will help SAP product support to analyse Analysis for Office incidents.
- Message handling
Use below option to record messages.
Backend (normally BW) and Analysis for Office are able to throw messages. The different type of messages- Information, Warning, Error and Critical.
Messages can be opened via “Help –> Show Messages”
Merge Prompts: Enable. Combines together if the same prompt is present in multiple data sources. Keeps prompt screen uncluttered.