## 4.1.4  The Components tab
On the Components tab, you can see a list of all components used in the workbook together with the properties of these components. You can select if the components should be listed by data source or by sheet. In both cases, the highest node of the list is the workbook. Below this, the data sources or the sheets are displayed with their components.
You can use the context menu to manage the components. For more information, see Managing components in the design panel [page 157].
A set of properties is available for each component. To see and change the properties for a component, select the component in the structure.
The following sections list the available components and their properties.
##  Note
Depending on the platform and data source you use, you might see only a subset of these components.
## Workbook
If you select a workbook, you will find properties on two tabs: General and Planning .
The General tab contains the following properties:
| Workbook Properties                | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
|------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name                               | Displays the name of the workbook. The workbook name is defined when the workbook is saved.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| Refresh Workbook on Open­ ing*      | If you select this check box, the data sources in the workbook are refreshed every time the workbook is opened. If this check box is not selected, the data in the workbook is not automatically refreshed on opening. You can refresh the data sources manually by choosing Refresh All in the menu.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Force Prompt for Initial Re­ fresh* | If you select this check box, the prompting dialog is displayed on every refresh.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| Subsequent Refresh                 | With this property, you can define the behavior for executing Refresh All . You have the following options: • Transaction Data Only (default) If the data sources in the workbook are offline and you execute Refresh All , the data sources get online. If you execute Refresh All again, only the transactional data is up­ dated. • Log Off and Reconnect If the data sources in the workbook are offline and you execute Refresh All , the data sources get online. If you execute Refresh All again, the data sources are logged off and reconnected again. All data in the data sources (for example master data) are updated. It has the same behavior as using the API method SAPLogOff with parameter True: Application.Run("SAPLogOff", True). If some data sources in the workbook are online and some are offline and you execute Refresh All , only the connected data sources are logged off and reconnected. |
| Store Prompts with Work­ book*      | If you select this check box, the defined prompt values for characteristic value variables are saved with the workbook. These variables are defined in the BEx query designer in the Default Values area with refresh behavior Refresh as Designed or in the Characteristic Restrictions area.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Remove Data Before Saving          | If you select this check box, the workbook is saved without the data. When you reopen the workbook, no data is displayed. To display the data, refresh the data sources manually by choosing Refresh All in the menu.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Workbook Properties   | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
|-----------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Merge Variables*      | If you select this check box, the variables are merged for all data sources. If the check box is not selected, the variables can be defined for each data source separately. Every time you change your selection for this property in the workbook, the connected data sources are restarted. Therefore the prompting dialog will appear automatically so that you can define the values before the data sources are refreshed. If the data sources are not connected, the dialog will not appear and only the property will be changed. |
|                       | In the default setting, this check box is not selected when you create a new workbook. The default setting can be changed in the registry. For more information, contact your IT Administrator.                                                                                                                                                                                                                                                                                                                                           |
|                       |  Note The following functions and API methods might need different parameters depending on the selection for merging variables:                                                                                                                                                                                                                                                                                                                                                                                                          |
|                       | • SAPListOfMembers • SAPListOfVariables • SAPCallMemberSelector                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
|                       | • SAPSetVariable                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
* For more information on workbook properties, see To select workbook properties for prompting [page 167].
The Planning tab contains the following properties:
| Workbook Properties        | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
|----------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| System for Data Write Back | Displays the currently selected planning system. For an empty workbook, this property is empty. When the first data source is inserted, the corresponding system is visible as the planning system. When you insert data sources from different systems, the system of the first inserted data source is the planning system. You can change the planning system by selecting another system in the list. The changed property value will only become effective when you close and reopen the workbook. When you change the planning system in a workbook before you are connected to a server, the changed property will become effective when you connect to a server. In this case, you do not need to close and reopen the workbook again. |
| Cell Locking               | You can lock input-ready cells against manual changes in planning workbooks. A locked cell is a time-limited setting that only applies to the current user session. Locked cells are displayed in a different cell style. There are two implementations of the cell locking function in Analysis: Front-end cell locks and back-end cell locks (single query and cross query). You can select here which implementation should be applied in a workbook. For more information , see Locking Cells [page 217].                                                                                                                                                                                                                                  |
| Workbook Properties                                         | Description                                                                                                                                                                                                                                                                                                  |
|-------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Planning Model                                              | Planning Model                                                                                                                                                                                                                                                                                               |
| Switch All Data Sources to Change Mode for Initial Re­ fresh | If you select this check box when saving a workbook, the workbook (containing input-ready data sources) will be opened in display mode. With the initial refresh, the data sources will be switched to change mode automatically. By default, this check box is not selected when you create a new workbook. |
| Refresh Planning Objects on Refresh All                     | If you select this check box, planning objects in the workbook are refreshed when a refresh is executed with Refresh All . By default, this check box is selected when you create a new workbook.                                                                                                            |
## Data Source
| Data Source Properties                   | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
|------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Data SourceName                          | Displays the data source name. You can change it here.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| Data Source Technical Name               | Displays the technical name of the data source.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| Formula Alias                            | Displays the formula alias. You can change it here.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| System Alias                             | Displays the system alias.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Use Data Source Formula- Optimized       | You can use this check box to switch between the formula-opitmized mode and the analysis mode.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| Planning: Open Data Source Input-Enabled | If you select this check box, the input-ready data source is opened in change mode when you open the workbook, and you can immediately start entering planning data. If you do not select this check box for an input-ready data source, you cannot enter and save planning data for this data source until you have selected the check box.                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Behaviour on Opening Work­ book           | • Default Refresh Behaviour The data source is refreshed as defined on workbook level with the setting Refresh Workbook on Opening . • Reset The initial state of the data source defined in the back-end, will be displayed when you reopen the workbook. You cannot save a navigation state with that workbook as the navigation state will be replaced with the initial state. • Reset and Clear Design Rules The initial state of the data source defined in the back-end, will be displayed when you reopen the workbook. The existing Table Design rules are deleted and will be no longer available when you reopen the workbook. You cannot save a navigation state with that workbook as the navigation state will be replaced with the initial state. |
| Document Store                           | You can select the document store for a data source. Document stores for data sources are defined in the BWsystem.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| Data Source Properties   | Description                                                                                                                                                        |
|--------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Document Filter          | You can create and/or select a document filter for a data source. Document filters can contain comments for one data source or for all data sources of a workbook. |
## Sheet
| Sheet Properties   | Description                                                                                                                                                                                                                  |
|--------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name               | Displays the sheet name.                                                                                                                                                                                                     |
| Sheet Type         | Displays the sheet type.                                                                                                                                                                                                     |
|                    | The following sheet types are available: Analysis, Neutral and Non-COF.                                                                                                                                                      |
|                    | Empty sheets are defined as neutral. If you add a data source with the Analysis plug-in, the sheet type Analysis is assigned. To reset a sheet to type neutral, you have to remove all inserted data sources from the sheet. |
|                    | Sheets of type Non-COF are not checked from the Analysis Add-In. It might be useful to assign this type to sheets that do not contain Analysis content to improve the performance.                                           |
## Crosstab
| Crosstab Properties           | Description                                                                                                                                                                                                                                                                                                                                                                            |
|-------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name                          | Displays the crosstab name. You can change it here.                                                                                                                                                                                                                                                                                                                                    |
| Formula Alias                 | Displays the formula alias of the crosstab. You can change it here. The crosstab formula alias is the second part of the named range for a crosstab. The first part is always SAP. For example, if the crosstab formula alias is CrossTab1, the named range for this crosstab would be SAPCrossTab1. You can select a crosstab with its named range in the Namebox in the formula bar. |
| Data SourceName               | Displays the data source name and the data source alias.                                                                                                                                                                                                                                                                                                                               |
| Range                         | Displays the cell range of the crosstab in the sheet. You can change the range to move the crosstab in the sheet.                                                                                                                                                                                                                                                                      |
| Planning: Number of New Lines | You can define how many new lines should be added to the crosstab for planning data. The default number is 5 lines. The new lines are only visible in change mode.                                                                                                                                                                                                                     |
Crosstab Properties
| Planning: New Line Valida­ tion     | You can select 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 automat­ ically.                                                                             |
|------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Apply Default Formats              | If you select this check box, the default formats are applied after each navigation step.                                                                                                                                                                                                                                                      |
| Display Symbols for Parent Members | If you select this check box, a symbol is displayed for parent members in a hierarchy (+/-).                                                                                                                                                                                                                                                   |
| Optimum Cell Width/Height          | If you select this check box, the table is displayed with optimum cell width and height.                                                                                                                                                                                                                                                       |
| Repeat Members                     | If you select this check box, texts that are not displayed because they occur several times in a column or row are repeated in each cell. The setting made in BEx Query Designer to hide/show repeated key values is not evaluated in Analysis. To define the display for repeated members only this setting in the design panel is evaluated. |
## Planning Objects
| Planning Objects Proper­ ties               | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
|--------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Nameof Planning Function / Sequence        | Displays the name of the planning object.                                                                                                                                                                                                                                                                                                                                                                                                                            |
|                                            | Displays the technical name of the planning object. Technical name of Planning Function / Sequence                                                                                                                                                                                                                                                                                                                                                                   |
| Alias                                      | Displays the alias of the planning object. You can change it here.                                                                                                                                                                                                                                                                                                                                                                                                   |
| Process Changed Data                       | If you select this check box, you can define that only data changed by the user in the current session since the last save will be processed. For planning functions, you can specify which aggregation level should be used as a filter to define the changed data. In the default setting, the aggregation level the planning function is built on is selected for a planning function. For planning sequences, it is not possible to select an aggregation level. |
| Variables of Planning Func­ tion / Sequence | You can define the variables values of the planning object: • For source Member , you can select the members with input help. • For source Cell , you can define the cell that contains the values.                                                                                                                                                                                                                                                                  |
| Filter                                     | On the Filter tab, you can define the filter for a planning function.                                                                                                                                                                                                                                                                                                                                                                                                |
For more information on planning objects, see To plan data with planning objects [page 214].
Description
## Filter
| Filter Properties                             | Description                                                                  |
|-----------------------------------------------|------------------------------------------------------------------------------|
| Data SourceName                               | Displays data source name.                                                   |
| Dimension                                     | Displays the name of the filtered dimension.                                 |
| Filter applies to the fol­ lowing data sources | You can select which of the data sources in the workbook should be filtered. |
## Chart
| Chart Properties   | Description                                      |
|--------------------|--------------------------------------------------|
| Name               | Displays sheet and chart name.                   |
| Cross TabName      | Displays the crosstab name.                      |
| Sheet              | Displays the sheet name. You can change it here. |