Skip to Content
Author's profile photo Former Member

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.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.