Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dynamic output Filename

Received Response
61
Views
3
Comments

Summary

Dynamic output Filename

Content

Hi,

I am using BIP 12c and need to dynamically set the output filenames for reports delivered over Email as excel and pdf.

I need to name the files as myfile_ddmmyyyy and put mail subject as report_for_ddmmyyyy

As per Oracle docs

https://docs.oracle.com/middleware/bi12214/bip/BIPUG/GUID-22F94743-8AB7-43E8-AEE8-3D022AB306B2.htm#BIPUG221

I can use below

myfile_%d%m%y , but the same isnt working. I am getting the output as myfile_%d%m%y only instead of myfile_21052018.

Could anyone please help?

Answers

  • User_4M27J
    User_4M27J Rank 2 - Community Beginner

    Hi,

    You can use subject as 'report_for'||to_char(sysdate,'DDMMYYYY')

    Similarly the file name also

    Thanks,
    phanidra

  • Saurabhjain8
    Saurabhjain8 Rank 2 - Community Beginner

    Hi Phanidra,

    This doesnt work either. It returns the same expression in subject and filename.

  • Sanjay Chaurasia-28291
    Sanjay Chaurasia-28291 Rank 1 - Community Starter

    Is this resolved?

     

    Thanks

    Sanjay