SAP Knowledge Base Article - Public

3325583 - Warning: Planning on large versions like this one can affect performance. Your operation would create a data snapshot of ... in SAP Analytics Cloud for Planning (SAC)

Symptom

The following warning occurs in SAP Analytics Cloud for Planning (SAC) when you try to initiate a private version:

  • Planning on large versions like this one can affect performance. Your operation would create a data snapshot of xxx million records. Instead, try creating a private version with a subset of this data.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Open a story.
  2. initiate a private version (for example, put a public version in edit, create a private version by copying a public version, enter data)

Cause

Every planning version has a default limit set to 5 million facts.

Resolution

You can adjust this limit if necessary in the Model Preferences, under Data & Performance > Size Limits for Planning Performance, with the Overwrite Default Limit option.

Please refer to the following SAC Online help for details: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/ac714f6f6f86495b972fbe6fe06aa800.html#size-limits-for-planning-performance

Please also be advised that large version sizes can impact the initial snapshot creation, interactive queries during planning as well as the publish operation. If the optimized planning area is not enabled in your model, you might consider using it to keep the data size manageable and work on data that’s the most relevant to you. Please see https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/ac714f6f6f86495b972fbe6fe06aa800.html#optimize-recommended-planning-area

Keywords

KBA , LOD-ANA-PL-VER , Version Management , Problem

Product

SAP Analytics Cloud 1.0