BIP Dynamic Output filename to email destination

Ian.Gooderham

Hello all,

Is there a way of having a dynamic output filename for scheduled BIP reports going to an email destination?

I have managed to do this using a bursting definition, however bursting does not support filetype xlsx.

I have tried to_char(sysdate,'YYYYMMDD'), %y%m%d etc, but not had any luck - is there some secret syntax/tips anyone has? or is this not possible?

Many thanks,

Ian

Mallikarjuna Kuppauru-Oracle

Hi @Ian.Gooderham

Verified the Product features, We don't have any option for Email delivery to change the report output with customer format like Date embedding . But you can able to customize file name using other destination types like FTP..etc.

I hope i have answered your question.

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @Ian.Gooderham

You can refer below blog which is similar to your quesiton -

https://community.oracle.com/mosc/discussion/3779728/dynamic-custom-file-name-in-bi-publisher

Regards,

Arjun

Ian.Gooderham

Hi Arjun,

Thanks for the swift reply, so to confirm - It is not possible?

Two people are saying it can't be done and one has said yes it can - however trying their suggestion did not work for me -

I can give the template a name like %ASD%

but when I click on View Report I get an error

Best regards,

Ian

Mallikarjuna Kuppauru-Oracle

Hi @Ian.Gooderham

Can you try as below -

REPNAME_%y%m%d_%H%M%S.file extension type.

Regards,

Arjun

Ian.Gooderham

Hi Arjun,

Same issue I'm afraid,

I can rename the template, but when I go to view the report I get

I also tried this syntax in the output name on the schedule

but file name generated as

appreciate your help.

Best regards,

Ian

Mallikarjuna Kuppauru-Oracle

Hi @Ian.Gooderham

Got it. its work for FTP option only. What is your BIP version?

Change BI Publisher Output file name | PeopleSoft Tutorial

Regards,

Arjun

Ian.Gooderham

Hi,

Apologies I'm not 100% sure if this is what you are asking me.

Oracle Analytics Publisher 12.2.6.1.8

or is this what you are looking for?

/u01/APPLTOP/instance/domains/fa.oracleoutsourcing.com/FADomain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/

Best regards,

Ian

Ian.Gooderham

Hi Arjun,

OK, many thanks for confirming.

Best regards,

Ian

KDR

@Ian.Gooderham were you able to find a solution to this in Fusion BI Publisher? We would like to setup a dynamic filename with the current date to be output to FTP server. I know we can achieve this using a Bursting query defined in the Data Model, but I was wondering whether we can also accomplish this directly in the Scheduler.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62854#Comment_62854

Hi KDR,

Yes, it is possible to embedded date timestamp in file name when transferring the file to SFTP but not possible when delivering the file to email.

You can check the details on below link:

Dynamic Output and Bursting for BI Report

Thanks.