Categories
- All Categories
- 135 Oracle Analytics News
- 24 Oracle Analytics Videos
- 14.6K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 9 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 3 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE Publisher Dynamic File Naming For PDF
Hello,
In our company, we send daily reports via BI Publisher (1.1.1.9) I want to send the file named dynamically, including sysdate. I searched google and found the following syntax;
%d_%m_%y_myfile_%H_%M.pdf
But it does not work! Can you help me pls?
Regards,
Dilek
Answers
-
You'll need to call the report via an external script engine (such as Control-M) and you can specify the output filename dynamically via programming code...
0 -
Hi,
Are you using the Bursting SQL to burst the file name, if yes in the bursting SQL you can append sysdate to the KEY and generate unique file name.
Best regards,
Rajesh Dhanapal.
0 -
Yes, I am usign bursting sql. But, when I append SYSDATE, it does not work. File name comes to me as: Output.1089.pdf :S
0 -
Hope in the BIP report properties, you have enabled the Bursting as show below.
0 -
in bursting sql use somthing like CAST(CURRENT_DATE AS char(10))||'your_name' for OUTPUT_NAME
0