cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic File Name generation

Former Member
0 Kudos

Hi Experts,

My requirement is, I need to post a file from BW server through Open hub destination where the filename must be incremented on each time they get posted.

(Eg: My FIle name is G70000. When they are posted at first, the file name will be G70000. Next time when the file gets posted the filename must be G70001.) so they must be incrementing on each posting.

Could you please suggest me some ways to solve this issue.

My settings are:

Physical Path is /IMS/DV8_080/VTIMS/OUT/DATA/<FILENAME>

Logical File Name Definition, Cross-Client

Physical file: G70000.csv

Regards,

Ganapathi.

Accepted Solutions (0)

Answers (2)

Answers (2)

Shabarish_Nair
Active Contributor
0 Kudos

/people/shabarish.vijayakumar/blog/2009/10/05/pixi-maintaining-sequence-numbers-in-file-name-scheme this might give u some ideas

Former Member
0 Kudos

Thanks for your reply.

But could you please let me know whether it is possible in open hub destination? i.e. from BW to OHD.

Thanks,

Ganapathi.

Former Member
0 Kudos

Hi,

If you are connnecting using the file adapter, this is possible.

Regards

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi,

Create one table in PI Abap stack ,and store intial value.then perfrom look up to retrive the intial value and increment by 1 and store update value in abap table once again.

then use dynamic configuration UDF to genarate file name .

Regards,

Raja Sekhar