Embedding Queries, Query Views and InfoProviders 

Purpose

The IT process Embedding Queries, Query Views and InfoProviders enables business experts to insert queries (query views or InfoProviders) into Microsoft Excel workbooks. In the Business Explorer, the Analyzer – with its user-friendly design and analysis tools – is available for this purpose.

Use of the Process

This IT process is part of the following IT scenario:

IT Scenario	Scenario Variant
Enterprise Reporting, Query and Analysis	Microsoft Excel Integration

Prerequisites

In order to run this process, you need one or more queries (query views or InfoProviders). You can select queries, query views and InfoProviders from the open dialog in the Analyzer or create a new query using the Query Designer. You create queries in the designing a query  IT process.

Process Flow

The following process runs primarily in the BI Java usage type:

...

       1.      You open a query (query view or InfoProvider).

       2.      You insert a query into a workbook.

       3.      You analyze the data in the query.

       4.      You save the workbook.

Result

You have inserted a query into a Microsoft Excel workbook.