Best Practices for Maximized SAC Performance
Updated: Apr 7, 2021
Imagine you’ve built a fantastic story in SAP Analytics Cloud (SAC) and you know it’s going significantly impact your company’s reporting. But when it comes time to load and interact with the story, you realize it’s not quite as fast nor as efficient as you need it to be. Not to worry! In this blog, you’ll learn a few tips and tricks to help you optimize the performance of your stories in SAC.
Limit Visualizations per Page
A good rule of thumb for an optimal number of visualizations per page is six. This is due to the fact that your browser renders six visualizations at a time – so more than six will render separately. Aside from the technical point of view, limiting the number of visuals helps optimize the user interface experience. Showing fewer charts on a single page enables viewers to create and tell a more coherent and concise story. This is why it’s critical to focus on targeting information and visualizations to optimize performance and usability.
Utilize hyperlinks and Explorer Mode to Show Additional Details
A way to include additional information without needing to add separate visuals is to take advantage of chart/table add-ons. These include hyperlinks, explorer views, and hierarchies. Here’s how you can utilize these features:
You can add hyperlinks to any chart or table. These hyperlinks can then link to different pages or stories that contain even more information. You can also enable hyperlinks to create a filter on the new page/story based on what is selected by the user in the chart or table. There is enormous flexibility and potential here to have the ability to show additional information beyond a single page.
These are additional views of a given visualization that can be accessible to the user as needed. For example, you may have a group of individuals looking at a report that breaks revenue down by company code. However, a handful of those individuals may prefer to see revenue by product – you could create an additional view of the chart that shows this with explorer mode. It then is attached to the original chart and is only one-click away for those who need it, but it is not always visible on the page – so does not affect performance. This option also has significant potential and flexibility for how you want to utilize it.
Limit Amount of Data in a Single Visualization
As tempting as it is to show large amounts of data in a single visualization, it’s more beneficial to create targeted approaches with the option to expand on data as needed. Two quick and easy ways to achieve this are through hierarchies and showing the top n.
You can always show data at the highest level of a hierarchy with the ability to drill down further as needed. For example, showing sales volume by product groups. Instead of starting out with a chart showing all of the individual products, you could show the highest product groups with the ability for users to drill down into more specific products as needed within the story.
Within a given chart, you have the option to show the “Top N” of values, rather than loading all of them at once. Following on our previous example, you may just want to show the top 10 products with the highest sales revenue. Again, this option has flexibility – in that you can set a default top n number but also enable the user to adjust that as needed. This can limit to showing the most relevant data without the need to load too much into a single visualization.
Optimize Tables Using Beta Tables
Tables are a type of visualization that, by their nature, contain a lot of data. This can create an inherent need to make them perform as optimally as possible so that you aren’t waiting for large amounts of data to load. If you have a large table, a best practice is to utilize SAC’s Beta Table option. One main difference with beta tables is that they load the rows that are visual first and then load additional rows as you scroll through the table – creating a much faster performance time. Additionally, this table type makes it much faster to utilize in-chart tables – which can be a great way to combine types of data tools within one visualization.
These are just several tricks to creating high performing stories within the functionality-packed SAP Analytics Cloud solution. Want to learn more about how to optimize your stories? Check out our individual and corporate SAC learning offerings or contact us today to see how APU can empower you and your users to take advantage of all of the capabilities that SAC has to offer!
About the Author: Kate Mumma
Kate Mumma is a Consultant on the Experts as a Service team at Analysis Prime focusing on SAP Analytics Cloud. She works as a trusted advisor to multiple clients in the realms of business intelligence, data visualization, and model architecture. She has also worked with Analysis Prime University to sculpt interactive lessons and best in class content. In her free time, Kate is an ambitious world traveler and enjoys running and CrossFit in order to train for obstacle course races