is it possible to schedule the Flat File Loads in BW?

[Former Member]

Hi,

i got to know we can schedule Flat File loads in BW. For that we need to write the coading. can any body guide me how can i achieve that.

I have seen Create Routine push button in External Tab Page. can any body guide me how can i achieve that..

Thanks in Advance.

Nagesh.

[Former Member · Accepted solution]

Hi nagesh,

There are multiple ways of doing flat file loads.

1. If the files are dumped in a particular folder on the app. server.

- In the InfoPackage, you have "CREATE ROUTINE". Write a code which basically updates a custom table containing the file names and always picks the one which is not loaded already. Apart from that fill the file name too.

- This routine can take one file at a time.

2. Custom program / Event triggerring

- Maintain three folders.

+ Folder A: Files being dropped to be processed.

+ Folder B: OutFile folder

+ Folder C: BackUp / Processed Files

- In the custom program create a out file in folder B with constant file name. Before triggereing the event drop the file in folder C and delete it.

- Repeat this process until all files are processed.

Regards

Praveen

[Former Member · Accepted solution]

i want to process upload a file into BW every day . how can i schedule that.

if i want to schedule that Info package, it won't support for scheduling. it's disabled for info package.

can i keep that in Process chain?

Nagesh.

[Former Member · Accepted solution]

Hi Nagesh,

If you are using Procedure 1 (Routine in InfoPackage), then it should be possible.

Regards,

Praveen

[former_member188975 · Accepted solution]

Hi Nagesh,

You can do it through process chain. We are using such a scenario. But for this the file needs to reside on the application server, not on your PC. Also the daily files need to have the exact same name and location, else the load will fail.

Hope this helps...

[Former Member · Accepted solution]

can u elaborate it. i want to upload flat file data from application server. File name is same for every time, i don't think there is a need of routine.

i created process chain and i executed that it is giving errors.

i have a file(fixed file name), ODS Object, i created info package. how can i keep that in Process chain. Data in the file will be refreshed every day. file name is same and fixed.

Nagesh.

[former_member188975 · Accepted solution]

What is the error message in the process chain execution?

[Former Member · Accepted solution]

Bhanu, what ever scenario you are workign that is exactl suits my requirement. can you explain it detail.

i created process chain.

start--> Infopackage(Flat file Infopackage) --> ODS activate.

Nagesh.

[former_member188975 · Accepted solution]

That's what it is: Start > Execute InfoPackage > Load further from PSA > Activate ODS > Load to cube.

What error is your Process Chain giving?

[Former Member · Accepted solution]

Still my info package is accesing client work station. I will keep it in Application server. I will proces that. i will let you people know by tommrow.

i assigned points to all you guys(Bhanu, Praveen and Edan Hayut ).

thanks a lot.

Nagesh.

Message was edited by: Nagesh Ganisetti

[former_member188975 · Accepted solution]

Once you have put your file in the application server, you will need to change the path in the InfoPackage too.

Hope this helps...

[Former Member]

Hi

If you are loading data from a file why do you need to write code?

if you need to manipulate the data its best to it in the Start Routine area.

To schedule the loading all you have to do is schedule the package job using batch management (SM37).

Reg's

Edan

[former_member188975]

Hi Nagesh,

It is possible to schedule and automate the load of flat files, but it is not needed to use a routine for that...can you explain a bit more what you are looking for, so that we can suggest accordingly...