Entering Multiple Values in a Table

In SAP Analytics Cloud, you can enter multiple values in a table without waiting for the system to update between entries.

Context

Adding multiple values to a table can be time-consuming if you have to wait for the system to update the data source after each entry. This feature provides an editing session that allows you to enter multiple values before processing the updates. You also have the option to process and save some updates and then continue to make changes.

Procedure

  1. From your table, select Start of the navigation path (More Actions) Next navigation step  Mass Data EntryEnd of the navigation path.

    The Mass Data Entry dialog appears.

    Tip

    You can also select this option by using the following keyboard shortcut: Ctrl + Alt + M (for Windows) or Control + Option + M (for Mac).

  2. Add values to the table cells.

    You can enter values in unbooked cells and change existing cell values. Each time you enter a cell value, the cells that aggregate up to it are locked until after you have left the editing session. Both cells directly changed by you and those with values updated by calculations will have a background color applied (for example, a blue background color).

    Note
    You can copy and paste data to multiple cells during a data entry session, but there are some restrictions:

    • Underlying values cannot be copied across versions; only values can be copied.

    • The source cell used for the copy is disabled to avoid conflicting entries.

    • Underlying values cannot be copied from a cell that was originally NULL.

      During Mass Data Entry, you can change a NULL cell to a data cell by entering a number into it. Even though it may look like a booked cell, it originally wasn't one so you won't be able to copy underlying values from the cell.

    Note

    During a mass data entry session:

    • Hierarchies in the table cannot be expanded or collapsed.

    • Filters in the table cannot be adjusted.

    • Hidden beneath the table title and its settings cannot be adjusted.

    Note

    During a mass data entry session for a table built on an SAP BPC Embedded model, after you change the value of a member, we suggest you don't change the values of its parent members (including those of Totals that it contributes to) or child members.

  3. To control how your data changes are applied, select one of the following:
    • Process Data - Process the changes you've made so far and then continue adding data. When you process the changes, all the changes resulting from data entry will have a different background color applied (for example, a yellow background color).
      Tip

      You can also select this option by using the following keyboard shortcut: Ctrl + Enter (for Windows) or Control + Return (for Mac).

    • Exit Mass Data Entry - Any changes that have not been processed won't be saved.

Results

The changes are applied.