Show TOC

Procedure documentationUse the BI Integration Wizard Locate this document in the navigation structure

 

The BI Integration Wizard walks you through the process of creating a query using one of a set of query templates. The wizard creates a data service element in the Visual Composer workspace configured with the query you choose.

The wizard can create queries upon any data service in your portal system configured to connect via the BI Java JDBC Connector, including relational data sources.

Prerequisites

  • You have defined at least one data source in the portal based on the BI Java JDBC Connector. See Defining Portal Systems and Aliases in the SAP NetWeaver Visual Composer Installation & Configuration Guide.

    Note Note

    You can use the wizard with SAP BW systems 3.1C and higher if they have been configured as OLAP systems using the BI XMLA Connector. We recommend, however, that you configure SAP BW systems 3.5 and higher with the SAP BI Connector. You can access queries, query views, and characteristics from these systems directly on the Find Data Services task panel (see Using a BI System as a Data Service). You cannot use the BI Integration Wizard with systems configured in this way.

    End of the note.

  • You have created an iView in which to place your query before you launch the BI Integration Wizard.

Procedure

The wizard's process flow differs depending on which type of system and which template you choose. The basic process is as follows:

  1. From the BI menu, choose BI Integration Wizard.

  2. Select the data service upon which you want to base the query.

  3. Select a query template.

    The list of available templates varies depending on the type of system (OLAP or relational) you have selected.

  4. Configure the query parameters.

    These parameters vary depending on the query template you have selected.

  5. Preview the result.

Result

Once you have completed all required wizard screens and clicked Finish, you return to the Visual Composer workspace, where a new data service has been created with the query you have configured. This result is supported by an underlying MDX (for OLAP data sources)-> DAS MUSS WEG, ODER? or SQL (for relational data sources) statement.

The data service is configured automatically with a start input and a table view as output. These three elements together constitute a complete iView, ready for preview and deployment to your portal.

Example

See Creating a BI iView.

More Information