Process chain validation

[former_member188760]

I would like to validate the process chain data loaded with latest date or not.

There is one Process chain running daily in BW from third party vendor.

Once they submit the flat file to Webmethods, then the Process chain in BW triggers the Program(process type) to get the file in BW and continues to load to DSO and Info cube.

The issue is sometimes the third party vendor submits duplicate file(yesterdays file again), so this creating some problem while running the reports to user.Every time they creates P2 for the latest data.

Can anyone suggest how to create a program process in process chain whether the data loaded with latest date(I have field Date with latest date in DSO and Cube) to validate.?So that the process chain fails once the data is old date or duplicate file submitted.If we create any exception this will create Dump, so the dump should not be created)

[former_member197660]

Hi Anil

As Ashish rightly mentioned, if you have Standard DSO in between then the second load will not generate any deltas for Infocube if the key figures have "Overwrite" update mode.

Please specify the pain point further if this is not the problem.

Ashish

[former_member188760]

Hi All,

Actually i need read the File name path which is loaded from infopackge.

This is stored in one particular Table i presume. where the path of the Flat file stored when we we load the file from Infopackge.

In IP Monitor screen ---> under Header Tab we have Flat File Name details:

File Name: /SHARE/xxx/SAP_DATA/xxx/DATA/xxx/xxx/xxx.csv.20141105

(Application server in AL11)

So i would to read the Date of the file loaded in the above.How to rad the date from the above path when we load the file from IP.?

Thank in advance

[Former Member]

Hi Anil,

As you are using DSO the data should override.

Still you can handle duplicacy of data using " Delete Overlapping Request " option in process chain.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0431c48-5ba4-2c10-eab6-fc91a5fc2...

Hope this helps,

Regards,

[abhishek_shanbhogue2]

Hello Anil,

Validating the data might be technically feasible using a program and dummy table to compare the data but its not advisable as the runtimes increase with the data volume.

I would suggest you to place the file everyday in one shared location and use a ABAP program OR system command + Unix Script to rename the file with the date and save it another location with date and time stamp appended to the file name and use the second path for Info Package

Ex: File name for today will be XXYYZ_11_03_2014 and for tomorrow it will be XXYYZ_11_04_2014

Thanks

Abhishek Shanbhogue

[former_member188760]

Hi All,

Can anyone give any update on this ?

Thanks