Use parameters to make the file path dynamic

Question

commentary_test.rtf commentary.qfr.000022.202412.rtf when called with static link.png we have requirement in BI Publisher template to call template from External file in the folder mounted in BIP Server. I have two parameter which would be passed to the Main BIP template the above parameters data should replace the appropriate data in the link /commentary_qfr_000022_202412.rtf and based on this parameters , the link should dynamically call the file in the folder. so if the i pass the parameter as , the link should call - at runtime Any help on this is appreciated. Thank you

AJ_BI · Answer

We are currently reusing the file by replacing the  info in the file. But the requirement got changed where they want to maintain the file and so they will get us new file every month  with fund and date combination.

Kevin M-Oracle · Answer

Depending upon the requirement, can you reuse file names rather than use new names each month?

Rgds,

Kevin

AJ_BI · Answer

got it but there is problem. The files will be loaded every month and we want to automate that link in the template and I wouldn't know the name of the file it its uploaded to the shared folder. but I have parameters which user will supply on which file needs to called based on , so based on the Parameters, the import file name will change.