3.X Dataflow

[Former Member]

Hi

I am trying to understand one 3.x dataflow in 7.x BI (source is SAP R/3)

Dataflow:

Datasource(emulated)>transfer rules>Infosource>Update rules>DSO>Update rules>Infocube

Datasource(emulated) settings:

Delta process:Full upload(Delta from infopackage selection)

Direct access:Allowed

Real Time:Not supported

Adapter:Access to SAP data through service API

Dataformat_fixed length

Infopackage at datasource level:

Full update

In selection screen,SELECT_P_BUDAT,they have input number '2'.Text shows it as 'Get last month'

This infopackage loads data to PSA and then to DSO.I observed that in DSO it shows monthly data.

Now from DSO to cube,data is sent using export datasource 8xxx in typical 3.x way.

This export datasource have settings:

Deltaprocess:ODS Datastore OBJECT EXTRACTION

Direct access:allowed(pre-aggregate data in extractor)....

Real time:not supported

Adapter:access to SAP through service SAPI

The infooackage for this datasource sends data from DSO to cube and was set to delta update and has no selection.

I checked that data is uploaded to cube on monthly basis.

now my doubt is about how this dataflow is working:

1.if datasource and infopackage below DSO have settings full update and selection screen has settings ofr taking only last month data(number '2'),does it mean we are not capturing deltas from previous months?how do we find out how deltas are handled here....

2.Same question relates to export datasource and infopackage between DSO and cube...it has delta settings and no selection in selection screen...so it means all changes to old records in DSO from previous month plus new records this month will be loaded to cube.

3.Is the datasource used to bring data from SAP R/3 source to DSO ,a generic one?How to find out if its a generic one or not?

4.In fields list in THIS datasource bringing data from source,there are some fields with tech name SELECT_P_BUKRS eventhough there is another fields named BUKRS...what does this mean?

I am a bit confused to understand this delta process between datasource ->DSO->CUBE with these settings...can anybody share their understanding related to this dataflow?

Thanks............

[Former Member]

Hi ,

Ans 1 :- This is basically called the Pseudo Delta functionality in SAP BI. Pseudo Delta means Full data load with some selection in the IP. Logically its a full data load but delta is being handled by the selection where it captures all the data of the datasource for the last month only.To check the data moved to BW you can simply run the data source in RSA3 with setting as FULL and providing the selection similar to the Infopackage in the BW.

Ans 2 :- Delta from DSO to Cube is based on the request level. All the requests of the DSO which are new and not have been updated to the Cube only go to the cube on execution of delta load from DSO to cube. That is if this data load happens everyday then it will only send the current day's request to the cube.

Ans 3 :- Generally generic datasources start from Z letter. However you can chech the datasource properties from RSA2 or RSO2 in the R/3 system.

Ans 4 :- SELECT_P_BUKRS field is most probably the cutome field which has been included in the datasourc structure for some business needs. You need to understand this logic from teh design document of the datasource.

Navesh