Insert data input rows

Plan allows you to insert rows in matrix reports and enter data manually.

In some scenarios, data retrieved from a source may be incomplete. For example, a financial statement report might include revenue and expense metrics but not the number of shares outstanding. Similarly, a sales report might not include data for a newly launched product category. To address such cases, you can insert data input rows in the report and enter the required data.

In this article, you learn how to insert them and enter values directly in the report.

Insert a data input row#

Insert a data input row using either of the following methods:

• From the Planning tab
• Using row gripper

From the Planning tab

1. Select a row at the level where you want to insert the new row in the report.
2. Go to Planning > Insert Row. This option is disabled if no row is selected.
3. Navigate to Data Input and select Number.

Using the row gripper

1. Hover over a row to highlight the row gripper icon.
2. Select the gripper and choose Insert > Data Input.

A side panel opens as shown below, where you can configure the row properties.

Enter a name in the Title field and select Create. An empty row with default properties is added at the selected level.

Before selecting Create, you can modify the default row properties by configuring additional settings. The following sections describe these settings.

Data input row properties#

• Row type: Use the dropdown to select the type of row to insert:

  • Calculated row (Formula)
  • Data input row (Number)

  You can switch between row types at any time.

• Insert As: Choose how the row is inserted:
  • Single Row - Inserts one row.
  • Templated - Inserts the row across all hierarchy levels. For example, you can create a product line and replicate it across all region levels.
• Scaling factor: Set the scale for values in the data input row to thousands, millions, billions, or trillions. By default, it is set to Auto.

• Include in total: When enabled, the row values are included in the parent total. It is enabled by default.
• Distribute parent value to children: When enabled, row values entered at the parent level are distributed to child levels.

• Default value: Set the initial value for the row, which can be a

  • static value, or
  • a value sourced from another row

  Choose Static to enter a static row value. Choose Row to source values from another row in the report. You can enter the required row name in the Selected Row.

• Bind for cross filter/RLS: Enable Bind for Cross filter/RLS to ensure that cross-filter selections and row-level security (RLS) rules are applied to formula rows and data input rows that reference other rows. Learn more about binding rows.

• Delete a static row: Hover over the row, select the row gripper, and then select Delete Row. Alternatively, you can delete rows from the Manage Rows interface.

• Allow Input: You can choose when users are allowed to enter inputs into a data input row.
  • Edit mode: Users can enter values only in edit mode.
  • Read mode: Users can enter values even in read mode.

Bulk insert data input rows#

You can bulk-insert leaf-level rows or row hierarchies using the Insert Row(s) option from the Planning tab or row gripper.

Insert rows

1. Select any child row or the parent row under which you want to create new rows.
2. Use the row gripper and select Insert > Insert Row(s), or go to Planning > Insert Row > Data Input > Insert Row(s).

3. In the Insert Row(s) pop-up, you'll see that the parent row levels are already filled in. Enter the new row name.
4. To insert another row, select Add New or use the + icon next to the parent category.

5. To insert multiple rows at once, use the dropdown next to Add New and choose whether you want to insert 1, 5, or 10 rows.
6. Enter row names and select Save.

You can also specify the row dimensions where the new rows have to be added by selecting the icon in the Insert Row(s) window.

Insert a row hierarchy

To insert a hierarchy of rows:

1. Go to Insert Row(s) and select Add New.
2. In the Insert Row(s) window, the parent row hierarchy is pre-filled with existing values. Overwrite these values to define the new row hierarchy.
3. Select Save.

Overwriting is allowed only when the row type is set to Text in Insert Row > Manage Rows > Row Settings > Insert Row Configuration.

Allow blank values in categories#

While inserting row hierarchies manually, enable the Allow Blank Values toggle if you expect blank row categories in the leaf nodes.

1. Navigate to Planning > Manage Rows > Row Settings > Insert Row Configuration.
2. Enable Allow Blank Values.

By default, this toggle is disabled. The blank categories are highlighted in a red error box, and you cannot create rows with blank row categories.

By enabling this option, you can insert row hierarchies that contain blank leaf categories.

Disable row insertion#

You can restrict users from creating new categories for a particular level. To restrict row creation:

1. Go to Insert Row > Manage Rows > Row Settings > Insert Row Configuration > Manage.
2. Set Type to Disable Insert Row.

This prevents row insertion at the selected level and all levels above it, while child levels still allow insertion.

Upload rows from Excel or CSV#

You can also upload row categories from an Excel/CSV sheet and map the respective columns in the configuration.

1. Go to Insert Row > Manage Rows > Row Settings > Insert Row Configuration > Manage and select Options list from CSV.

2. Select Upload and choose a CSV file from your system.
3. Preview the data and select Add.

4. Go to Option Configuration tab.
5. Map the column using Filter options by selecting Add New, then select Save.

6. The uploaded values appear in the Insert Row window. Use standard insert steps to add them to the report.

Insert distinct values as rows#

Select Distinct Values in the Insert Row configuration to work with unique values from a selected dimension.

When this option is selected, you can:

• View only existing distinct (unique) values in the dropdown for the configured dimension in the Insert Row(s) window.
• Select and insert values directly as rows or row hierarchy from the dropdown, avoiding manual entry.

This helps streamline data entry by ensuring consistency and inserting rows within the existing row hierarchy by directly selecting the dimension value.