Data and Performance

The Data and Performance section includes a variety of settings to help optimize your model performance.

Optimize Story Building Performance

Switch on this option to stop the automatic update that happens when changes are made in a chart or table. This reduces the load on the system and improves performance.

Variable Dependent Hierarchies

Switch on this option if the hierarchies in your SAP HANA live data models depend on variables. When enabled, this allows the levels of the parent-child hierarchies to be reloaded after each variable submit. The levels change if the variable values are changed.

When this option isn't enabled, the levels of the parent-child hierarchies are only loaded when you first load the story.

Optimize Performance for Two-Structure Queries

Switch on this option to optimize performance by consuming a limited set of metadata for live models based on SAP BW connections.

The application normally works on a limited amount of set of attributes, but still have to process additional attributes transferred to the metadata. Per query, these additional attributes can reach up to multiple thousands, largely increasing the size of the metadata. This option limits the number of attributes to the ones that are explicitly defined at the query level.

This option can be enabled at the model level, and has impacts in stories, App Design and Data Analyzer.

Reduce BW Query Metadata

This option optimizes performance in a table widget by consuming a reduced set of metadata. This limits the number of attributes to the ones that are explicitly defined at the query level.

When this option is activated, the only attributes that will be available in an SAP Analytics Cloud story are the attributes that were marked as visible in the query.

Size Limits for Planning Performance

Whenever you make edits to a private or public version, the application uses snapshots to support fast interactive planning and ensure a stable data region during planning. By default, snapshots are taken straight from the source public version, with potential restrictions (see below). With version management, you can also create a private version with an empty or filtered snapshot.
Note
  • Read performance can be affected when querying large private versions.
  • The size of the target public version plays a role during publish.
Large version sizes can impact the initial snapshot creation, interactive queries during planning as well as the publish operation. Although planning on private versions isn’t restricted, you might want to consider other ways to better control the performance for these versions:
  • Use read data access control to restrict data regions.
  • Use write data access on the version dimension to restrict edits on large versions (for example, Actuals) to fewer users.
  • Create private versions with filters.
  • Configure a private version limit.

Working with limits in private version offers better control over a model performance. One benefit of working with limits is that, as a planner, you get notified whenever you create a data snapshot that is above the configured limit. When you get notified, you can either proceed or create a private version with more filters. For more details, please check out Creating Versions.

Every planning version has a default limit set to 5 million facts that can be adjusted, as planning performance depends on multiple factors, such as the number and complexity of the dimensions, calculations, concurrent users, and more. Make sure you adjust that limit accordingly if necessary in the Model Preferences, under Start of the navigation pathData & Performance Next navigation step Size Limits for Planning PerformanceEnd of the navigation path, with the Overwrite Default Limit option.

Optimize Recommended Planning Area

You can think of the planning area as a version’s data used for all planning actions, and a basis for creating private versions and editing public versions. By optimizing the planning area, you keep the data size manageable and can work on data that’s the most relevant to you.

Optimizing the planning area is especially useful if you’re trying to limit the data size of a model with a large public version that’s not limited. When you edit a public version, or create a private one, the application stores the recommended planning area as a reduced data snapshot but still shows locked data outside of that snapshot.

You can limit the size of the recommended planning area either using data access control, data locking, or both. Data access restrictions give you access to the data for which you have write access, while data locking restrictions give you access to the data regions that are unlocked.

You can optimize the size of the planning area in the Model Preferences, under the Data and Performance tab. Click the toggle under the Optimize Recommended Planning Area section, and using the dedicated options, select whether you want to limit the planning area based on data locking, data access control and model privacy, or both. Note that for both options to be effective, data access control and data locking must be enabled and configured. For more information, see Configuring Data Locking and Set Up Data Access Control.

For more information about the planning area, see Optimize Planning Models Using the Planning Area. For more information about working with the recommended planning area when editing or creating versions, see Planning on Public Versions and Creating Versions.

Optimized Scenario Composer for Analytical Engine

The SAP HANA processing engine used by SAP Analytics Cloud has been optimized and made available for models created from version 2021.02+ to provide better supportability, performance, and precision. As a result, you might notice different data results between models created before and after version 2021.02. These differences are expected and solely due to the update.

However, if you notice unexpected results in new models or errors that didn’t occur before, you can decide to switch back to the legacy processing engine as opposed to the optimized processing engine. For more information, please refer to 2994816 Information published on SAP site.

Comment Statistics

Comment statistics give you information on comments associated with a planning or analytic model at the model level. Information such as the number of data point comments, dimension comments, and threads in the model are all part of the statistics.

You can view comment statistics from the (Model Preferences) dialog, under Data & Performance tab, select View Comment Statistics option. The Comment Statistics dialog opens.

Note

You must have permission to manage and read comments in the tenant and read permissions on planning and analytic models in the tenant to view comment statistics.

Enable Legacy Export

By default, only the file and SAP BPC options are available for export jobs in the Data Management space. To be able to export to other systems like SAP S4/HANA, SAP Business Integrated Planning, or SAP BW and BW4/HANA using OData services, make sure to enable this option.

Redeploy Model

For performance reasons, after a system upgrade, models are upgraded consecutively over time. You can use the Redeploy Model option if you want to make sure that a specific model is upgraded after a system upgrade.

You can also use that option if you have incorrect data or exceptions errors in widgets in stories and analytic applications. This usually means that the model is corrupted. The Redeploy Model option regenerates all runtime artefacts and fixes these errors.

Using the Redeploy Model option also regenerates data locks. In the rare case that the data locking configuration cannot be recovered, you need to go to Model Preferences, turn data locking on and off, and re-set the data locks manually. Another option is to contact your system administrator and ask if they can help reconfigure the data locking and recover the data locks. For more information on configuring data locks, see Configuring Data Locking.