SAP BW Professional: tips and tricks for dealing with SAP business information warehouse
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | German |
| Veröffentlicht: |
Bonn
Galileo Press
2004
|
| Schriftenreihe: | SAP Press
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | 418 S. Ill. |
| ISBN: | 1592290175 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV019727093 | ||
| 003 | DE-604 | ||
| 005 | 20050823 | ||
| 007 | t | ||
| 008 | 050308s2004 a||| |||| 00||| ger d | ||
| 020 | |a 1592290175 |9 1-59229-017-5 | ||
| 035 | |a (OCoLC)633027825 | ||
| 035 | |a (DE-599)BVBBV019727093 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a ger | |
| 049 | |a DE-1047 |a DE-473 |a DE-1051 | ||
| 084 | |a ST 510 |0 (DE-625)143676: |2 rvk | ||
| 084 | |a ST 610 |0 (DE-625)143683: |2 rvk | ||
| 100 | 1 | |a Egger, Norbert |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a SAP BW Professional |b tips and tricks for dealing with SAP business information warehouse |c Norbert Egger |
| 246 | 1 | 3 | |a SAP-BW-Professional |
| 264 | 1 | |a Bonn |b Galileo Press |c 2004 | |
| 300 | |a 418 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a SAP Press | |
| 650 | 0 | 7 | |a SAP Business Information Warehouse |0 (DE-588)4654214-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SAP Business Information Warehouse |0 (DE-588)4654214-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013054086&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-013054086 | ||
Datensatz im Suchindex
| _version_ | 1804133187348070400 |
|---|---|
| adam_text | Titel: SAP BW Professional
Autor: Egger, Norbert
Jahr: 2004
Contents
Foreword 13
Preface 15
Part 1 Conceptual Overview 17
1 Successful Strategic
Information Management 19
1.1 Foundations of Management Decision-Making 19
1.2 Changed Demands on Information Management 20
1.3 Conceptual Foundations 26
1.4 Required Enhancements 29
1.4.1 Integration of Systems and Applications 29
1.4.2 Providing and Distributing Information 31
1.4.3 Internal and external data 33
1.5 Translating Strategy into Action - The Balanced
Scorecard Method of Management 33
1.6 Successful Implementation and Operation of
Business Intelligence Solutions 37
Part 2 Introduction to SAP BW 39
2 SAP Business Information Warehouse-
Overview 41
2.1 Architecture of SAP BW 41
2.2 Storing Data in SAP BW 42
2.2.1 InfoObjects as the Foundation 42
2.2.2 InfoProviders 44
2.3 Data Retrieval 49
2.3.1 Components of the Data-Retrieval Process: DataSources 49
2.3.2 Components of the Data Retrieval Process: InfoSources 51
2.3.3 Components of the Data Retrieval Process: Update Rules 52
2.3.4 Components of the Data Retrieval Process: Requesting
the Data Transfer and Monitoring 53
2.3.5 Components of the Data Retrieval Process:
Persistent Staging Area (PSA) 54
2.3.6 The ETL Process 54
2.4 Reporting and Analysis Tools 54
2.4.1 SAP BW Components and Third-Party Tools 54
2.4.2 SAP Business Explorer—Query Designer 56
2.4.3 Web Application Designer 59
2.4.4 The Runtime Environment of Web Applications 61
2.4.5 SAP Business Explorer Analyzer 62
2.4.6 Additional SAP BW Reporting Functions 63
2.4.7 Reporting Agent 63
2.4.8 Reporting Functions and Frontends for SAP BW 64
2.5 Additional Functions and Components 65
2.6 SAP Business Content 66
2.7 The Position of SAP Business Information Warehouse 68
3 Step-by-Step: Profitability
Analysis with SAP BW 71
3.1 Introduction 71
3.2 Data Modeling 72
3.2.1 Sample Creation of an InfoObject of Type Characteristic 72
3.2.2 Sample Activation of SAP Business Content 74
3.2.3 Sample Creation of an InfoObject: Characteristic Type 79
3.2.4 Creating InfoCubes and a MultiProvider 83
3.3 Setting Up the Retrieval of Master Data 91
3.3.1 General Comments 91
3.3.2 Master Data Texts for the Product Croup from Interface Files . 91
3.3.3 Master Data Texts for the Product Main Group from
Interface Files 97
3.3.4 Master Data Attributes for the Product Group from Interface Files 97
3.3.5 Master Data Texts and Attributes for Materials from
SAP R/3 and Retrieving Data with SAP R/3 DataSources
and Interface Files 101
3.4 Retrieving Actual Data from SAP R/3 CO-PA 107
3.4.1 General Comments 107
3.4.2 Setting Up the DataSource in SAP R/3 107
3.4.3 Replicating the DataSource in SAP BW 109
3.4.4 Creating the InfoSource with Transfer Rules 110
3.4.5 Creating the Update Rules 112
3.4.6 Creating and Executing the InfoPackage for the Actual Data .... 120
3.5 Uploading Plan Data from a File 123
3.5.1 Creating the InfoSource with a Transfer Structure
and Transfer Rules for the Plan Data 123
3.5.2 Creating Update Rules for Plan Data 126
3.5.3 Creating and Executing the infoPackage for Plan Data 127
3.6 Creating an SAP Business Explorer Query 129
3.7 Executing the Query 134
3.7.1 Executing the Query as a Web Report 134
3.7.2 Executing the Query in Microsoft Excel 139
Part 3 Data Modeling and Data Retrieval 141
4 Data Modeling and Conversion from a
Column-Oriented InfoSource to an
Account-Oriented InfoCube 143
4.1 The Account-Oriented Data Model Versus the
Column-Oriented Data Model 143
4.1.1 Problems Associated with the Column-Oriented Data Model .. 143
4.1.2 The Account-Oriented Data Model 146
4.1.3 Comparing the Data Models 147
4.2 Practical Example: Combination of the Account-Oriented and
the Column-Oriented Data Model 148
4.2.1 Analyzing the Source Data 148
4.2.2 Data Model 150
4.3 Implementation: InfoCubes 151
4.4 Implementation: Data Retrieval 155
4.4.1 Setting Up the Update Rules for the InfoCube
Billing Document 155
4.4.2 Setting Up the Update Rules for the InfoCube
Order/Project Settlement 157
4.4.3 Setting Up the Update Rules for the InfoCube
Overhead Costs 159
4.5 Executing Data Retrieval 160
4.6 Performance Optimization and Reporting 162
5 Appropriate Mapping of the SAP
Product Hierarchy in Data Modeling,
Data Retrieval, and Reporting 167
5.1 The Material Attribute Product Hierarchy in SAP R/3 167
5.2 Storing the Material Attribute Product Hierarchy in SAP BW
Using the SAP Business Content Navigation Attribute 169
5.2.1 The SAP Business Content InfoObject Product Hierarchy
and The Associated Data Retrieval from SAP R/3 169
5.2.2 The SAP Business Content InfoObject Material and
the Associated Retrieval of Material Attributes from SAP R/3 .. 171
5.2.3 Problems with Using the SAP Business Content
Material Attribute Product Hierarchy in Reporting 173
5.3 Storing the Material Attribute Product Hierarchy in SAP BW
Using the SAP Business Content Hierarchy 176
5.3.1 Adjusting the SAP Business Content InfoObject Product Hierarchy
and the Associated Data Retrieval from SAP R/3 176
5.3.2 Using the Adjusted SAP Business Content Product Hierarchy in
Reporting 181
5.4 Solution Using a Step-Based Product Hierarchy as a Material Attribute 184
5.4.1 Creating the DataSource for the Step-Based Product Hierarchy 184
5.4.2 Creating the InfoObjects and Data Targets for the
Step-Based Product Hierarchy 186
5.4.3 Setting Up Data Retrieval for the Step-Based
Product Hierarchy in SAP BW 188
5.4.4 The Step-Based Product Hierarchy as a Navigation
Attribute for Material and Its Use in InfoCubes 194
5.4.5 Step-Based Product Hierarchy in Reporting 198
5.5 Advantages and Disadvantages of the Different Variants
for Mapping the Product Hierarchy 200
Part 4 Reporting and Web Applications
with the SAP Business Explorer 203
6 Using Sample Solutions to Show the
Important Functions of the Query
Designer in SAP BW 3.x 205
6.1 Introduction 205
6.1.1 Calling Up the Query Designer and Creating Queries 205
6.1.2 Including Characteristics and Keys in the Query 206
6.1.3 Selections (Restricting) 207
6.1.4 Saving Queries 209
6.1.5 Executing a Query 209
6.2 Reusable Objects 211
6.2.1 The Concept 211
6.2.2 Calculated Keys 211
6.2.3 Restricted Keys 214
6.2.4 Definition of Calculated and Restricted Keys with Mutual
Dependence 216
6.2.5 Structures 218
6.3 Properties of Query Elements 224
6.3.1 Properties of Keys 224
6.3.2 Properties of Characteristics and Structural Elements 228
6.4 Hierarchies 232
6.4.1 Introduction 232
6.4.2 The Use of Hierarchies in the Query Designer 233
6.5 Conditions 238
6.5.1 The Concept and the Available Types of Conditions in
SAP Business Explorer 238
6.5.2 The Use of Conditions in SAP Business Explorer 239
6.6 Exceptions 243
6.6.1 Visualization of Exception States 243
6.6.2 The Use of Exceptions in SAP Business Explorer 243
6.7 Variables 245
6.7.1 Introduction 245
6.7.2 Characteristic Variables 246
6.7.3 Hierarchy Variables 252
6.7.4 Hierarchy Node Variables 254
6.7.5 Text Variables 257
6.7.6 Formula Variables 259
6.8 Additional Selected Innovations in the Query Designer 262
6.8.1 Query Characteristics 262
6.8.2 Document Links 264
6.8.3 Calculating with Cells Using the Example Structure Percent .. 265
6.8.4 Tabular Reporting Using the Example of Main Data Reporting . 268
7 Selected Functions of the SAP BW
Web Application Designer in SAP BW 3.x 275
7.1 The Web Application Designer in the Framework of the
SAP Business Explorer Components 275
7.2 The Functionality of the Web Application Designer: Overview 277
7.2.1 Introduction 277
7.2.2 Web Items 277
7.2.3 Formatting 281
7.3 First Steps in the Web Application Designer 282
7.3.1 Starting the Web Application Designer 282
7.3.2 Creation of a Web Template Using the Web Application Wizard 282
7.4 Web Items in the Web Application Designer 286
7.4.1 Properties of Web Templates and Positioning of Objects 286
7.4.2 The Table 288
7.4.3 Text Elements 290
7.4.4 The Generic Navigation Block 294
7.4.5 The Drop-Down Box 297
7.4.6 The Radio-Button Group 301
7.4.7 The Checkboxes 306
7.4.8 The Hierarchical Context Menu 308
7.4.9 Filter 311
7.4.10 The Label 314
7.4.11 List of Exceptions 318
7.4.12 List of Conditions 320
7.4.13 Ticker 322
7.4.14 Chart 324
7.4.15 Map (Map Chart) 331
7.4.16 The Alert Monitor 339
7.4.17 The Role Menu 342
7.4.18 Individual Document 348
7.4.19 List of Documents 351
7.4.20 The Ad-hoc Query Designer 353
7.5 HTML Coding in the Web Application Designer 358
7.5.1 Introduction 358
7.5.2 The HTML Code of the Web Template 359
7.5.3 Manual Editing of the HTML Code in the
Web Application Designer 361
7.6 Conclusion 366
8 Sample Solution for an Extendable
Web Cockpit in SAP BW 367
8.1 Introduction 367
8.2 Creating the Queries and the Query Views 367
8.2.1 Time series query 367
8.2.2 Query According to Countries and Regions 369
8.2.3 Query View for the Chart Sales Development (Plan/Actual
Comparison) 369
8.2.4 Query View for the Chart Development of
the Relative Margins 371
8.2.5 Query View for the Chart and the Map Graphic
Distribution of Sales per Country 371
8.2.6 Query View for the Map Graphic with Margins 372
8.3 Creating the Web Template with the Charts 372
8.3.1 General settings 372
8.3.2 Web Items and Positioning 373
8.3.3 Assigning Data Providers to Web Items 376
8.3.4 Setting the Properties of the Web Items 378
8.3.5 Creating Hyperlinks 385
8.4 Creating the Web Template with the Role Menu 387
8.5 Creating the Title Web Template 388
8.6 Creatingthe Frameset 389
8.7 Linking with Other Reports Using the Report/Report Interface 390
8.8 Navigation in the WebCockpit 392
8.9 The Functions of the Sample WebCockpit 393
Appendix 395
A Structure of the InfoCubes from Chapter 3 397
A.1 InfoCube Result calculation actual data (ZCBWTIPP1) 397
A.2 InfoCube Result calculation plan data (ZCBWTIPP2) 399
A.3 Multiprovider Result calculation actual and plan data (ZCBWTIPP3) 400
B Structure of the InfoCubes from Chapter 4 403
B.1 InfoCube Result calculation invoice data (ZCBWTIPP5) 403
B.2 InfoCube Result calculation data proj./job accounting (ZCBWTIPP6) 404
B.3 InfoCube Result calculation overhead costs (ZCBWTIPP7) 406
B,4 MultiProvider Result calculation for all transaction
types (ZCBWTIPP8) 407
C Bibliography 409
D The Author 411
Index 413
|
| any_adam_object | 1 |
| author | Egger, Norbert |
| author_facet | Egger, Norbert |
| author_role | aut |
| author_sort | Egger, Norbert |
| author_variant | n e ne |
| building | Verbundindex |
| bvnumber | BV019727093 |
| classification_rvk | ST 510 ST 610 |
| ctrlnum | (OCoLC)633027825 (DE-599)BVBBV019727093 |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01335nam a2200349 c 4500</leader><controlfield tag="001">BV019727093</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20050823 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">050308s2004 a||| |||| 00||| ger d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1592290175</subfield><subfield code="9">1-59229-017-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)633027825</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV019727093</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">ger</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1047</subfield><subfield code="a">DE-473</subfield><subfield code="a">DE-1051</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 510</subfield><subfield code="0">(DE-625)143676:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 610</subfield><subfield code="0">(DE-625)143683:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Egger, Norbert</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SAP BW Professional</subfield><subfield code="b">tips and tricks for dealing with SAP business information warehouse</subfield><subfield code="c">Norbert Egger</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">SAP-BW-Professional</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Bonn</subfield><subfield code="b">Galileo Press</subfield><subfield code="c">2004</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">418 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">SAP Press</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SAP Business Information Warehouse</subfield><subfield code="0">(DE-588)4654214-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SAP Business Information Warehouse</subfield><subfield code="0">(DE-588)4654214-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013054086&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-013054086</subfield></datafield></record></collection> |
| id | DE-604.BV019727093 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T20:04:44Z |
| institution | BVB |
| isbn | 1592290175 |
| language | German |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-013054086 |
| oclc_num | 633027825 |
| open_access_boolean | |
| owner | DE-1047 DE-473 DE-BY-UBG DE-1051 |
| owner_facet | DE-1047 DE-473 DE-BY-UBG DE-1051 |
| physical | 418 S. Ill. |
| publishDate | 2004 |
| publishDateSearch | 2004 |
| publishDateSort | 2004 |
| publisher | Galileo Press |
| record_format | marc |
| series2 | SAP Press |
| spelling | Egger, Norbert Verfasser aut SAP BW Professional tips and tricks for dealing with SAP business information warehouse Norbert Egger SAP-BW-Professional Bonn Galileo Press 2004 418 S. Ill. txt rdacontent n rdamedia nc rdacarrier SAP Press SAP Business Information Warehouse (DE-588)4654214-0 gnd rswk-swf SAP Business Information Warehouse (DE-588)4654214-0 s DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013054086&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Egger, Norbert SAP BW Professional tips and tricks for dealing with SAP business information warehouse SAP Business Information Warehouse (DE-588)4654214-0 gnd |
| subject_GND | (DE-588)4654214-0 |
| title | SAP BW Professional tips and tricks for dealing with SAP business information warehouse |
| title_alt | SAP-BW-Professional |
| title_auth | SAP BW Professional tips and tricks for dealing with SAP business information warehouse |
| title_exact_search | SAP BW Professional tips and tricks for dealing with SAP business information warehouse |
| title_full | SAP BW Professional tips and tricks for dealing with SAP business information warehouse Norbert Egger |
| title_fullStr | SAP BW Professional tips and tricks for dealing with SAP business information warehouse Norbert Egger |
| title_full_unstemmed | SAP BW Professional tips and tricks for dealing with SAP business information warehouse Norbert Egger |
| title_short | SAP BW Professional |
| title_sort | sap bw professional tips and tricks for dealing with sap business information warehouse |
| title_sub | tips and tricks for dealing with SAP business information warehouse |
| topic | SAP Business Information Warehouse (DE-588)4654214-0 gnd |
| topic_facet | SAP Business Information Warehouse |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=013054086&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT eggernorbert sapbwprofessionaltipsandtricksfordealingwithsapbusinessinformationwarehouse AT eggernorbert sapbwprofessional |