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 BEx Analyzer to create and execute BEx applications that support manual planning. In BEx Analyzer, you use the Analysis Grid design item. Note that the Analysis Grid design item has to be displayed in full size. You make this setting in design mode in the Analysis Grid Properties dialog box on the Clipping tab page. Choose Full Sizeas the horizontal and vertical setting.
If you chose the Suppress New Rows setting for the Analysis Grid design item (Analysis Grid Properties → tab page General), you can only change the key figure values for posted data records.
For more information about manually entering data in an application created using BEx Analyzer, seeFunctions for Manual Planning.
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).
For more information about input-ready queries at execution, seeInput-Ready Query.
Input-Ready Objects (Cells and Rows)
Appearance of input-ready cells
All input-ready objects are displayed in format SAPBEXinputData.
Appearance of non-input ready cells
Non-input ready cells are not highlighted in color. If you try to enter values in a non-input ready cell, an error message will appear.
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.
Rows and Columns
You can use no more than one structure in the columns or rows.
If data is not available in the analysis grid, you can use one structure only in the columns, but you cannot use a structure in the rows.
Appearance of input-ready rows
New Input-new cells are always displayed under the table. You can enter data in all input-ready rows. The system determines the number of rows where data has been entered by checking the cells under the table in the first column. If one of these cells contains data, the system assumes that data has been entered for the corresponding row.
Input help
You can access input help for a cell by double-clicking it or pressing F4.
Entry
You can enter a key or text.
If you are working with text, the system has to be able to determine a key from the text in the logon language. We therefore recommend working with keys.
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 (like month and quarter).
Follow these steps:
- You are in change mode. In the new input-ready rows, enter the required key figure and characteristic values.
- Choose Transfer Valuesto transfer one or more changed or new data records to the server to be checked.
- Choose Save Values 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.