Show TOC

Embedding Queries, Query Views and InfoProvidersLocate this document in the navigation structure

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:

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.