Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Dynamic output Filename

Saurabhjain8
Rank 2 - Community Beginner
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
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?
0
Answers
-
Hi,
You can use subject as 'report_for'||to_char(sysdate,'DDMMYYYY')
Similarly the file name also
Thanks,
phanidra0 -
Hi Phanidra,
This doesnt work either. It returns the same expression in subject and filename.
0 -
Is this resolved?
Thanks
Sanjay
0