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.

Dr. Yasan Gooding

Yasan Gooding, Ph.D., is an information systems specialist with Valero Energy Corporation, Inc. He has worked with SAP NetWeaver BW for five years and works on the BW reporting systems front-end team developing, supporting, and gathering new reporting requirements for implementation to Valero's business units. He is a graduate of Saint Augustine's College and Iowa State University with majors in computer science and education.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.