Sap Bw Reporting And Analysis

by Egger, Norbert; Fiechter, Jean-Marie R.; Rohlf, Jens; Rose, Jorg; Schruffer, Oliver

• ISBN13: 9781592290451
• ISBN10: 1592290450
• Edition: 1st
• Format: Hardcover
• Copyright: 2006-05-30
• Publisher: Sap Pr America

Table of Contents

Preface	13	(2)
Foreword	15	(2)
Introduction and Overview	17	(1)
Introduction	17	(1)
Structure of the Book	18	(1)
Working with This Book	19	(1)
After You've Read the Book	20	(1)
Acknowledgements	20	(2)
Special Thanks	22	(1)
Data Warehousing and SAP BW	23	(30)
Introduction	23	(1)
The Data Warehouse Concept	23	(3)
Basic Characteristics of a Data Warehouse Solution	26	(12)
Data Acquisition Layer	27	(4)
Metadata Management	31	(2)
Data Storage Layer	33	(4)
Data Presentation Layer	37	(1)
Architecture of SAP BW: Overview	38	(15)
Data Acquisition in SAP BW	41	(2)
InfoSources	43	(1)
Update Rules	44	(1)
Requesting the Data Transfer and Monitoring	45	(1)
Data Storage in SAP BW	46	(5)
Reporting and Analysis Tools	51	(2)
Data Retrieval Concepts and Their Implementation in SAP BW	53	(34)
Introduction	53	(5)
Deductive versus Inductive Analyses	57	(1)
Process Steps Involved in Data Retrieval	58	(8)
Preparation	58	(2)
Presentation	60	(1)
Information Distribution	61	(2)
Data Mining and Advanced Analytics	63	(3)
The Data Retrieval Components of SAP BW	66	(21)
Overview	67	(2)
SAP Business Explorer Query Designer	69	(4)
SAP Business Explorer Web Application Designer	73	(2)
The SAP Business Explorer Web Applications	75	(1)
SAP Business Explorer Analyzer	76	(1)
SAP Business Explorer Information Broadcasting	77	(2)
Additional SAP BW Reporting Functions of SAP Business Explorer	79	(1)
The Analysis Process Designer and the Data Mining Workbench	80	(3)
The Reporting Agent	83	(3)
Frontends for SAP BW	86	(1)
Sample Scenario	87	(12)
The Model Company: ``CubeServ Engines''	87	(2)
Company Structure	87	(1)
Infrastructure	88	(1)
Requirements of the Case Study	89	(3)
Requirements of the Analytical Applications	90	(2)
Planning Requirements	92	(1)
Procedure and the SAP Components Involved	92	(2)
Details of Reporting Requirements	94	(5)
Queries and Query Components	94	(2)
Web Templates and Web Items	96	(1)
Information Broadcasting	97	(2)
The SAP Business Explorer Query Designer	99	(100)
Data Analysis with SAP Business Information Warehouse -- The Query Concept	99	(12)
Functional Overview of the BEx Query Designer	100	(8)
Overview of Query Elements	108	(1)
Global and Local Query Definition	109	(2)
Reusable Query Elements	111	(17)
Flexible Query Control with Variables	112	(1)
Calculated Key Figures	113	(4)
Restricted Key Figures	117	(5)
Restricted and Calculated Key Figures with Mutual Dependencies	122	(2)
Global Structures	124	(4)
Definition of Data	128	(37)
Filtering Characteristics (Selections)	128	(6)
Calculation in Formulas	134	(15)
Calculation in the Display	149	(3)
Data Definition in Cells	152	(4)
Currency Translation	156	(6)
Constant Selections	162	(3)
Presentation and Formatting	165	(13)
Hierarchies--an Overview	165	(3)
Presentation of the Structure	168	(1)
Presentation of Structure Elements	168	(3)
Presentation of Characteristics	171	(4)
Tabular Presentation	175	(2)
Query Properties	177	(1)
Variable Definitions in Detail	178	(12)
Characteristic Value Variables	181	(1)
Hierarchy Variables and Hierarchy Node Variables	182	(1)
Text Variables	183	(1)
Formula Variables	184	(3)
SAP and Customer Exit Variables	187	(3)
Analysis Functions	190	(6)
Conditions	190	(3)
Exceptions	193	(3)
Query Views	196	(2)
Conclusion	198	(1)
The BEx Web	199	(166)
The Web Framework of SAP: Terms and Functions	200	(16)
Web Items	201	(4)
Data Provider	205	(1)
Web Templates and Web Applications	205	(1)
Web Report	206	(1)
Object Tags	206	(1)
Query versus Query Views	206	(5)
Command URLs	211	(1)
Cascading Style Sheets	211	(3)
JavaScript	214	(2)
The BEx Web Application Designer	216	(11)
The Menu Bar	217	(4)
The ``Web Items'' Window	221	(1)
The ``Template'' Window	222	(2)
The ``Properties'' Window	224	(3)
The BEx Web Analyzer	227	(4)
The BEx Web Application Design	231	(29)
Customizing Settings for Web Reporting	231	(8)
Object Tags	239	(4)
Language Dependency of Web Applications	243	(6)
The Properties of the Web Template	249	(8)
Data Providers	257	(3)
Web Items in Detail	260	(85)
Table	271	(5)
Chart	276	(5)
Dropdown Box	281	(3)
Generic Navigation Block	284	(3)
Label	287	(2)
Alert Monitor	289	(3)
Role Menu	292	(4)
Ticker	296	(1)
Object Catalog of the Web Application	297	(2)
Data Providers--Information	299	(1)
Individual Document	300	(3)
Web Template	303	(2)
Query View Selection	305	(4)
Ad-hoc Query Designer	309	(6)
Example: Sales Analysis with ``Query View Selection''	315	(6)
Example: Menu-Controlled Web Cockpit Providing Maps and Hierarchical Filter Selection	321	(14)
Example: Simple Web Cockpit for Personnel Administration	335	(10)
Web Item Library	345	(5)
Command URLs	350	(4)
Web Design API for Tables	354	(8)
BEx Mobile Intelligence	362	(3)
Information Broadcasting	365	(58)
Problem	365	(2)
Sending Reports via Information Broadcasting	367	(23)
Direct Delivery of Offline Reports via E-mail	367	(5)
Periodic Delivery of Offline Reports via E-Mail	372	(6)
Sending Offline Reports Containing Filter Navigation via E-Mail	378	(7)
Direct Delivery of Navigation Statuses as Online Links	385	(5)
Publishing Reports in SAP Enterprise Portal via Information Broadcasting	390	(12)
SAP BW Components and the SAP Enterprise Portal	390	(2)
Publishing Online Reports into the User-Specific ``My Portfolio''	392	(3)
Publishing Offline Reports into the User-Specific ``My Portfolio''	395	(4)
Publishing Online Reports in the BEx Portfolio	399	(3)
Publishing Reports in SAP Enterprise Portal via BEx Broadcaster	402	(10)
The BEx Broadcaster in SAP Enterprise Portal	402	(1)
Publishing Web Templates in SAP Enterprise Portal via the BEx Broadcaster	403	(3)
Publishing Web Templates in SAP Enterprise Portal via the BEx Broadcaster	406	(6)
Finding Content in SAP Enterprise Portal	412	(3)
Information Broadcasting During Report Execution	415	(8)
Publishing Reports Directly from Running Web Applications	415	(8)
SAP Business Content	423	(22)
Elements of SAP Business Content	424	(1)
Using SAP Business Content for Reporting	424	(1)
SAP Business Content Roles	425	(3)
SAP Business Explorer Workbooks	428	(2)
SAP Business Explorer Web Templates	430	(7)
Web Items	435	(2)
Queries	437	(4)
Query Views	438	(1)
Query Elements	439	(2)
Currency Translation Types	441	(2)
Conclusion	443	(2)
A. Abbreviations	445	(2)
B. Queries	447	(26)
Query ZECOPAM1Q00003	448	(3)
Query ZECOPAM1Q00005	451	(3)
Query ZEKDABC1Q00001	454	(2)
Query ZECOPAM1Q0001	456	(2)
Query ZEC0PAM1Q0003	458	(2)
Query ZEKDABC1Q0001	460	(2)
Query 0CSAL_C03_Q0003	462	(2)
Query OPCA_C01_Q0005	464	(2)
Query 0PCA_C01_Q0012	466	(2)
Query 0PUR_C01_Q0011	468	(1)
Query 0SD_C01_Q030	469	(2)
Query 0SD_C05_Q0007	471	(2)
C. Formula Operators	473	(6)
Percentage Operators	473	(1)
Deviation Percentage (%)	473	(1)
Percentage (%A)	473	(1)
Percentage in Preliminary Result (%CT)	473	(1)
Percentage in Overall Result (%CT)	473	(1)
Percentage in Reporting Result (%RT)	474	(1)
Data Functions	474	(1)
Count ()	474	(1)
NDIVO ()	474	(1)
NODIM ()	475	(1)
NOERR ()	475	(1)
Totals Operators	475	(1)
Subtotal	475	(1)
Total	475	(1)
Report Total	475	(1)
Boolean Operators	476	(3)
Relational operators ==, <>, <, >, <=, >=	476	(1)
Logical And (AND)	476	(1)
Logical Or (OR)	476	(1)
Logical Exclusive Or (XOR)	476	(1)
Logical Not (NOT)	476	(1)
LEAF ()	477	(2)
D. Attributes and Values of BEx Web	479	(26)
CSS Formats	479	(6)
Web Items: General Attributes	485	(1)
Web Items: Specific Attributes	486	(16)
Table	486	(1)
Chart	487	(1)
Dropdown Box	488	(1)
Radio Button Group	488	(1)
Checkboxes	488	(1)
Generic Navigation Block	489	(1)
Hierarchical Filter Selection	490	(1)
Filters	490	(1)
Label	491	(1)
Text Elements	491	(1)
Alert Monitor	492	(1)
Role Menu	493	(1)
Ticker	494	(1)
Map	495	(1)
Individual Document	496	(1)
List of Documents	497	(1)
Data Provider--Information	497	(1)
Object Catalog of the Web Application	498	(1)
Web Template	498	(1)
Broadcasters	499	(1)
Key Figures--Overview	499	(1)
Query View--Selection	500	(1)
Ad-Hoc Query Designer	501	(1)
ABC Classification	501	(1)
Simulation Prediction	502	(1)
Properties of the Web Template	502	(3)
E. Transaction Codes	505	(4)
Transactions in SAP BW	505	(3)
SAP R/3 Transactions Relevant to SAP BW	508	(1)
F. Metadata Tables	509	(4)
InfoObject	509	(1)
InfoCube	509	(1)
Aggregate	510	(1)
ODS Object	510	(1)
PSA	510	(1)
DataSource (= OLTP Source)	510	(1)
InfoSource	511	(1)
Communications Structure	511	(1)
Transfer Structure	511	(1)
Mapping	511	(1)
SAP BW Statistics	512	(1)
G. Glossary	513	(48)
H. Literature	561	(2)
I. The Authors	563	(4)
Index	567