<p>about your learning experience to help us improve.</p>

You've completed

cleanFiles/bookmap_Optimizing_Performance_in_SAP_Analytics_Cl_en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2025-03-06T14:23:04.000Z

Analyzing Scripting Performance

<div id="content"><div class="parentsection"><div class="section"><p tabindex="0">In this lesson, we will analyze scripting performance in two SAP Analytics Cloud stories using the <i>Performance Insights</i> tool and the Performance tab in the browser developer tools.</p><p tabindex="0">We analyze the story performance using the <i>Loading Sequence</i> tab of the <i>Performance Insights</i> tool, where we see the names of the story processes and the time it takes them to run.</p><p tabindex="0">Then, we gain additional perspective using the developer tools, where we look at the <i>Performance</i> tab to visualize the communication between the Main thread and the SandboxWorker thread in the story.</p><div class="kalturaVideoLessonWrapper"><div aria-label="" class="kalturaVideoLessonContainer" data-testid="video" id="1_411hhonk"></div></div></div></div></div>

Analyze Script Performance

Managing Performance in SAP Analytics Cloud

Analyzing Script Performance

You have a story with two scripts that execute the same action, however, the performance for one is significantly worse than the other. In this video, we will use two different tools to analyze script performance. You run the first script and notice that the data takes a long time to appear. On top of that, the user is not given an indication if the process is running or not. You run the second script and the data appears almost immediately. The scripts select all the products in Category B and display the records. Let's look at how each of the scripts perform. First, we'll look at the Performance Insights tool in SAP Analytics Cloud. To analyze and compare the performance of the scripts using this tool, you must activate the Performance Analysis mode. You can do that by choosing the Analyze Story Performance in View Time option in the menu. It restarts the story, and you can tell that the mode is on, as you see the Performance Insights button in the toolbar on the right. You run the scripts again for the tool to record their performance and click the Performance Insights button to open the Performance Insights dialog. In the Loading Sequence tab, you can see the names of the story processes and the time it takes them to run. The processes are color coded in the final report. To see how the scripts performed, focus on the processes that are shown with green bars. You can see that it only took the optimized script 33 milliseconds to complete, whereas the long running one was executed within 20 seconds. You can gain additional perspective using the developer tools of your browser. We'll look at the Performance tab to visualize the communication between the main thread and and the SandboxWorker thread. Start by activating performance tracking by clicking the record button. Launch the scripts you'd like to analyze. Here you can find both the Main thread and the SandboxWorker thread. And check how the two processes work together. This busy view with hundreds of colored boxes indicates that the script requires a lot of communication between the Main and the SandboxWorker threads as they work through the code. When you optimize the script and run the performance trace again, you see that there are almost no colored boxes, meaning there was minimum communication between the threads. This is the main reason why this script was executed so fast.