Skip to Content
Author's profile photo Former Member

Check Profiling statistics in Analysis for Office to improve performance

With AO 2.3 updated versions, tracking performance of a workbook for every step that has been performed is made much easier. Statistics can be traced with respect to workbook as well as Client.

1. Go to settings in order to enable profiling statistics.


     File –> Analysis –> Settings –> Support

enable.PNG

2. Refresh the workbook to track statistics. Click on messages.

Profiling.PNG

3. Click on the below options to view profiling statistics.

Client profiling.PNG  Profiling statistics.PNG

This helps in tracking steps accurately and in detail to analyze the delayed performance of a workbook.

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Varun Anand
      Varun Anand

      Nice article !

      Author's profile photo Former Member
      Former Member

      Many Thanks Sowjanya,

      Should this also work for Analysis 2.2?

      I followed the same steps but the button is greyed out.

      Please let me know.

      Thanks,

      Rob

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Robbert,

      I have not checked with 2.2 version, Can you please check if you have enabled it in settings --> Support .

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Robbert,

      I have just check with the earlier versions, which provide summarized profiling statistics unlike latest version does. Below are the screenshots.

      22.PNG

      11.PNG

      Thanks.

      Author's profile photo Former Member
      Former Member

      Actually it is possible in AO 2.2, but requires modifying the registry as below.

      • From the Windows start menu, locate the program called “Run”
      • Click on the “Run” program to launch it
      • Type in “regedit” and click ok
      • If it asks if you want User Account Control, say “Yes”.
      • This will launch the Registry Editor.  Open the key (folder) called HKEY_CURRENT_USER.
      • Within that key, open the key Software
      • Within that key, open the key SAP
      • Now, right-click on SAP and select New --> Key
      • Name the new Key “AdvancedAnalysis”
      • Right-click on AdvancedAnalysis and create a New Key and name it “Setting”
      • Right-click on Setting and create a new key and name it “Utilities”
      • Click on Utilities
      • In the right-hand pane, right-click and select New --> String Value
      • Name the new string value “ClientProfiling”
      • Right-click on ClientProfiling and select Modify
      • Under Value data, type “True”
      • You have created a new registry key under \HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Setting\Utilities called ClientProfiling and you have set it to True.  Click OK and you can close the registry editor.
      Author's profile photo David Jones
      David Jones

      Hi,

       

      Does this work for AO on top of HANA Base? Messages is greyed out for me.

       

       

      Thanks,

      DJ

      Author's profile photo Moritz Kelm
      Moritz Kelm

      Dear David,

      it should work. You might need to set the Log Severity to "Support" and Restart Analysis. Then the small arrow next to "Messages" will appear after you refreshed the data.

      Best regards

       

      Author's profile photo Former Member
      Former Member

      Hi,

      Is there any way that I can get stats of list of AO reports(Multiple Reports) that I have in my system by periodically instead each report .

      Thanks

      Lavanya