Embedding Queries into a Workbook 

Purpose

The Embedding Queries into a Workbook IT process enables business experts to insert queries 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 scenarios:

IT Scenario	Scenario Variant
Enterprise reporting, query and analysis	Microsoft Excel integration
Business planning and analytical services	Business planning

Prerequisites

In order to run this process, you need one or more queries. You can select queries 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

...

       1.      You open a query.

       2.      You insert a query into a workbook.

       3.      You save the workbook.

Result

You have inserted a query into a workbook.