SAP Analytics Cloud – Private Versions Statistics and Analysis

Update! Wave 2023.08 and 2023.Q2

Welcome to the next chapter in Private Version Analysis in your SAP Analytics Cloud (SAC) Tenant.

Planning processes often involve processing and storing large amounts of data. The new version of this content to analyze the version sizes helps you to optimize resource usage and prevent unnecessary memory consumption. By tracking version sizes, you can identify and address data growth patterns, optimize housekeeping, and implement data archiving or purging strategies to ensure efficient storage utilization.

On the overview page, we present an overview of the currently active versions and their respective sizes, along with a time series analysis of version growth over time.

Below these charts, you will find two tables that provide additional details on selected dates and models, including information on the number of versions per model and their respective owners, for a comprehensive understanding of the data. This information helps you to address housekeeping tasks.

The analysis page facilitates the detection of planning cycles and identification of dates with high volumes of versions or large versions created. The tables located below the chart provide insights into how the version sizes are concluded, aiding in a deeper understanding of the data.

Private Versions Statistics and Analysis will be general available with Wave 2022.21 and 2022.Q4 QRC Release.

How will it be deployed?

It will be deployed automatically into the side navigation under System > Performance.

It will also be deployed automatically into Files > System > Common > SAC Content.

Alongside with the Story you will find the underlying Model VERSION_STATISTICS_BASE.

What is the purpose of the Private Versions Statistics and Analysis?

As part of the ongoing project SAC Content which helps administrators to answer various questions in regards to performance, housekeeping, usage and many more we introduce the new Story Private Versions Statistics and Analysis. It helps administrators and support to get an overview of the private versions that have been created in the SAP Analytics Cloud Tenant.

Please check the existing content for the big picture and learn how you can use the content:

SAP Analytics Cloud Performance Benchmark

SAP Analytics Cloud – Administration Cockpit

SAP Analytics Cloud Performance Statistics and Analysis

SAP Analytics Cloud Performance Analysis Tool

SAP Analytics Cloud Backend Error Messages

SAC Data Management Jobs Statistics and Analysis

The information helps the administrators in both performance and housekeeping.

Performance:

It aims to address potential performance issues caused by users who are currently working with planning models. We want to highlight the biggest models that are currently in use. This information enables you to make version creators aware of their versions size and the potential high memory consumption they might cause.

Example:

If a public version is in edit mode, a private version will also be created that allows you modify the data without interfering with the original version until it has been saved and thus, published. This edit mode suggests you work on the public data directly but you’re working on a copy, a private version of the data container that is only visible for you. It is called “public edit mode”. This kind of private versions created invisible during a public edit mode are known sources for potentially high memory consumption and expensive query processing because of the big amount of data. Whenever a user edits a public version, the whole data in the model is copied into an internal private version since the whole dataset needs to be prepared for potential modification. This is a common root cause for very big private versions.

To avoid this, we introduced the concept of planning areas last year. Please check the following blog post to check if you can apply it in your scenarios:

help.sap.com – Planning on Public Versions

help.sap.com – Optimize Planning Models Using the Planning Area

Blog – Introduction to the planning area optimization for SAP Analytics Cloud/

The new Private Versions Statistics and Analysis help you to identify the scenario above and other large versions.

Housekeeping:

This content will be extended with the next releases. Please stay tuned.