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.

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Robbert Boon

    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

    (0) 
    1. Sowjanya BNK 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.

      (0) 
      1. Nitin Choudhari

        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.
        (0) 
    1. 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

       

      (0) 

Leave a Reply