Analytics Component

A generic design template which provides a re-usable UI component for the display and interaction of analytical (SAP Business Warehouse) content inside an FPM application.

The Analytics component is implemented using the Web Dynpro component FPM_BICS_GRID_RUIBB. The information displayed in this component at runtime is determined by the feeder class assigned to the configuration of this Web Dynpro component. However, you can determine the concrete display of the data in this component when you configure it in the FPM configuration editor, FLUID.

This component can also be combined with a Search component. A special Search feeder class enables the Search component to be used as a selection screen for variables for one or more queries.

This component can also be combined with a Chart component; a special Chart feeder class is available for this purpose.

Combining the Analytics component with the Search and Chart components provides you with a more comprehensive and fully analytical application.

Note A ready-to-use, generic FPM application (FPM_BICS_OVP), based on the Analytics component, is available for use immediately in the system.

Note

Note: SAP Business Warehouse is part of the overall SAP NetWeaver platform. It provides tools and functions to enable companies to evaluate and interpret data. For more information on SAP BW, search for SAP Business Warehouse in the SAP Help Portal, http://help.sap.com.

Implementation Considerations

This component is available only for systems running at least SAP_BW 7.40 SP05.

For this component to be visible in your applications at runtime, your browser must support HTML5.

This component can be viewed in Internet browsers only in Standards Mode. For more information, see UI Control Rendering in Sandards Mode in the SAP Help Portal (sap.help.com) under the Reference section of Developing Web Dynpro ABAP Applications.

Analytics Component at Runtime

The screenshot below shows an FPM application at runtime, incorporating an Analytics component, a Search component and a Chart component.

Figure 1: Analytics, Search, and Chart Components within an OVP Floorplan Configuration Analytics Component

Unlike the other FPM components, the Analytics component has three interface views (Web Dynpro 'windows') for displaying different facets of the underlying BICS query.

Query Results Grid
Displays the query results in a grid format. The query results grid can be manipulated using options in the context menu, various toolbar buttons, and the collapse/expand icons of the hierarchy nodes. The information in this grid is supplied by the window BICS_GRID_WINDOW. The figure below illustrates the grid layout:
Figure 2: Query Results Grid of Analytics Component
Information Panel
Displays read-only information about the underlying query, such as its technical name, and when it was last updated. This information is supplied by the window BICS_GRID_INFO.
Navigation Panel
The information for this panel is supplied by the window BICS_GRID_NAVIGATION, and can be placed in the Page Master panel of the Overview Page (OVP) floorplan. Divided into several sections, this window displays a list of the query characteristics that appear on the row and column axes in the query results grid, as well as a list of those characteristics that are available but are not displayed in the grid. This window allows the user to manipulate the query results grid by moving available characteristics to and from the grid axes (using the arrow buttons or drag-and-drop). Additional options to manipulate each characteristic (for example, sorting) are provided by a context menu.
This panel has the following layout styles:
- Analysis for MS Office (intended for use with the Microsoft Office plug-in)
  As well as the sections for the query fields (characteristics), there is also a section for the filter criteria; this too can be manipulated by the user to change the display of data in the query results grid.
- Fiori
  As well as containing sections for the query fields (characteristics), this layout style also has a search field. Users can search for fields across all three sections; this is particularly helpful if the query contains a large number of fields. Additionally, there is a Settings button in the header of this panel with the following menu options:
  - Show Filters
    This option displays a filter button next to each field allowing the user to access filter values for that field.
  - Defer Layout Update
    This option pauses the update or refresh of the query results grid so that any changes a user make in the navigation panel are not immediately visible. This allows for multiple changes to be made in the navigation panel without waiting for the query results grid to be updated each time. When all the changes have been made in the navigation panel, the user can manually update the query results grid using the Refresh button.
  The Fiori layout also contains a filter bar. This area displays information about the current query filter values and allows users to define new queries too. Use the button, Filter Bar, on the grid toolbar to toggle the display of the filter bar.
Figure 3: Layout Styles of the Navigation Panel

Editing the Component in Design Time

It is recommended to use the Analytics component within an Overview Page (OVP) floorplan configuration.

You can configure this component using the FPM configuration editor, FLUID:

General Settings
The General Settings panel provides you with options to change the default values of the width and height of the query data grid, and the width of the row header column inside the grid. Note that if the text inside this column exceeds the maximimum width, a scrollbar is rendered ( particularly helpful if there are lots of characteristics on the row axis of the query). You can choose to render various toolbar buttons in the grid; one to display an option for each configured report-to-report navigation of the configured query, and one to export data to a spreadsheet. Additionally, there is the option to enable the Personalization dialog box at runtime; this allows the user to bookmark the current state of the grid and query. You can set the layout style of the navigation panel and also enable the Maximize/ Minimize button in the grid toolbar.
Feeder Class Parameters
The Edit Parameters dialog box allows you to configure the following parameters for the feeder class of the Analytics UIBB:
- Query, Query Instance ID
  Enter a Query Instance ID if, within the application, multiple independent instances of the same query should be displayed.
- Execute Automatically
  Select this to work with queries containing variables without configuring a selection screen. The display of the grid triggers the processing of the default values of the query.
Events
The Toolbar Schema panel allows you to configure the BICS-specific events, and other navigational events.

The BICS_GRID_WINDOW is the window that displays the query result set in a data grid, along with a toolbar containing standard and configurable actions. The query result can be manipulated by the user at runtime using the methods described in the section above. Making a selection in the grid activates particular toolbar functions, for example, sorting. The Export to Spreadsheet function exports the current query result, independent of the visible section on the screen. The toolbar may contain an additional button with 'jump to' actions; these represent the configured report-to-report interfaces for the query. All selection criteria, including variables and the current selection in the grid, are exposed during the report-to-report navigation.

The Analytics component uses a re-usable feeder class, CL_FPM_RUIBB_BICS_GRID. For extensions, this class can be sub-classed to enable additional, application-specific functions.