SAP Business Explorer (BEx) Tools
Maximize Business Explorer (BEx) tools
1st Edition
Published on 1. January 1970
Book
Hardback
71 pages
978-1-59229-086-4 (ISBN)
Description
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.
More details
Other editions
New editions
Book
05/2009
2nd Edition
SAP PRESS
€68.00
Article is exhausted, reprint undefined
Person
Author
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.
Content
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
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