Variable Based BEx Queries in Dynamic Tables and Business Graphics – Airline Report

Variable Based BEx Queries in Dynamic Tables and Business Graphics - Airline Report

Airline Report provides airline comparison based on total sales and/or total number of passengers. One can select the airlines to be compared, the currency used in comparison so that each airline presents results in the same currency and not in its native currency, the time interval and the resulting business graphic chart type.

Main goal is to illustrate how BEx query data can be integrated and interacted with within the webdynpro environment. It starts from the very beginning with BW data source creation, BEx query design and ends up with dynamic tables and dynamic business graphics changing  structure based on end user input.

Airline Report is based on the SFLIGHT table, containing flight entries with overall booking amount as well as number of occupied seats per flight class. The BEx query calculated key figures will be based on them and therefore all Airline Report results.

Details on Airline Report:

Update: Complete source files can be downloaded from here. The archive contains two transport requests, one containing all webdynpro code, one containing BW data.

Leave a Reply

Your email address will not be published. Required fields are marked *