Using Mass and Fluid Data Entry When Planning in Data Tables

Objective

After completing this lesson, you will be able to perform mass and fluid data entry in a data table.

Data Entry Modes

The data entry modes for data tables are as follows:

  • Single Data Entry Mode: Processes each new data change immediately.
  • Fluid Data Entry Mode: Processes all new data changes at the same time if they are made in a fast sequence. This is the default data entry mode for new data tables.
  • Mass Data Entry Mode: Processes all new data changes when you confirm that you've finished entering values.
The Builder panel with Planning Enabled and the Default Data Entry Mode drop-down open with Single, Fluid, and Mass Data Entry Mode options displayed.

Mass Data Entry

Adding multiple values to a table can be time consuming when you have to wait for the system to update the data source after each entry. Mass Data Entry allows you to enter multiple values in a table without waiting for the system to update between entries.

You can use the mode as required, for example, you can perform some updates then exit Mass Data Entry mode and continue to make changes in the story.

In order to use Mass Data Entry, follow these steps:

  1. Switch to Mass Data Entry using the table's More Actions menu.
  2. Enter data values.
  3. Select Process Data to apply the changes and exit or select Exit Mass Data Entry to leave without applying changes.
Steps 1 to 3 in using mass data entry.

Perform Mass Data Entry in the Story Page

Business Scenario: You need to make quite a few adjustments to your planned income statement due to some new information regarding supply chain issues in Q1. You want to make the changes and then trigger the system processing when you are ready. In order to do this, you use Mass Data Entry.

Task Flow: In this practice exercise, you will:

  • Access Mass Data Entry from the table
  • Update the table and process the data

Fluid Data Entry

In Fluid Data Entry Mode, data values that are entered in a fast sequence are processed together at the same time as a batch; you don’t need to wait for the system to update between entries.

Fluid data entry in a data table with the Default Data Entry Mode highlighted.

Time Interval for Fluid Data Entry

Data values that are entered with time between every two successive data entries within this set time interval are treated as belonging to the same fluid data entry batch. For example, if the interval is set to 500 milliseconds (0.5 seconds), then after 0.5 second of inactivity, the batch is processed. The next data value you enter is treated as the first one of a new fluid data entry batch.

SAP Analytics Cloud administrators can set or change the time interval for fluid data entry batches by going to SystemAdministrationSystem Configuration and updating the value for Time interval of fluid data entry batches (in milliseconds).

Use Fluid Data Entry Mode in a Data Table

Business Scenario: You have additional adjustments to make to the planned income statement, due to more new information regarding supply chain issues in Q1. You want to enter multiple values rapidly and after you are finished typing, the system will process the new data. In order to do this, you use Fluid Data Entry from the Builder pane to make the changes.

Task Flow: In this practice exercise, you will:

  • Access Fluid Data Entry from the table
  • Update the table and process the data

Log in to track your progress & complete quizzes