SAP BW学习方法总结(2)

SAP培训：http://www.51sap.cn 3. LBWE中维护默认的LO数据源

点数据源后的Maintenance，再跳出的窗口中选择要添加的列。选择好之后点确定。完成之后交通灯变成红色。

点Maintenance后面的数据源名称，看到熟悉的DataSource维护界面，把添加Field的Hide Flag去掉。保存后交通灯变成黄色。

SAP培训：http://www.51sap.cn

点Inactive，激活数据源，交通灯变为绿色。此时再做Initialization。

在RSA3中可以看到，这个数据源已经有了新添加的列，而且自动取到了值。

SAP培训：http://www.51sap.cn 4. Direct delta / Queued delta / Unserialized V3 update

__Direct delta: 一个单据产生一个LUW，直接加到Delta Queue

With every document posting, the extraction data is transferred directly into the BW delta queue. Each document posting with delta extraction becomes exactly one LUW in the corresponding BW delta queue.

__Queued delta: 多个单据产生一个LUW。先放在extraction queue，经过Update collection run加到Delta Queue

The extraction data from the application is collected in an extraction queue instead of as update data, and can be transferred to the BW delta queue by an update collection run, as in the V3 update.

Depending on the application, up to 10000 delta extractions of documents per DataSource are summarized into one LUW in the BW delta queue.

__Unserialized V3 update: 先写入update table。经过Update collection run，加到Delta Queue。这种方法不考虑数据的顺序。

A V3 update module writes the extraction data for the application to the

update tables as before. The extraction data is stored in the update tables until it is read and

processed by an update collection run. The difference between this method and the serialized V3 update method is that the sequence of the data is not taken into consideration when the update collection run reads the data from the update tables and transfers it to the BW delta queue.

Queued Delta：能够确保单据按照顺序，适合数据量更大的用户。比V3效率高，也没有多语言问题。SAP 建议一个小时跑一次Collection。

SAP培训：http://www.51sap.cn 5. 主数据DELTA

ALE change pointer控制，已经在SAP R/3使用多年，用来在不同的R/3系统之间传输主数据。

6. Delta Management中的一些定义

Service API: Layer in the source system that sends requests and starts extractors.

Delta Management: A group of programs for the delta queue that controls the transaction data delta.

Delta Types: A term that describes how the data gets into the delta queue.

Serialization: The sequence in which the data records arrive in BW.

Record Mode: A description of the contents of a record.

Delta Method: A term that classifies a data source according to record mode, serialization, and delta type.

Delta Queue: A holding area for new and modified (delta) records in the SAP system.

7. 几种更新模式(Update Mode)

F Full

C Delta initialization D Delta

R Repeat 只有在delta更新出错是才有，系统会提示是否要repeat A 主数据Delta

SAP培训：http://www.51sap.cn 8. Delta type

E: PULLED DELTA. 例如LIS/COPA D: PUSHED DELTA. 例如FI LO

9. Update Mode: Repeat

__If the load fails, the delta queue displays a RED traffic light on the R/3 side. If this happens, BW

makes a second request for the delta of this particular DataSource. The system does not send any new delta records. It resends the same records as before (exception: LIS).

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库SAP BW学习方法总结(2)在线全文阅读。