With no filler or unnecessary information, this BEx guide from the SAP PRESS Essentials series, cuts right to the chase, giving readers exactly what they need to master BW reporting. Readers learn the fundamentals of BEx, how to design queries, create high-impact workbooks and web applications, plus all there is to know about report-to-report interfacing - and more. This guide is based on the 3.5 version of BEx.
Reihe
Sprache
Verlagsort
Zielgruppe
Editions-Typ
Maße
ISBN-13
978-1-59229-086-4 (9781592290864)
Schweitzer Klassifikation
Autor*in
With 10 years of BW consulting and project management experience, Peter Scott focuses on the reporting capabilities of BW. As an international consultant he has worked on many project deliverables and has logged over 2000 classroom hours teaching BW reporting functionality. He sits on BW "Ask the Expert" panels and is certified in SAP BW.
Acknowledgements... 2
1 Fundamentals of BW Reporting... 3
1.1 Basics of Data Warehousing... 3
1.2 Basics of BW Design... 3
1.3 Business Explorer ( BEx ) Tools... 5
1.4 Summary... 9
2 The BEx Query Designer... 11
2.1 Overview of the BEx Query Designer... 11
2.2 Query Designer Layout... 12
2.3 Using the BEx Query Designer Toolbar... 13
2.4 Accessing InfoProviders... 14
2.5 Creating a Basic Query Definition... 15
2.6 Restricted and Calculated Key Figures... 16
2.7 Advanced Calculations... 20
2.8 Using Structures... 20
2.9 Creating Fixed Query Dimensions... 21
2.10 Using Characteristic Variables... 22
2.11 Creating Exceptions... 24
2.12 Creating Conditions... 25
2.13 Query Properties... 26
2.14 Summary .... 27
3 Creating High Impact Workbooks ..... 29
3.1 Overview of the BEx Analyzer... 29
3.2 Integration with Microsoft Excel... 29
3.3 Executing a Query... 29
3.4 Creating Custom Templates... 30
3.5 Creating a Workbook with Multiple Reports... 33
3.6 Auto-Refreshing Workbooks... 33
3.7 Using Text Elements... 34
3.8 Deleting and Detaching Results... 36
3.9 SAP Protection... 37
3.10 Saving and Distributing Workbooks ... 37
3.11 Summary... 38
4 Creating Web Applications... 39
4.1 BEx Web Analyzer... 39
4.2 BEx Web Analyzer Context Menu... 43
4.3 Overview of the Web Application Designer... 44
4.4 Web Application Designer Layout ... 44
4.5 Creating a Web Template... 48
4.6 Inserting Additional DataProviders... 50
4.7 Publishing Web Templates... 51
4.8 Printing Web Applications... 52
4.9 Summary ... 52
5 Report-Report Interfacing ( RRI )... 53
5.1 Overview ... 53
5.2 Defi ning Jump Targets... 53
5.3 Summary ... 56
6 NetWeaver 2004s BI Overview .......... 57
6.1 Changes to the BEx Query Designer .... 57
6.2 Changes to the Web Application Designer ( WAD )... 58
6.3 Changes to the BEx Analyzer... 60
6.4 BEx Report Designer... 62
6.5 Changes to the BEx Broadcaster... 64
6.6 The BI Accelerator ( BIA )... 64
6.7 Remodeling InfoCubes.... 65
6.8 Visual Composer... 65
6.9 Looking Ahead... 66
A. Glossary.67
B.Index.69
