3287839 - Performance Issue in Mass Data Entry in SAP Analytics Cloud

For tables with many dimensions on the axis, a mass data entry (or copying facts from an excel sheet) onto a high number of empty cells can lead to performance and/or memory issues.

The runtime and memory consumption of a mass data entry depend on the size of the cartesian hull of the filters representing the empty cells among the cells that are changed. In other words, they depend on the product of the number of unique members for all dimensions on the axes for the area of touched empty cells.

Example

In the table shown below, data is supposed to be entered onto all cells for February & March. The cartesian hull for this area contains 158400 member tuples combinations (product of the numbers of unique members per dimension: 1 for Region, 11 for Department, 20 for Employee ID, 18 for Hire Date, 20 for Position and 2 for Date). While this mass data entry can be executed without problems, a similar mass data entry onto 100 rows instead of 20 might span a cartesian hull of billions of member combinations and lead to performance issues or fail due to too high memory consumption.

1. Link dimensions via validation rules.
2. Prefill cells that are supposed to be changed with zeros using a script data action.
3. Add input controls on dimensions to split up the mass data entry into multiple smaller parts.
4. Remove unnecessary dimensions from the axes.
5. Use data import jobs instead of copy-pasting from excel files.
6. Utilize the customized Planning Area.

There are some options explored in detail in the attached Word document.

copy paste SAC planning performance, long time, slow, copy pasting , KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem