OBIEE Publisher Dynamic File Naming For PDF — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Publisher Dynamic File Naming For PDF

Received Response
21
Views
5
Comments
dilek
dilek Rank 6 - Analytics Lead
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    Rajesh Dhanapal Rank 4 - Community Specialist

    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
    dilek Rank 6 - Analytics Lead

    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
    Rajesh Dhanapal Rank 4 - Community Specialist

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

    pastedImage_0.png

  • Terna
    Terna Rank 2 - Community Beginner

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