## 4.10.1  To plan data manually
## Context
You can enter the planning data manually in a crosstab in your analysis. You can either change the values in existing data cells in the crosstab or you can add new lines to crosstabs in change mode.
To enter planning data, the data source must be available in change mode. A data source can only be available in change mode for one user and for one workbook at the same time.
## Procedure
1. Enter an input-ready data source or open a workbook with an input-ready data source.
The crosstab is visible in change mode. In change mode, read-only cells of the data source are displayed with different background colors. If you switch to display mode, the distinct visualization of input-ready and read-only cells is not visible.
##  Note
Microsoft Excel cells are always input enabled. That means you can also enter values in the read-only cells of the data source. These values will not affect your planning though. If the read-only cells are displayed with a different background color, you can avoid entering data in read-only cells.
If a data source is not displayed in change mode, you can check the following settings:
- Check on the Components tab in the design panel if the correct planning system is connected. In the default setting, the planning system is the first system you connect to after opening a workbook. If a workbook contains objects from different systems, you can select one of these systems as the planning system in the list. The changed planning system will only be effective after closing and reopening the workbook.
- Check on the Components tab in the design panel if the check box Switch All Data Sources to Change Mode for Initial Refresh is selected.
If the check box is selected, the input-ready data sources in the workbook are opened in display mode. With the initial refresh, they will be switched to change mode automatically.
- The data source is already used in change mode by another user or by the current user in another workbook.
You can also use the property IsDataSouceEditable of the API method SAPGetProperty to check if a data source is input-ready.
2. You can enter planning data by changing data in existing data cells of the crosstab.
The format of an entered value is immediately validated. If the format is not correct, a message is displayed.
To check the consistency of the new values and apply it to the crosstab, choose Recalculate .
3. You can enter planning data in new lines added to the crosstab.
The following section describes the process for BW systems of type SAP BW/4HANA SP8 or higher and SAP BW 7.50 SP12 or higher. For former BW versions, the legacy mode will be applied automatically (see step below).
Note that new lines are not supported if the data source has two structures and one structure is used in the rows and one in the columns.
You can define the number of new lines on the Components tab in the design panel. The default number of lines is 5. New lines for planning are added to the bottom of the crosstab immediately. You can add up to 1000 lines. In display mode, the new lines are not visible.
To enter planning data in the data cells, you need to enter a member of the member combination for the data cell. For example, the dimensions Country, Region and City are in the rows of your crosstab. If you
want to enter a planning value for Paris, you enter the member for Paris and the planning value in the data cell for the key figure. With choosing Check New Lines in the context menu or Recalculate in the ribbon, the members for Country and Region will be derived automatically.
You can also activate a check of the entered data on the Components tab in the design panel. You can select property Planning: New Line Validation and define which data should be checked automatically:
- None No automatic check is executed.
- Member Automatic check runs whenever a member was changed.
- Lines
Automatic check runs whenever a line was changed and the derivation is done automatically.
The derivations in this mode can only work if the characteristic relationship is modeled in the BW system. Values that can't be derived will be replaced with character #, or any other character defined in RSADMIN.
Entered members that do not exist, are indicated with red frames after the check.
You can enter a high amount of new lines using the clipboard. You can paste more new line rows than configured in the design panel. Analysis will automatically increase the number of new lines temporarily. The performance critical extension of the crosstab with a high number of new lines is only done if needed after pasting values.
This allows to paste and transfer a high number of new lines once without the need to change the defined number of new lines in the design panel.
If the data source contains dimensions that are created in BW as characteristics without master data, you can enter master data in the new lines to create new members in Analysis. The new members will also be saved to the BW system.
Note that you can only create new members if the RSADMIN parameter PLAN\_ALLOW\_NOT\_EXIST\_MEM is active (value X) in the BW system. For more information, contact your IT administrator.
Using SAP BW/4HANA SP8 or higher, you can create new master data and attributes in new lines. You can also change attributes of existing master data. The master data is automatically enabled for a query on the characteristic. To update added or changed master data in planning queries in Analysis, you can choose Reset Data Source in the ribbon, use API SAPExecuteCommand with parameter Restart or log off and log on. With the last two options, you can keep the navigation status.
To be able to create and change master data in SAP BW/4HANA, the following properties must be selected for the characteristic in the BW system: Usable as InfoProvider and Planning Mode .
To check the consistency of the new values and apply them to the crosstab, choose Recalculate .
4. Optional step: Legacy mode for entering planning data in new lines added to the crosstab.
The legacy mode is used if your BW system does not support the current version for entering planning data (see step above). The legacy mode can also be enabled for all BW systems with file setting UseNewLinesLegacyMode . For more information contact your IT administrator.
You can define the number of new lines on the Components tab in the design panel. The default number of lines is 5. New lines for planning are added to the bottom of the crosstab after a navigation step, for example Recalculate. In display mode, the new lines are not visible.
To enter data in the data cells, you have to enter the complete member combination for the data cell. For example, the dimensions Country, Region and City are in the rows of your crosstab. If you want to enter a planning value for Paris, you also have to enter the region and country member in the corresponding line.
You can enter the member manually or select values with input help. The entered values are immediately validated for format and master data. If a value is not correct, a message is displayed.
You can enter a high amount of new lines using the clipboard. You can paste more new line rows than configured in the design panel. Analysis will automatically increase the number of new lines temporarily. The performance critical extension of the crosstab with a high number of new lines is only done if needed after pasting values.
This allows to paste and transfer a high number of new lines once without the need to change the defined number of new lines in the design panel.
If the data source contains dimensions that are created in BW as characteristics without master data, you can enter master data in the new lines to create new members in Analysis. The new members will also be saved to the BW system.
Note that you can only create new members if the RSADMIN parameter PLAN\_ALLOW\_NOT\_EXIST\_MEM is active (value X) in the BW system. For more information, contact your IT administrator.
To check the consistency of the new values and apply them to the crosstab, choose Recalculate .
5. You can undo all changes that are not recalculated or undo recalculated changes that are not saved.
Select Back To Previous Consistent Client State / Saved State .
##  Note
Planning data that you entered in a data cell in the crosstab, will be written to the planning buffer with the next action executed in Analysis. This could be swapping axis or adding or removing a dimension, for example. Even if the data cell where you entered the planning data is no longer displayed in the crosstab, the data is still available in the buffer.
If data is no longer needed, you can delete it manually in the data cell or delete the complete buffer with Back To Previous Consistent Client State .
6. Choose Save to save the planning data to the system.
## Results
The changed data is saved in the data source.
## Related Information
To recalculate planning data [page 216]
To save planning data [page 216] To undo changes while planning data [page 221] To switch between display and change mode [page 222] The Components tab [page 148] SAP cell styles [page 56]