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.
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.
Workbook Properties | Description |
---|---|
Name | Displays the name of the workbook. The workbook name is defined when the workbook is saved. |
Refresh Workbook on Opening* | 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 Refresh* | If you select this check box, the prompting dialog is displayed on every refresh. |
Store Prompts with Workbook* | 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 Characteristic Restrictions area in the BEx query designer. |
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. |
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:
|
Planning: 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. |
* For more information on workbook properties, see To select workbook properties for prompting.
Data Source Properties | Description |
---|---|
Data Source Name | 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. |
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. |
Reset Data Source on Opening Workbook | If you select this check box, the initial state of a query or query view defined in the BEx Query Designer, 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. |
Sheet Properties | Description |
---|---|
Name | Displays the sheet name. |
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 formulia 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 Name box in the formula bar. |
Data Source Name | 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. |
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. |
Apply Default Formats | If you select this check box, the Analysis default formats are applied after each navigation step. |
Apply Number Formats | If you select this check box, the Analysis
number formats are applied after each navigation step. The property is only available if the corresponding setting is enabled. For more information, contact your IT administrator. |
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 Properties | Description |
---|---|
Name of Planning Function / Sequence | Displays the name of the planning object. |
Technical name of Planning Function / Sequence | Displays the technical name of the planning object. |
Alias | Displays the alias of the planning object. You can change it here. |
Filter Properties | Description |
---|---|
Data Source Name | Displays data source name. |
Dimension | Displays the name of the filtered dimension. |
Filter applies to the following data sources | You can select which of the data sources in the workbook should be filtered. |
Chart Properties | Description |
---|---|
Name | Displays sheet and chart name. |
Cross Tab Name | Displays the crosstab name. |
Sheet | Displays the sheet name. You can change it here. |