Planning Business Data Manually

In BEx applications that use data providers that an input-ready query is assigned to, the system allows manual entry of data using either input-ready cells or new input-ready rows.

In input-ready cells, you can change individual key figure values for a posted data record. In new input-ready rows, you can either change posted data records or enter new data records for characteristic combinations that do not yet exist. 

You use the Web Application Designer to create BEx applications that support manual planning. You execute these applications on the Web. On the Web, you use the Analysis Web item. If you want to enter new rows, specify the number of new rows you want to display and where you want them to be displayed. You do this in the Web item parameters in BEx Web Application Designer. (The default setting is 0; new rows are not displayed by default.)

The following conditions apply if you want to change existing data:

• At least one input ready key figure exists.
• No active conditions exist

The following conditions apply if you want to enter data in new rows:

• No active universal display hierarchies exist.

Input Ready Queries at Execution

Whether the cells in an input-ready query can be changed at execution depends on the query view and possibly on other settings (such as settings for data slices and characteristic relationships).

Input-Ready Objects (Cells and Rows)

Appearance of non-input ready cells

Non-input ready columns are highlighted in color.

New Input-Ready Rows

Posted data

You can enter plan data irrespective of whether data has been posted.

If no data is available in the analysis grid, you can use input help to restrict the free characteristics to a single value or drag and drop the free characteristics to the rows. In the columns, you can use no characteristics and no more than one structure.

You can switch the position of the rows and columns.

Rows and columns

You can use no more than one structure in the columns or rows.

Appearance of input-ready rows

You set the number and position of the new input-ready new rows in the parameters of the relevant Web item (under Internal Display).

Input help

Input help is available when you enter data in new rows.

Entry

You can enter just a key.

Input-Ready Cells

In input-ready cells, you can change the individual key figure values for a posted data record.

Input-Ready Rows

You can enter new rows if you the analysis grid allows this. In the simplest case, you use the key figure structure in the data columns and use input help to restrict the free characteristics to a single value or drag and drop a free characteristic to the rows or columns.

The system only displays a new input-ready row if at least one of the cells in the row is defined uniquely with regard to the characteristics in the underlying aggregation level. When using navigation attributes and time characteristics, avoid redundancy by making sure that you do not have derivable characteristics in the drilldown at the same time (for example, month and quarter).

Follow these steps:

1. Execute the Web template and enter the required key figure and characteristic values in the new input-ready rows, .
2. Choose Refreshto transfer one or more changed or new data records to the server to be checked.
3. Choose Save to save the data records persistently to the database.
   Note

   The data is checked automatically during navigation (filter changes), and navigation is not permitted if any entries have errors.