您的位置:首页 > 电脑网络 > 软件 > record mode

record mode

luyued 发布于 2011-01-04 05:17   浏览 N 次  

感谢夜莺的提示,让我这两天开始研究了下record mode。

在SDN上看了些资料,来整理一下写下来,如有错误以后发现了再改正。

大体上来说,record mode分为三大类。

不过我还是决定把所有的都一个个打到这里来,不想copy,自己打一遍更有个印象。

空 delta only via full upload (ODS or Infopackage selection)

A ALE Update Pointer(Master data)

ABR Complete Delta with Deletion Flag via Delta Queue(Cube-Comp)

ABR1 Like Method "ABR" but Serialization only by Requests

ADD Additive Extraction Via Extracto (e.g LIS Info Structures)

ADDD Like "ADD" But Via Delta Queue(CUBE-Compatible)

AIE After-Images Via Extractor(FI-GL/AP/AR)

AIED After-images with Deleteion Flag via Extractor(FI-GL/AP/AR)

AIM After-images via delta queue(e.g. FI-AP/AR)

AIMD After-images with Deletion Flag Via Delta Queue(e.g. BtB)

CUBE Infocube Extraction

D Unspecific delta via delta queue (Not ODS-compatible)

E Unspecific delta via Extractor (Not ODS-compatible)

FIL0 Delta Via file import with After-images

FIL1 Delta via file import with Delta-images

NEWD Only new records(Inserts) via delta queue(Cube-compatible)

NEWE Only new records(Inserts) via Extractor (Cube-compatible)

O

ODS ODS Extraction

X Delta Unspecified(Do Not Use!)

大体上来说,record mode分为三大类。(目前来说我用得到的。)

(1)ADD->additive image->DSO/CUBE
(2)ABR->after image,before image, reverse image->DSO/CUBE
(3)AIM/AIMD->after image only->must be DSO first

其中:

(1)是serialization by request,意思是通过每一个request来进行增量更新,这样的目的是保证(非主键的)所有新增或更改记录能成功写入DSO/CUBE。
(2)(3)是serialization by delta packet,意思是通过增量队列来进行增量更新。
这个区别我还没有弄很明白。现只能说这些。

而上面三种类型又可细分为是通过extracotor来抽取呢还是通过delta queue来抽取。
下面说via extractor和via delta queue.

(1) via delta queue->所有LO Extractor的增量模式都是通过这个来抽取的。Extraction queue->delta queue(RSA7)->BW
这是一种push模式,即数据是被推进BW端的。R3这边的job control安排好后,到时间点时会把数据推进RSA7,即datasource就有数据了。BW那端只管用infopackage抽到PSA就行了。有setup table.

(2)via extractor->COPA,FIGL,AP,AR,Generic datasource等都是通过这种形式。这是一种“拉”的模式,需要BW那边主动进行request要求才能把数据从R3拉到BW里面去。此时,数据是不经过RSA7的,或者说,RSA7是空的。直接就到BW里面去了。那数据是怎么流通的呢?因为有timestamp(其实不止这个,还有calday,numeric pointer两种。共三种,看怎么设置)。这个在SE16->BWOM2-TIMEST表里面可以看到。
而且,这类datasource是没有setup table的。

而AIE就是after-image via extractor, 而AIM是通过after-image via delta queue。RSA6里面看FI的datasource,会发现:0FI_AR_3和0FI_AP_3都是AIM,如果做测试,这两个的增量记录肯定在RSA7中会有记录显示。而其他的都是AIE,就不会在RSA7中显示了,直接到BW中去了。

对于RSA6里面的标准的数据源,我们是不能对其增量模式进行更改的。当然,了解其现有的增量模式很重要!主要是我们自己在做建datasource时,一定要分清楚用哪种增量模式。

-------------------------------------------------------------------------

SDN上拿过来的一个较好的回答。

When a Delta InfoPackage for the DataSource 0FI_GL_4 is executed in SAP NetWeaver
BI (BI), the extraction process in the ECC source system mainly consists of two activities:
- First the FI extractor calls a FI specific function module which reads the new and
changed FI documents since the last delta request from the application tables
and writes them into the Delta Queue.
- Secondly, the Service API reads the delta from the Delta Queue and sends the FI
documents to BI.............

DataSource 0FI_GL_4 (General ledger: Line items via delta extraction) has the
delta process :AIE..........with delta type :E...... (pull)...............Because this is a delta type .....pull......., the delta data records are determined during the delta update by the DataSource extractor,....... updated to the delta queue and passed on to BI directly from there...........due to this u r unable to find any records in RSA7.............
Another point.............. The DataSource only returns the after images. Direct updating into
InfoCubes is not possible for this Business Content DataSource.............First........... a
DataStore object in the data flow has to be addressed that updates key figures with the update type................overwrit........... to the update rules...

--------------------------------------------------------------------

发现其实官网上讲得很清楚了。

Delta Procedure

With delta extraction, only new data or data that has changed since the last extraction is loaded into SAP BW. Data that has already been loaded and has not changed is not extracted and does not need to be deleted before a new load. This improves performance compared with periodic extraction of the entire dataset.

The respective extractors read the Financial Accounting transaction figures directly from the SAP R/3 tables. A time stamp on the transaction figures determines the delta dataset. Time stamp intervals that have already been read are then stored in a time stamp table. The delta dataset is transferred directly, without records being transferred to the delta queue in the SAP R/3 system (extractor delta procedure).

The transaction figures are extracted from the SAP R/3 system in their most recent status (after-image delta procedure). This delta procedures is not suitable for filling InfoCubes directly in the BW system. The transaction figures must therefore first be loaded in an ODS object that determines the changes to individual characteristics and key figures within a delta data record. Other data destinations (InfoCubes, ODS objects) can be provided with data from this ODS object.

If the ODS object permits BEx Reporting, queries can be defined directly there.


MSN空间完美搬家到新浪博客!

广告赞助商