ITPub博客

首页 > 数字化转型 > ERP > BW--Create Data Warehousing: Step by Step(摘自SAP Library)

BW--Create Data Warehousing: Step by Step(摘自SAP Library)

原创 ERP 作者:qmhiro 时间:2007-10-18 23:52:42 0 删除 编辑
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
[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/132884/viewspace-977516/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    57
  • 访问量
    89291