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.
If you select a workbook, you will find properties on two tabs: General and Planning.
|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
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:
* For more information on workbook properties, see To select workbook properties for prompting.
|System for Data Write Back||Displays the currently selected planning
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.
|Switch All Data Sources to Change Mode for Initial Refresh||If you select this check box when saving a workbook, the workbook
(containing input-ready data sources) will be opened in display
With the initial refresh, the data sources will be switched to change mode automatically.
In the default setting, this check box is not selected when you create a new workbook.
|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.|
|Name||Displays the sheet name.|
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.
|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 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 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 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.|
|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 Function / Sequence||You can define the variables values of the
|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.
|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.|
|Name||Displays sheet and chart name.|
|Cross Tab Name||Displays the crosstab name.|
|Sheet||Displays the sheet name. You can change it here.|