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
- Open a story.
- 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