SAP培训：http://www.51sap.cn
SAP培训：http://www.51sap.cn
SAP培训：http://www.51sap.cn
17. BW中的SD凭证流
SAP培训：http://www.51sap.cn
3个ODS做INFOSET。注意“左外连接”。
18. 如何减少维度表的大小
? 定义“LINE ITEM DIMENSION”
? 只把有关系的特性放在一个维度（如果把物料、客户放在同一个维度，将导致维度
表行数 = 物料数量 × 客户数量） ? 避免使用过于细碎的特性
? 如果不能避免使用过于细碎的特性，创建聚集
? It is also worthwhile to try the checks in transaction RSRV. Use for example RSRV All
Elementary Tests –》 Transaction Data –》 Entries Not Used in the Dimension of an InfoCube.
19. 删除PSA数据
Delete Persistant Staging Area (PSA) data
Frequency: Weekly
Determine a defined data retention period for data in the PSA tables. This will depend on the type of
SAP培训：http://www.51sap.cn data involved and data uploading strategy. As part of this policy, establish a safe method to periodically
delete the data. If the PSA data is not deleted on a regular basis, the PSA tables grow unrestricted.
Very large tables increase the cost of data storage, the downtime for maintenance tasks and the
performance of data upload.
From BW 3.X, request deletion is integrated in Process Chains. For further information on how to
delete requests from the PSA, refer to the SAP Help Portal documentation:
http://help.sap.com ", SAP NetWeaver ", SAP Business Information Warehouse ", Release ", Administrator Workbench ", Administration ", Monitoring ", Persistent Staging Area ", Deleting Requests from the PSA