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 parameter set to 5 million database records 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.
Resolution
You can adjust this limit if necessary in the Model Preferences, under Planning > Planning Area > Performance Parameter.
Please 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/89f07ff7386840f3950bde8f3afa1e6b.html#planning-area
Keywords
KBA , LOD-ANA-PL-VER , Version Management , Problem