Member Entry Using the Insert Members Dialog Box

You can insert members for the dimensions that are in the row or column axis of the current report.

To do so, right-click in a cell that belongs to the row or the column axis and select Start of the navigation path EPM Next navigation step Insert Members End of the navigation path . The Insert Members dialog box displays the dimensions that are in the axis you are on. For each dimension, you can select the members you want to add to the report: select a dimension, then click Select Members. The Member Selector opens. If a filter has been previously defined to restrict the member insertion on the dimension, the Member Selector enables you to select only the filtered members. For more information, see Member Insertion Filtering.

You can specify where in the axis you want to insert the selected members: at the selected cell or at the end of the axis.

If you have specified that you want to insert the members at the selected cell, you can also specify:

if you want to insert the members and move down accordingly the members below in the axis,
or if you want the selected members to replace the current members. Example: you have selected two members to insert, the axis contains four members and the cell selected when performing the right-click is the second member cell. The second and third members in the axis will be replaced by the two selected members.

Note The selection you make is persistent: the next time you open the Insert Members dialog box, the default options are the ones you selected previously.

Note Empty rows and columns behavior for inserted members. You have selected the Remove Empty option for rows or columns in the Sheet Options. You then insert members using the Insert Members dialog box. Some of the inserted members do not have any data. However, they remain in the report as long as you do not refresh the report. If you are using an input form (Use as Input Form option selected in the Options tab of the Report Editor), you can enter data in rows or columns that do not yet contain any data. Then, when you refresh the report, the columns or rows for the members that do not contain data are not displayed in the report. For more information on empty columns and rows behavior, see No Data and Zero Values

Note When modifying an axis or changing the context of an axis in which members have been inserted, the inserted members are automatically removed.

The member insertion action automatically does a refresh of the report.

Restriction You cannot use the Insert Members feature when an EPMDimensionOverride or EPMAxisOverride function is used in the current axis.

Insert New Row

An Insert New Row option is available in order to insert new rows in a query. This Insert New Row option is only available to insert a member on the row axis.

By default, when using SAP BW (INA Provider) connections, you can only insert a new row on booked values. In order to be able to insert a new row on both booked and unbooked values, you need to check the Insert New Row box in the Insert Member window.

When the option is checked and you click on Member Selector, the member selector is opened in master data mode and the booked and non-booked members display.

Caution

You will not be able to insert a new row, if:

One or more characteristics that are drilled down in the rows are hidden.
The universal hierarchy is used in the rows. This means that the setting Display as Hierarchy is used in the SAP Business Explorer Query Designer or at runtime.
The query contains active conditions.
The Key figures structure is not in the column axis.
Another dimension is added in the column axis. The dimension must either be in the row axis or in the page axis with only one member selected or the dimension must be set in the context and with a value different than All Members.

Remember

It is impossible to use the cell locking function on an inserted new row.
The Imputable Members formatting will be applied to all inserted rows, even those that cannot be edited.
After you enter a new row, the system checks for consistency. If no error occurs, the key figure value is then considered as a delta value.
Error messages do not occur if the characteristic combination (or row) entered already exists. If the combination did not exist before, the value inserted as a key figure value is saved as declared. If not, the value is combined with the value already saved in the database.

In Large Reports: Refreshing only Expanded or Inserted Members

If you work with large reports and want to accelerate the refresh time, you can specify that only the new inserted rows or columns are refreshed after a member insertion. The other rows or columns of data are not refreshed. To do so, select the user option Refresh only Expanded and Inserted Members. This behavior also applies to the expanded members (see Expand).

Caution

Read the restrictions below before using the Refresh only Expanded and Inserted Members option:

Do not use this option if the axis on which the expansion/insertion is performed, contains local members.
Do not use this option if the axis on which the expansion/insertion is performed, contains EPMInsertCellsBeforeAfterBlock functions.
This option can cause certain formatting settings to not be properly applied. For more information, see Dynamic Formatting Template Definition.

Note This option enhance performances, but note that not all displayed data is refreshed in the report after a member insertion.

Example the Refresh only Expanded and Inserted Members option is selected. In a report, the following members are displayed for the Time dimension: 2010, 2012. You insert the 2011 member (right-click in a cell that belongs to the axis that contains the Time dimension and select Start of the navigation path

EPM

Insert Members End of the navigation path

). The following members are now displayed: 2010, 2011, 2012. The data are refreshed only for the members you have just inserted: 2011.