Categories
- All Categories
- 99 Oracle Analytics News
- 8 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 55 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Agent: Add date to filename

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.
0 -
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).
0 -
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
0 -
Maybe there is some parameter which I can add within some config-file on the server?
0 -
Hi there,
hope this helps,
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
0