Oracle Business Intelligence

Products Banner

Agent: Add date to filename

Received Response
414
Views
5
Comments

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

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

  • 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

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

  • nm.Mani
    nm.Mani ✭✭✭✭✭

    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