Web Application Designer: Create Multiple Reports from One Report with a Drop-Down Box Function
- by Dr. Yasan Gooding, Information Systems Specialist, Valero Energy Corporation
- February 1, 2004
Often, there is a need to recreate the same queries and Web reports to change a small feature, such as a different unit of measure. The author shows you how to avoid this by creating one flexible report, containing many similar reports in one report, with the drop-down box functionality of Web Application Designer (3.0 or higher).
You have seen it before; you have heard it before. A business user has requested that you recreate an existing report in BW for the Web using key figures that are different from the existing report in other uniform measurements like dollars, pounds, or kilograms. Chances are likely that other combinations of key figures in different units of measure will eventually lead to the creation of a new query with the same basic characteristic and filter requirements, but with different combinations of key figures in other series of measurements.
Before you resign yourself to creating multiple queries and Web reports, consider the alternative that Web Application Designer (Web AD) 3.0 or higher offers. A customized drop-down box function used with your BEx Analyzer query gives you the flexibility to create several reports in one report, showing each group of key figures by category in a drop- down box in your Web application.
Even though the Web AD has its own standard drop-down box Web feature, it is used mainly for filtering characteristic values and individual key figures. It does not display a series or combination of key figures together. When the item is launched to the Web, you see individual values of a characteristic or each key figure, depending on the usage of the web item. There is little benefit using the item in this way, especially if the navigational block has the same filtering ability.
Would you like to see this full item?