Entering content frame

Function documentation Context Menu Functions Locate the document in its SAP Library structure

Use

The Web items Navigation Block, Table, Chart, List of Exceptions, List of Conditions, and Label have a context menu that you can call up by clicking on a cell text (characteristic, characteristic value, structural component, description of an exception, description of a condition) with the right mouse button.

Features

The context menu offers various functions depending on the cell context, the Web item used and the settings of the Web template in the Web Application Designer.

There is also the option of determining a more basic version of the context menu with a restricted number of functions. If you want the context menu to contain more functions, you can add an enhanced menu. In the context menu itself, you can then use the menu entries Enhanced Menu and Basic Menu, to toggle between the two versions. The basic menu contains a subset of the enhanced menu.

Note

You can activate and deactivate the functions in the context menu and the enhanced menu for a Web application. You determine which functions the context menu contains in the Web template.

a.       In the Web Application Designer, in the Properties window, select the Web template and choose the Web Item tab page. The list contains the Web template properties.

b.       Under Entries in the Context Menu, select the required setting for the individual functions.

-         Choose No Display when you do not want the function to appear in the context menu.

-         Choose Always Display when you want the function to appear in the basic and enhanced context menus.

-         Choose Enhanced Menu when you want the function to appear only in the enhanced context menu.

c.       Choose This graphic is explained in the accompanying text Save.

The context menu can contain the following functions:

Back

Choose Back if you want to undo a navigational step in this query view. This query view is the data provider for the Web item on which you select the function Back.

Back to start

Choose Back to Start if you want to undo all navigational steps in this query view. This query view is the data provider for the Web item on which you select the function Back to Start.

Forward

Choose Forward if you want to repeat a navigational step in this query view for which you have already chosen Back. This query view is the data provider for the Web item on which you select the function Forward.

Keep filter value

Choose Keep Filter Value if you want to see only the data for a characteristic value. The characteristic value itself is removed from the drilldown.

Example

For example, in the drilldown, you have the characteristic Country. From the characteristic value Germany, you choose the function Keep Filter Value. The table data is now filtered for Germany, and the characteristic value, “Germany” in this case, is no longer displayed in the drilldown. You can only see in the navigation block or in the filter that the table is filtered for Germany.

Keep filter value on axis

Choose Keep Filter Value on Axis if you only want to see the data for a characteristic value and, at the same time, you still want to see the characteristic value itself in the drilldown.

Note

Above all, this function is meaningful with the Web items Chart and Map. This is because you can see for yourself in the chart or map to learn the context in which the data exists, meaning how they were filtered. You will still be able to interpret the chart / map.

Select filter value

Choose Select Filter Value if you want to filter the Web application according to values. For more information, see Selecting Filter Values.

Filter and Drilldown According to Characteristic

Choose Filter and Drilldown According to to fix a characteristic to a value in one step (meaning to filter it) and to drilldown according to another characteristic on the same axis (row axis or column axis).

Example

Choose the function Filter and Drilldown According to for example, Region for the characteristic value Germany. The data is filtered for Germany. The characteristic value Germany disappears from the drilldown. Simultaneously, the characteristic Region is drilled down.

Drilldown across or down

For characteristic descriptions (for example, country), you can choose Drill Down Vertically in the navigation block or from a label in order to drill down along the axes for the columns or rows.

Insert drilldown according to

In the context menu for a characteristic value or characteristic description, choose Add Drilldown by Region,  when you want to add a characteristic (for example, Region) to a precise position in the drilldown that you want.

Swap characteristic 1 / structure 1 with characteristic 2 / structure 2

You can use this function to swap a characteristic / structure with another characteristic / structure.

Remove drilldown

Choose Remove Drilldown if you want to remove a characteristic from the drilldown.

Swap axes

You use this function to swap the axes of the query. If you have characteristics in the rows and key figures in the columns and you choose Swap Axes, then the key figures are displayed in the rows and the characteristics are displayed in the columns.

Expand/collapse hierarchy nodes

Choose Expand Hierarchy Nodes to expand, and Collapse Hierarchy Nodes to collapse a hierarchy node. You can also expand or collapse the hierarchy node by clicking on the hierarchy symbol.

Drilldown nodes by <next object on the axis>

This function is available in the context menu for the characteristic displayed in the hierarchy if you have activated the Display Rows or Columns Hierarchically in the Query Properties, under Data Preparation. You can drilldown a node after the next object to see the values for this object underneath it.

Expand hierarchy

Choose Expand Hierarchy To Level ..., if you want to display more levels of the hierarchy. Alternatively, click on the hierarchy symbol to expand the hierarchy.

See also:

Working with Hierarchies

Activating /deactivating hierarchies

You use this function to switch active hierarchies on and off.

Sort  Sort ascending / sort descending

You can use this function to sort structural component values by ascending or descending order

Note

This function is only available in the cells of structural components when all structures are fixed to individual values.

Sort characteristic 1

You can use this function to sort characteristic values or attributes for a drilldown characteristic in descending or ascending order.  You can sort by the key or the name.

Keys are usually sorted according to internal formatting. If you want to sort according to external formatting, you have to include this formatting with the InfoObject.

Note

In hierarchy lists, the relationship between the upper-level/lower-level nodes is retained in the hierarchy structures. Lower-level nodes, however, are usually displayed in the sequence in which they appear in the sort criteria. You use the Sort According to Hierarchy function to restore the original sequence as determined in the hierarchy definition.

Calculate result as...

You use this function to recalculate the results rows and single values that are displayed in the query according to the following criteria:

Summation / Maximum / Minimum / Count All Values/ Count all values < > 0 / Average of All Values / Average of All Values < > 0 / Standard Deviation / Variance / Suppress Result / First Value / Last Value

You can find additional information under Calculate Results As....

Calculate single values as...

You use this function to recalculate the single values that are displayed in the query according to the following criteria:

Normalize result/ Normalize total result/ Normalize../ Ranked list/ Olympic ranked list

For more information, see Calculate Single Values As....

Cumulated

You use this function to cumulate the individual cells in an area. The first value is added to the second value, the result is added to the third value, and so on. In the columns, the cells are cumulated from top to bottom, and in the rows, the cells are cumulated from left to right. With blocks of single values, that is, a drilldown in both the rows and the columns, the values are cumulated from top to bottom and from left to right.

Note

This function is particularly useful with drilldowns on time characteristics (months, for example). Using the function Calculating Single Value as Normalize Results, and Sort Descending, on the corresponding value column, you get a cumulated list that is often described as an ABC list.

Goto

Choose Goto when you want to access documentation and jump targets using the Report-Report interface. For more information, see Goto.

Export as CSV file / MS Excel 2000 file

MS Excel 2000 file.

You can export query data to MS Excel 2000.

The query data is embedded in the BEx Analyzer as with queries: The navigation status does not change and the formatting is transferred. You can see the filter restrictions and the data in the table. Exceptions are highlighted in color in the same way as they are on the Web.

You can also use the BEx Analyzer BW functions to continue navigating.

CSV file

You can export the query data into a CSV (comma separated value) file.

Unlike exporting to MS Excel 2000, you do not see the numbers in context and you cannot see the filter data.  The query formatting (such as how the exceptions are displayed) is also not transferred to the CSV file.

You can find additional information under Exporting as CSV file/Excel 2000 file.

Bookmark

Choose Bookmark when you want to retain a particular navigation status of the Web application, and access it later. For more information, see Bookmark

Bookmark with data

Choose Bookmark with Data when you want to retain a particular navigation status of the Web application, together with its data, and access it later. When you call up the bookmark URL later, not only does the retained navigation status appear in the Web application, but also the historical data from the time the bookmark was set. For more information, see Bookmark

Note

By default, this function does not appear in the context menu. You can activate this function in the Web Application Designer.

a.       In the Web Application Designer, in the Properties window, select the Web template and choose the Web Item tab page. The list contains the Web template properties.

b.       Under Entries in Context Menu, choose the property Bookmark with Displayed Data. In the Value column, the option No Display is activated.

-         Choose Always Display when you want the function to appear in the basic and enhanced context menus.

-         Choose Enhanced Menu when you want the function to appear only in the enhanced context menu.

c.       Choose This graphic is explained in the accompanying text Save.

Distribute by e-mail / via Enterprise Portal

If you want to distribute the Web application by e-mail, select Distribute By E-mail. You can have the Web application precalculated at a predefined time or you can have it send to your desired recipients as an online link.

If you would like to put the Web application into the Enterprise Portal as a precalculated file or as an online link, select Distribute Via Enterprise Portal.

This brings you to the Broadcasting Wizard which helps you to make the necessary entries for distribution with step-by-step instructions. If you want, you can also get to the BEx Broadcaster from the Broadcasting Wizard to make any additional detailed entries. There you can select another Web application, a query or a workbook for precalculation and distribution.

You can find additional information under Functions of the BEx Broadcast.

Properties

Choose Properties when you want to change different settings for the characteristic or key figure. You can find additional information under Characteristic Properties  and Key Figure Properties.

Key figure definition

Choose Key Figure Definition to see how a concrete figure is comprised in your Web application. You can check whether data has been loaded and analyze errors. For more information, see Key Figure Definition.

Query properties

Choose Query Properties when you want to change different settings for the query at run time. For more information, see Query Properties.

Currency Translation

Choose Currency Translation when you want to determine the currency into which the key figures and structural components of the query are to be translated. For more information, see Currency Translation.

 

Leaving content frame