Add Flat File name as Data Field in entry DSO

[Former Member]

Hello Experts,

We have massive Flat Files in Application Server. For Exsample:

AS_20160321_PCSW.csv

AS_20160421_PCSW.csv

....

All the flat files have the same columns. We use a ABAP Program to check if a Flat File is a new Flat File or not. IF a Flat File is a new Flat Flie, it will be loaded to a DSO. But some time we receive wrong Flat Flies from different local Systems. So we need to delete the corresponding Requests from DSO and from Infocube. This is very complicated for us.

We have a new idea that maybe it is possible to add the flat file Name as a Data Field in DSO, then we can use selective delection to delete the wrong data base on the File Name.

Is it a good idea ?

How is it possible to add the flat file Name as a Data Field in DSO?

[dgallegog]

Hello,

I have the same requirement:

Add the flat file Name processed by DTP as a Data Field in DSO

Did you find any solution?

Thanks and best regards David

[RafkeMagic]

So you would like to have the filename automatically filled out in your DSO?

In that case I assume you'll have to work with the "p_r_request" attribute of your DTP (assuming your loading via DTPs) which is type-referenced to "if_rsbk_request_admintab_view". You have a couple of methods available there, one of them being GET_TH_RANGE (which should hold the selections of your DTP - not 100% sure that your flat file name is part of that, but that's something you'll need to check in debug mode I guess).

[RafkeMagic]

of course it's possible, however up until (and including) BW release 7.3 you're limited to 60 chars, as of BW release 7.4 (SP02) you can go up to 1333 chars

[Former Member]

Thanks a lot, but I don't know how to add the file Name in Al11 to a Data Field in DSO.

Can you explain me how to do that ?

For exsample : Path in Al11

/exchange/ftp/400/AS_20160421_PCSW.csv

We would like add 'AS_20160421_PCSW ' as a Data Field in first layer DSO.

[RafkeMagic]

I guess it's possible if your flat file names are not too long and you're on BW < 7.4 (as of then you could use the "long" characteristics, so the length of your filename is no longer an issue).

However, if you're loading flat files from different local systems, I would suggest to load them into separate (first-layer) DSOs (to make file handling easier).

[Former Member]

Thank you very much.

you are right we will load the files from differen contries into separate first-layer DSOs.

But the files all are in al11. I would like to know if it possible to add the file Name in first layer DSO as a Data Field.