The use of analysis is done mainly via the ribbon in excel. Individual features in the ribbon are enabled or disabled based on the type of data displayed and selected (Greyed out if disabled).
"Analysis" tab
The Analysis tab contains the following groups:
| Group | Icon | Description |
|---|---|---|
|
| Insert Data source Insert data from a source system into a crosstab |
| Refresh All Refresh all data sources. The data sources are updated with the corresponding data from the server and the crosstabs are redrawn |
| Group | Icon | Description |
|---|---|---|
|
| Undo Undo last Analysis step |
| Redo Redo last Analysis step |
| Group | Icon | Description |
|---|---|---|
|
| Prompt Enter values for Query parameters and variables |
| Filter Define filter criteria for data | |
| Sort Sort data | |
| Hierarchy Define hierarchy options such as expansion level and parent member positions | |
| Calculations Define simple calculations (+,-,*,/) and dynamic calculations (for example, ranking and cumulation |
| Group | Icon | Description |
|---|---|---|
|
| Member Display Configure display for members (key/text) |
| Measure Display Define display options for measures (for example, decimal places, scaling factors and currencies) | |
| Totals (Show, Hide) Configure display, position and calculation of totals |
| Group | Icon | Description |
|---|---|---|
|
| Save Comment |
| New Comment | |
| Delete Comment | |
| Show/Hide Comment |
| Group | Icon | Description |
|---|---|---|
|
| Save Data Save plan values to InfoProvider |
| Recalculate Recalculate plan values | |
| Lock Cells Lock and unlock input-ready cells | |
| Work Status Change the work status of the data source/selected cells | |
| Display Switch all data sources to display mode | |
| Change Switch all data sources to change mode | |
| Back Reset edited cells |
| Group | Icon | Description |
|---|---|---|
|
| Display Show/ Hide Design Panel. |
| Pause Refresh Activate/deactivate automatic refresh after each navigation step in the Design Panel. |
"Analysis Design" tab
The Analysis Design tab contains the following groups:
| Group | Icon | Description |
|---|---|---|
|
| Chart Insert dynamic chart |
| Info Field Insert information on data sources (for example, name and last data update) | |
| Filter Insert component for simple data filtering |
| Group | Icon | Description |
|---|---|---|
|
| Undo Undo last Analysis step |
| Redo Redo last Analysis step |
| Group | Icon | Description |
|---|---|---|
|
| Conditional Formatting Define rules for highlighting values using colors and symbols |
| New Lines Insert/delete new rows or new columns | |
| Format Cells Format new cells or existing cells | |
| Crosstab Configure display options for the crosstab. The following options are available:
| |
| Styles Manage crosstab styles |
| Group | Icon | Description |
|---|---|---|
|
| Combine Group crosstabs or link dimensions |
| Create Create Local Provider | |
| Reload Reload Local Provider | |
| Add Add Local Provider to Data Source |
| Group | Icon | Description |
|---|---|---|
|
| Convert to Formula Convert a crosstab into Excel formulas to retrieve the data. |
| Create Web Application Transfer components in an Analysis workbook to the SAP BusinessObject Design Studio to create a web application | |
| Launch Query Designer Launch a query designer to check the query definition and to change the definition according to your needs |
| Group | Icon | Description |
|---|---|---|
|
| Smart Copy Copy data source to clipboard |
| Smart Paste Paste data source from clipboard as table | |
| Save View Save data source as view |
| Group | Icon | Description |
|---|---|---|
|
| Display Show/ Hide Design Panel. |
| Pause Refresh Activate/deactivate automatic refresh after each navigation step in the Design Panel. |
The best way to get IT support is to use the new
Service One Platform.