The InfoSet Query is a tool of the SAP Application Server that can be used in the BI System for tabular (flat) reporting. Classic InfoSets provide the view for this data.
The BEx Query is intended for reporting with InfoCubes. In this process, functions such as the following are supported: Reporting with all InfoProviders, using variables, navigation, displaying attributes and hierarchies, characteristic drilldown, currency translations, report-report interface (R-RI), and authorization checks. These functions are also available for reporting using DataStore objects. However, there is a restriction in that you cannot report on more than one DataStore object at a time. The tool designed for this is the InfoSet Query.
The InfoSet Query is designed for reporting using flat data structures, that is InfoObjects, DataStore objects, and DataStore object joins. The following functions are supported for the InfoSet Query: Joins from several master data tables and DataStore objects, report-report interface (R-RI), and authorization checks. The authorization check in the InfoSet Query is simpler than the authorization check in the BEx query. The report is displayed either in the SAP List Viewer, or on the Web.
We recommend you do not use the InfoSet Query for reporting using InfoCubes. The InfoSet Query does not support the following functions: Navigation, hierarchies, delivery of BI Content, currency translation, variables, exception reporting, and interactive graphics on the Web.