Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dynamic output Filename

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?
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