Modeling Composite Views Using BI Data Services 

Use

Business experts can use Visual Composer available in SAP NetWeaver Composition Environment to provide business intelligence data and capabilities directly in operational processes and to provide user-specific BI data directly in a given business context. This approach enhances the BI capabilities of SAP NetWeaver by providing a flexible modeling infrastructure that makes it possible to embed BI directly into applications for strategic and operational decision making.

This documentation describes how to model composite views using BI data services. For general information about modeling composite views with Visual Composer, see Modeling Composite Views with Visual Composer.

Prerequisites

To be able to model composite views with BI queries and query views, the following prerequisites must be met:

●      You must create a system connection to an SAP BI system in the portal of the CE system.

For more information, see Defining Destinations.

●      To be able to use BI queries and query views in your models, your BI system must be on SAP NetWeaver 7.0 SPS11 or higher.

Procedure

Inserting a BI Data Service in a Composite View

...

       1.      Open the Search task panel.

       2.      In the Search in dropdown list box, select the BI connection from which you want to insert a BI data service.

       3.      In the Type dropdown list box, select whether you want to insert a query or a query view.

○       When you select Query, you search for queries created in the BEx Query Designer.

○       When you select Query View, you search for query views created in the BEx Web Analyzer.

       4.      In the Search field, enter a search term.

       5.      Select a BI object from the results list and drag it to the Storyboard. A data service icon is created in the Storyboard.

       6.      The FILTER and VARIABLE input ports are typically connected to a form view, which enables you to enter values for filters and variables. The DATA output port can be connected to a table view or chart view to display the data. The INFO output port can be connected as a form view.

Note that BI queries and query views in SAP List Viewer (ALV) are not displayed in the same way as in the BEx Analyzer or BEx Web. For example:

●      All structures for the query are in the columns.

●      Characteristics in the drilldown of the columns are added to the drilldown in the rows.

●      Hierarchies cannot be displayed.

●      The definition of totals rows are not copied; these need to be defined in ALV.

●      Exceptions cannot be displayed.

Examples

Filtering a BI Data Service with the Results from Another BI Data Service

       1.      Display the results of the first query in a table view.

       2.      In the configuration for the table view, check whether the Selectable property is set to True.

       3.      Connect this table view to the FILTER input port of another BI data service.

       4.      Define the assignment for this connector; for example, assign the field Product of the input port filter to the field Product_Display_Keyof the output port table.

 Note that the syntax works for filters with key values (_Display_Key), but not with texts (_Text). For more information about the syntax for filters, see Structure of a BI Data Service.

Using a BI Data Service in the Definition for Dynamic Entry Lists

You can also use BI data services in the definition of dynamic entry lists for dropdown list boxes and combo boxes by filling the lists dynamically with BI master data or with the result of another query.