Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE12c Report Download Requiremen

Hi Guru's

Need your support to implement the following client requirement.

Requirement Details :

While downloading any report in OBIEE tool specified formats(like PDF, HTML, Excel, ect.), it should download as Currentdate_ReportName.

Current Date should be appended as suffix to Report name.

Example : If report name is “XXXX” then while downloading it should download as

20180701_XXXX

I have tried all possible ways to achieve this but OBIEE has a rigid default of downloading report (to any format) as per its saved name.

Please help me in case if you have any clue in that.

Best Regards,

Ritesh

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Are you working for the same client as this guy? Adding system date to dashboard/report

This literally has been discussed yesterday.

3614436

Yes, He just discussed the same matter. He suggested me to close the thread as its not possible when OBIEE12c hosted on Linux machine.

Has the same thing discussed with him?

Best Regards,

Ritesh

[Deleted User]

Best you read this: https://blogs.oracle.com/xmlpublisher/dynamic-delivery-file-naming

BI Publisher has all those options. OBI is an *analytical platform* and neither a data dump tool nor an export vehicle

Avinash Pentyala

Yup

[Deleted User]

So BIP. Ar far as I know no one ever wrote a Linux script for that and the VB has been removed since the blog was dropped

SonPat99

Hello,

You can refer the below link, but again its a lot of work and customization.

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

This just gives you a way. You can use hidden prompts and the Presentation variables defined there instead of actual prompts.

But, again remember the below...

Hope this helps...

Martin van Donselaar

A way which may break with any minor OBIEE update, if you want a reliable solution use BIP,UTL_FILE,APEX... and many more options better then OBIEE

SonPat99

Thanks for highlighting this point Martin...

[Deleted User]

Upgrades are always a killer. Any solution should be as portable across versions as possible. Granted sometimes it isn't possible but decisions should be taken based on all aspects including future costs and efforts.