Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

BI Publisher Report - Suffixes Template Name and Output File Name - Repeats

Submitted
3407
Views
53
Comments
1246

Comments

  • user11994813
    user11994813 Rank 1 - Community Starter

    a must have feature as user needs exported report name should also include customer name field or invoice number, date etc

  • RupaliGahalot
    RupaliGahalot Rank 1 - Community Starter

    Can we append timestamp to report output file name in Oracle fusion?

  • Swapnil Kashid
    Swapnil Kashid Rank 4 - Community Specialist

    Hi @RupaliGahalot ,

    We can add timestamp while scheduling the report or using bursting mechanism.

    1. While scheduling select the output tab and add a destination example FTP. FileName_ABC_%y%m%d%H%M%S.fileextension
    2. PARAMETER5 of Bursting in case of FTP transfer Example ABC_|| ID || %H%M%S.fileextension

    Regards,

    Swapnil

  • Sebastien Mariller
    Sebastien Mariller Rank 3 - Community Apprentice

    I would like timestamps for "live" editions (no scheduling, no bursting).

    I tried to use the parameters in the name of the layout directly, just in case...

    with book_%y it complains there is bad url encoding

    with book_%25y (proper url encoding for %) it adds a new tab for each press of "refresh" 😅

    Anonymous_20230530_1127.png


    Really missing dynamic naming of live editions 😥

  • Rik Mukherjee
    Rik Mukherjee Rank 1 - Community Starter

    Hi @Swapnil Kashid

    I have tried the same for email delivery in order to have timestamp added in the report output. but it is not working and rather appearing as text values.


    image.png

    Could you please suggest any wayout for report job scheduling with 'Email' option?

    Regards,

    Rik

  • Swapnil Kashid
    Swapnil Kashid Rank 4 - Community Specialist

    Hi @User_YIWXL ,

    You can ahead with bursting mechanism, and I have tried this with XML file extension.

    Could you please try that am not sure of excel file type.

    Regards,

    Swapnil

  • Vaibhav
    Vaibhav Rank 1 - Community Starter

    This is must have feature, we would like to send other info on file name when calling from OIC integration like Error success count, so OIC do not need to read file just to get that and can read filename to get that.

  • RupaliGahalot
    RupaliGahalot Rank 1 - Community Starter

    Hi @Swapnil Kashid ,

    I found that with bursting we can achieve it . Thanks for your assistance.

    Regards,

    Rupali

  • Daniel Jay
    Daniel Jay Rank 1 - Community Starter

    Hello, I am responding there since this idea is documented (Doc ID 2621181.1).

    The format as it is now is ok for a default behaviour, but unfortunately BIP as it is currently designed don't propose an alternate way.

    For what I have read in the comments, and the expectations I can get from the business, there is plenty of scenarios where this naming would better be changed:

    For example, reports for Analytics could get a custom name, which in a sense is not that helpful since it can be adjusted by renaming the report and the template.

    When the report generates a document, it would make sense that the filename takes the document number, or whatever is expected by the user.

    I suppose then that one way that would benefit all would be to allow to pick a node in the data model output as the filename. That would allow the report designer to tune up the report export filename as fitted to the user request.

    I apologize for the above to be slightly different from your initial suggestion.

  • Mahshid Madani
    Mahshid Madani Rank 3 - Community Apprentice

    we need this feature as well.