Oracle Analytics Cloud and Server

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

Agent: Add date to filename

Received Response
576
Views
5
Comments
Carsten Weber
Carsten Weber Rank 5 - Community Champion

Hi guys,

is there a way to add a date (sysdate) to the file name which is send using Agents?

My setup is as follows:

Product: Oracle Business Intelligence 12.2.1.1.0 (OBI EE)

Current Agent Output: filename.pdf

Target Agent Output: filename_sysdate.pdf

Best regards and thx in advance

Carsten

Answers

  • Koduri
    Koduri Rank 1 - Community Starter

    Hi

    If you just looking at adding Sysdate to the file - you can use the variables to append to file name which is shown below.

    Vishal's blog: OBIEE Hack: Putting prompts in file names

    Where as if you want to send it to a shared folder with sysdate appended then we can use Java script to do it from Agent Actions Menu. Thank you.

  • 859589 wrote:....send it to a shared folder with sysdate appended then we can use Java script to do it from Agent Actions Menu.

    Just a note on this: javascript only works on Windows OS servers, if you are on linux only EJB can do that (and EJB code works on Windows OS servers too, that's why if you do things in EJB you can reuse it everywhere).

  • Carsten Weber
    Carsten Weber Rank 5 - Community Champion

    Thank you for the information.

    I have already read this blog entry a few days ago but it is not the right solution for my problem since I want to export a file attachment using an Oracle agent.

    To make it more clear:

    1. Oracle agent sends an E-Mail with a .pdf-attachement to a number of perople on a daily basis.

    2. Currently my .pdf-attachment has the following file name: Enterprise_Reporting.pdf

    3. I was looking for a solution to get the following file name: Enterprise_Reporting_20170117.pdf (date is sysdate and will of course change everyday)

    In the past we used to have Hyperion Interactive Reporting and the job runner was already offering a method to add the sysdate to the file name.

    Does anyone know how to achieve the target I discribed above?

    Best regards and thx for any help

    Carsten

  • Carsten Weber
    Carsten Weber Rank 5 - Community Champion

    Maybe there is some parameter which I can add within some config-file on the server?

  • nm.Mani
    nm.Mani Rank 6 - Analytics Lead

    Hi there,

    hope this helps,

    pastedImage_1.png

    To add a variable in a headline to appear as the iBot subject line,

    https://docs.oracle.com/cd/E12096_01/books/AnyUser/ibotdeliverycontent.html

    Thanks

    MM