OBIEE Publisher Dynamic File Naming For PDF

Question

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

Terna · Answer

in bursting sql use somthing like CAST(CURRENT_DATE AS char(10))||'your_name' for  OUTPUT_NAME

Rajesh Dhanapal · Answer

Hope in the BIP report properties, you have enabled the Bursting as show below.

dilek · Answer

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