Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Former Member

  • 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.

Labels in this area