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.
- Styles
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”
- Settings
Merge Prompts: Enable. Combines together if the same prompt is present in multiple data sources. Keeps prompt screen uncluttered.
