SAP Database

Developer’s Guide on Enterprise Data Warehousing.

Download from (Rapidshare) or (Mediafire)

Table of Contents

1 ENTERPRISE DATA WAREHOUSING ……………………………….. 1
2 GETTING INVOLVED……………………………………. 2
2.1 The Data Warehouse Concept………………………………….. 2
2.1.1 Using a Data Warehouse ………………………………………. 2
2.1.2 Architecture of a Data Warehouse ……………………….. 2
2.1.3 Enterprise Data Warehouse (EDW) ……………………… 4
2.1.4 Building and Running a Data Warehouse ……………… 4
2.2 Working with the Development Environment ………………… 5
2.2.1 Data Warehousing Workbench ……………………………… 6
3 GO AND CREATE ……………………………………. ……………………… 9
4 CORE DEVELOPMENT TASKS ………………………………………….. 1
4.1 Developing Business Logic ………………………………………. 10
4.1.1 Recommendations for Modeling Layers………………….. 11
4.1.2 Recommendations for Modeling the Data Flow ……………………………………. 12
4.1.3 Recommendations for Modeling InfoCubes …………………………………………. 15
4.1.4 Recommendations for Modeling InfoSets ……………………………………………. 15
4.1.5 Recommendations for Modeling MultiProviders……………………………………. 16
4.1.6 Modeling …………………………………………………………………………………………. 17
4.1.7 Transformation ………………………………………………………………………………. 232
4.1.8 Data Transfer Process ……………………………………………………………………. 320
4.1.9 Scheduler ……………………………………………………………………………………… 336
4.1.10 Process Chain ……………………………………………………………………………….. 375
4.1.11 Non-Cumulatives ……………………………………………………………………………. 418
4.1.12 Installing BI Content ……………………………………………………………………….. 435
4.1.13 Customer and Partner Content ………………………………………………………… 444
4.2 Developing Persistency…………………………………………………………………………….. 507
4.2.1 Differences Between Data Stores …………………………………………………….. 507
4.3 Using Connectivity and Interoperability……………………………………………………….. 508
4.3.1 Data Acquisition……………………………………………………………………………… 509
4.3.1.2.5 Editing DataSources from SAP Source Systems in BI…………………………. 528
4.3.2 Real-Time Data Acquisition……………………………………………………………… 630
4.3.3 Open Hub Destination …………………………………………………………………….. 651
4.3.4 ICF Services in BI…………………………………………………………………………… 656
4.4 Considering Performance …………………………………………………………………………. 658
4.4.1 DB Storage Parameters ………………………………………………………………….. 659
4.4.2 Partitioning…………………………………………………………………………………….. 660
4.4.3 Clustering ……………………………………………………………………………………… 662
4.4.4 Performance Optimization for DataStore Objects ……………………………….. 663
4.4.5 Performance Optimization with Aggregates……………………………………….. 665
4.4.6 Performance Optimization with BI Accelerator……………………………………. 700
4.4.7 Compressing InfoCubes………………………………………………………………….. 735
4.4.8 InfoCube Performance ……………………………………………………………………. 736
4.4.9 Information Lifecycle Management …………………………………………………… 738
4.5 Applying Extensibility ……………………………………………………………………………….. 768
4.6 Enabling Globalization ……………………………………………………………………………… 768
4.6.1 Translating Text for BI Objects…………………………………………………………. 768
5 ENSURING QUALITY………………………………………………………………………………………. 773
5.1 Testing……………………………………………………………………………………………………. 773
5.1.1 BI Content Analyzer………………………………………………………………………… 774
5.1.2 Analysis and Repair Environment …………………………………………………….. 792
5.2 Debugging………………………………………………………………………………………………. 796
5.2.1 Update Simulation in the Extraction Monitor ………………………………………. 797
6 REFERENCE ………………………………………………………………………………………………….. 798
6.1 Interface Overview …………………………………………………………………………………… 798
6.1.1 DB Connect …………………………………………………………………………………… 799
6.1.2 UD Connect …………………………………………………………………………………… 800
6.1.3 BI Service API ……………………………………………………………………………….. 800
6.1.4 File Interface………………………………………………………………………………….. 801
6.1.5 Web Service for Staging………………………………………………………………….. 801
6.1.6 XI Integration …………………………………………………………………………………. 802
6.1.7 Staging BAPIs ……………………………………………………………………………….. 802
6.1.8 DataStore Object APIs ……………………………………………………………………. 802
6.1.9 Interface for Real-Time InfoCubes ……………………………………………………. 803
6.1.10 APIs for Master Data ………………………………………………………………………. 804
6.1.11 APIs for Hierarchies………………………………………………………………………… 804
6.1.12 VirtualProviders with Function Modules …………………………………………….. 805
6.1.13 Open Hub Destination …………………………………………………………………….. 805
6.1.14 Open Hub Destination APIs …………………………………………………………….. 806
6.1.15 Data Mart Interface…………………………………………………………………………. 807
6.2 Checklist for Developing BI Objects……………………………………………………………. 807