本文主要是介绍BW--Create Data Warehousing: Step by Step(摘自SAP Library),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
Data Warehousing: Step by Step
Purpose
To build a data warehouse, you have to execute certain process steps.
Process Flow
1. Data modeling
○ Creating InfoObjects: Characteristics
○ Creating InfoObjects: Key Figures
○ Creating DataStore objects
○ And/or creating InfoCubes
○ And/or creating InfoSets
○ And/or creating MultiProviders
○ Or creating VirtualProviders
2. Metadata and Document Management
○ Installing BI Content
○ Creating documents
3. Setting up the source system:
○ Creating SAP source systems
○ And/or creating external systems
○ And/or creating file systems
4. Defining extraction:
○ For SAP source systems: Maintaining DataSources
○ Or for a SOAP-based transfer of data: Creating XML DataSources
○ Or for transferring data with UD Connect: Creating a DataSource for UD Connect
○ Or for transferring data with DB Connect: Creating a DataSource for DB Connect
○ Or for files: Creating DataSources for File Source Systems
○ Or for transferring data from non-SAP systems
○ Creating InfoPackages
5. Defining transformations:
○ Creating transformations
6. Defining data distribution:
○ Using the data mart interface
○ Creating open hub destinations
7. Defining the data flow:
○ Creating data transfer processes
○ Creating process chains
8. Scheduling and monitoring:
○ Checking process chain runs
○ Monitor for extraction processes and data transfer processes
9. Performance optimization:
○ Creating the first aggregate for an InfoCube
○ Or using the BIA index maintenance wizard
10. Information lifecycle management:
○ Creating data archiving processes
11. User management:
○ Setting up standard authorizations
○ Defining analysis authorizations
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1645161
这篇关于BW--Create Data Warehousing: Step by Step(摘自SAP Library)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!