How to use a result of a query as datasource for infocubes or DSO
This has the advantage that you can calculate functions of the query more efficiently in the analytic server before reading the data.
(source BW help)
Here is how:
- Create a data target in which you plan to load the query. It should contain the
dimensions and keyfigures of the query you use as datasource.
- Go to transaction RSRT and choose your query. In “Properties” tick your query as “is
used as InfoProvider”
- Now instead of creating a transformation first you create a DTP. Right click on the
DSO, OpenHub etc. and select “Create data transfer process”
- Select Query Element as Object Type in “Source of DTP”. After you did step 2) you will
find you query in the F4 help.
- BW created a transformation and a DTP. Now you can map and design additional logic
in the transformation as you are used to.
All the OLAP functions can be used in the staging with the query as the data source of a data transfer process.
This does not work with inventory keyfigures (non-cumulative keyfigures) or with any query containing input ready variables.