Show TOC

The Components tabLocate this document in the navigation structure

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
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:
  • SAPListOfMembers
  • SAPListOfVariables
  • SAPCallMemberSelector
  • SAPSetVariable
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
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
Sheet Properties Description
Name Displays the sheet name.
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 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
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
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
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.