BEx Ad Hoc Report - Part I

BEx Ad Hoc Report - Part I

Preface

This page is to give an overview of basic terms and concepts for BW Reporting, and tell you how to create a basic Ad Hoc Query in BEx Query Designer.

[@more@]

Terms and Concepts
# Key Figures
# Dimensions
# Characteristics
# Free Characteristics
# Attributes
# Filters

Preparation
Required is InfoProvider, such as InfoCube, ODS, InfoSet and Characteristic Data Target, etc.

Creating a basic Ad Hoc Query
At the moment I'm using the SAP BW 3.5.

OK, please follow me, step by step:

1. Open Query Designer.

2. Select your System.



3. Type your Client, User, Password and Language, and click OK to continue.



4. Please click New Query button to create a query in BEx Query Designer.



5. Select a InfoProvider and click OK to continue.



6. Your are working at BEx Query Designer now.



7. Drag/Drop your object to Filters Area, Free Characteristics Area, Rows Area and Columns Area.



8. Chek your Query and Save it.



9. Type Technical Name and Description for your Query in Save Dialog Box.



10. Query is saved.



11. Click Display Query on the Web button.



12. Aha, Viey nice.



13. Like as BEx Analyzer, you can set filter value, drilldown, sort, difine exception and condition, etc.
Please click Exception and Conditions button if you want to set exception.



14. Click Create button to define a new exception.



15. Define Exception and click Transfer to continue.



16. Exception is created. The cells of Quantity Column displayed difference colours.



17. You can close the section of Exception and Condition.

18. 18. The screenshot of Web Report after closing Exception and Condition definition section.



19. You can do "drilldown" as well as other operations like as BEx Analyzer.



20. Now, return the Query Designer and define a physical exception



21. Defining Exceptions for Exception Values.



22. Defining Exceptions for Validity Area of Exception.



23. The Monitor Icon displayed at Status Bar.



24. Display Query on the Web after Checking and Saving.



25. Query Execution..



26. You can Active/Deactive Exceptions.



27. The screen refereshed after deactiving exception.



28. Comparing Report between Web and MS Excel.



29. You can set the calculation type of results both BEx Analyzer and Web.



30. The Price of Overall Result row is calculated by average method now.



31. Please extend the Enhanced Menu.



32. Change the calculation type.


33. The result changed right now.




For more imformation, please refer to
BEx Ad Hoc Report - Part II and
BEx Ad Hoc Report - Part III.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/175419/viewspace-914579/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/175419/viewspace-914579/