Query as InfoProvider 

It can sometimes make sense to process data in a query as an InfoProvider (see Query Properties):

The advantage in doing this is that you can calculate the query’s functions in the Analytic Server before reading the data. This improves performance, especially in the case of simple queries that contain a very large amount of data.

If you use a query as an InfoProvider, not all query functions are supported.

The following functions are supported:

●      Standard aggregations (SUM, MIN, MAX)

●      Formulas that are totaled before aggregation (+, —, constant factor)

●      Units and currency translations

●      Constant selection

●      Formula with quotients, like prices

●      Formula with exception aggregation

In the following cases, it is not possible to activate a query as an InfoProvider:

●      The query is input-ready (for BW-integrated planning).

●      The query has input-ready required variables.

●      Temporal hierarchy join is enabled.

●      The query has more than one structure

●      The technical name of the query is more than 20 characters in length.

●      The InfoProvider is a TransientProvider or an aggregation level.

The following settings are not taken over from the query:

●      Set hierarchies

●      Local aggregations

●      Elimination of internal business volume

For more information about using a query as a data source for SAP BusinessObjects Data Federator, see Query as InfoProvider.