SAP Knowledge Base Article - Public

3231803 - Wrong results when copy-pasting more than 1 cell in SAP Analytics Cloud for Planning (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud for Planning (SAC):

  • You copy and paste multiple cells.
  • You notice that the pasted values are not the same as the source values by the following ways:
    - Another measure is calculated base on the copied/pasted cell. The value of that measure is different.
    - In the data foundation view, the value of the target cell and the source cell is different. For example, the value of the source cell is stored as 20.1234567. The value of the target cell is stored as 20.

Environment

  • SAP Analytics Cloud (Enterprise) 2022.8.17

Reproducing the Issue

  1. Open an SAC planning story.
  2. Select multiple cells.
  3. Copy and paste the cells.

Cause

The following table shows the current behavior of copy-pasting and the new behavior which will be released in 2022.QRC03.

 Copy single cellCopy multiple cells
Standard data entry modeOld: copy underlying values
New: copy underlying values
Old: copy overall values
New: copy underlying values,
Mass data entry modeOld: copy overall values
New: copy underlying values
Old: copy overall values
New: copy underlying values
Fluid data entry modeOld: copy underlying values
New: copy underlying values
Old: copy overall values
New: copy underlying values

In case of copying the overall values, the target cell will have the same value as the one shown in the story – but not necessarily the one shown in the table cell but the most detailed value available in the story. Please see the attached screenshot.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Resolution

The default behavior is shown in the table in the Cause section.

If you want to specify which paste operation to use, you can select Edit -> Paste Special from the toolbar. You can then choose to Paste overall value or Paste details to include underlying values, and set the selected option as the default for future Paste Special operations.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, copy-paste, copy, paste, pasting, copying, copy-pasting, more than 1 , KBA , LOD-ANA-PL-DIS , Distribute, Spreading, Assign, Copy & Paste , Problem

Product

SAP Analytics Cloud 1.0

Attachments

overall value.png