SAP Business Warehouse Complex Reporting deals data extraction from sap data base.In the example too, you maintain the Sender - Receiver assignment in the Query Jump Targets menu. In the Sender field, specify the name of the query from which you want to start the drill-through (1). Choose the Create button (2). In the dialog box that appears, choose Transaction as the report type, and specify the name of the R/3 system in which you want to run the transaction. In the next window, reconfirm that you want to assign a transaction to the Sender-query, and type in the transaction code that you want to run (3).Confirm your entries. The transaction you chose is displayed in the list of Receivers (4). Save your assignment.
In the Business Explorer Analyzer, open the Sender-query to prepare to start the drill-through. On the worksheet, you position your cursor over the cell containing the value for which you want to see more information, specifically the information that is stored in the transaction (1). Choose Goto from the BEx Analyzer toolbar. The jump targets you assigned are displayed in the context menu. Click once with the mouse-button on the transaction you want to use (2). The settings in the connection
_DIALOG control the jump into the R/3 system. A new SAP GUI session is started in the R/3 system, and the transaction is run.
InfoSet Query: Access
The InfoSet Query functions allow you to report using flat data tables (master data reporting).Choose InfoObjects or ODS objects as data sources. These can be connected using joins. You define the data sources in an InfoSet. An InfoSet can contain data from one or more tables that are connected to one another by key fields. The data sources specified in the InfoSet form the basis of the InfoSet Query.
Accessing InfoSet Maintenance from the SAP Menu
There are various ways of getting to the InfoSet maintenance. The easiest way is to use the SAP menu (1): In the Business Explorer, choose the path InfoSet Query - Maintain InfoSets (2).
InfoSet: Access from "InfoSet Maintenance"
You get a list of all the available InfoSets. Specify a name for your new InfoSet, and choose Create. You assign your InfoSet to a user group here. From this screen you also display or modify existing InfoSets.
Accessing InfoSet Maintenance from the AWB
It is also possible to get to the InfoSet maintenance screen directly from the Administrator Workbench: In the data target directory, drag the cursor over an ODS object, or choose the InfoObject you need from the InfoObject catalog. Choose InfoSets from the context menu (right mouse-click) (1). Give the InfoSet a technical name, and choose the Create pushbutton (2). You can get to the general InfoSet maintenance area from this screen by choosing InfoSet Maintenance from the InfoSet dropdown menu (3).
Give the InfoSet a name, and specify what kind of InfoSet you want to create. You get data for the InfoSet in the following ways (flag the option you want to use) (1). Reading the data directly from the table. Using a join to combine data from the selected basis table with data from another table (scheduled for a later date). Specifying a logical database to use as a data source. You also have the option of using a program to get data. Finally, define the field groups for your InfoSet (2).