OBIEE Publisher Dynamic File Naming For PDF

dilek

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

Thomas Dodds

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

Rajesh Dhanapal

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.

dilek

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

Rajesh Dhanapal

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

Terna

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