Report: The formated output of a query is called Report. In SAP BW a report is the result of the query as viewed in the BEx Browser.
QUERY: It is the combination of Projection (Which), Selection(Which Records), Aggregation (at what level of granulrity)
In SAP BW, query is combination of characteristics and Keyfigures with some conditions. A query is used to a specific Infocube or an ODS object and provides the definition of the data to retrived into a data report.
In SAP BW Queries can be written against
Infocubes: For multidimensional historical summarized data.
DSO : For flat(2 dimensional) reporting with latest detailed data.
Multiproviders; For multi reporting(Reporting users more than one infoproviders.)
Features of SAP BW Queries:
Queries can be stored in workbook.
One workbook contain more than one query.
queries can be assigned to one or more roles.
Exception can be divided for each query.
Hello,
ReplyDeleteA report is a piece of information describing or an account of certain events given or presented to someone. Reports often use persuasive elements, such as graphics, images, voice or specialized vocabulary in order to persuade that specific audience to undertake an action. Thanks for sharing it........
Extract Web Page Data