Copying and Pasting Cell Values
In tables and grids in SAP Analytics Cloud, you can copy and paste cell values, the underlying values of their leaf members, and formulas. You can also create references between cells.
Data can be copied within or across grids and tables, and you can also copy data from an external source such as an Excel spreadsheet.
In a table, you can paste data into cells that can receive data input.
You can also cut and paste values. For details, see Cutting and Pasting Cell Values.
Copying with Percentage Data
You can copy and paste to and from table cells that show percentages. When copying and pasting between percentage cells and numerical cells in a table or in an external spreadsheet, 100% is treated as a numerical value of 1.
Copying and Pasting Multiple Values
A rectangular group of selected cell values can also be copied and pasted to multiple cells in a table.
This type of operation can also be performed by selecting a source area and dragging the bottom right corner of the region horizontally or vertically to include the target area. For example, you could select several account values for January and February 2019 and drag them to the December 2019 cell to paste the January and February data to alternating months for the rest of the year. If the target region is larger than the source region, the copied values are repeated. If the target region is smaller, not all of the source values are pasted.
Copying and Pasting with Empty Cells
The destination cells can be booked values, unbooked values, or a mix of both.
When copying from a grid or an external spreadsheet, cells that are empty contain the en dash (–) character, or contain the minus (-) character are treated as unbooked. You can therefore copy and paste data from an external spreadsheet to a region of unbooked cells while keeping some of the target cells unbooked. Pasting an unbooked value will replace the booked cell with an unbooked cell, and delete the underlying values.
Copying and Pasting with Custom Time Hierarchies
In some cases, it is possible to copy and paste underlying values to non-leaf members with different time hierarchies. For example, you might want to copy between months with different amounts of days. This is supported if the date dimension is system-managed.
If your model is using non-standard user-managed time hierarchies, only the overall values can be pasted to cells with different time hierarchies. Refer to Customize Date Dimensions for more information about customizing date dimensions.
Pasting to More Than One Account or Measure
The target cells can belong to different accounts, as long as they use the same aggregation type. Note that copied values won’t have their signs flipped if there are conflicting target account types, such as income and expenses.
You can also paste to multiple measures in a model with measures.
Pasting to More Than One Hierarchy Level
If you paste to multiple levels of the same hierarchical dimension, values are pasted only to the child members in the target cells, and the cells for parent members are calculated by aggregation. For example, if you paste to an area that contains values for Q1, January, February, and March, then only January, February, and March are updated with the copied values. The new value for Q1 is calculated by aggregating the monthly values.
Avoiding Slow Performance
When there are multiple dimensions in the table, you can paste to different sets of members for each dimension. To avoid slow performance, you'll be notified when you try to paste to an area that includes a large number of different sets.
For more information on improving performance when conducting mass data entry, refer to Performance Considerations.
Copying and Pasting on Calculations
You can paste values to a calculated measure or account if you've defined an inverse formula for it.
Pasting to currency conversions is also supported. For a model with measures, you can copy and paste values to or from base currency measures and conversion measures. However, the values won't be converted. See Plan with Currency Conversion for details.
Pasting to Aggregated Accounts
In some cases, you can paste underlying values to an empty aggregated account that has calculated subaccounts.
The cells of the calculated subaccounts do not receive any values directly, but the rest of the data is copied as usual. If the copied data includes calculation inputs, the calculation will show the same values in the target cells.
For example, you may have created a blank version with an empty top-level account like Income Statement, which has several calculated subaccounts. To quickly fill in the values, you can copy and paste the value of this account, including its underlying records, from an existing version to the new version.
Say one of the Income Statement subaccounts is Revenue, calculated as Price * Units Sold. If Price and Units Sold don't aggregate up to Income Statement, Revenue doesn’t receive any values in the new version. To get those values, you can copy the calculation inputs: Price and Units Sold.
When you copy an aggregated account with calculated subaccounts, possible empty target cells will be highlighted. Source and target cells need to belong to the same account, and meet the requirements for copying and pasting details. Also, the target cell can't be a restricted measure or account.
Copying Across Restricted Measures
You can copy and paste between restricted accounts and measures. The target cells must be included in the restriction applied to the account or measure, however.
In many cases, such as when you are copying from one period to another in a forecast layout, it's helpful to copy the underlying values of the source cell. You can copy underlying values across restricted accounts and measures when a few conditions are met:
-
They are both restricted along the same dimensions.
-
A single member is chosen for each restricted dimension. For example, Date = "2020".
-
Each restricted dimension other than the date dimension is restricted to a leaf member.
-
The date dimension is restricted to the same level, for example, Date = 2019 and Date = 2020.