Home › Discussions › Questions & Answers › Dynamic File Naming and Output Directory Configuration

Dynamic File Naming and Output Directory Configuration

Avatar photoCustomer Questions & Answers 9 replies

I need to ensure the Excel file downloaded to the user’s desktop has a dynamic name that includes the Report Name, the Request ID, and the value of the ‘Operating Unit’ parameter. Where is this naming convention defined, and what syntax should I use?

9 replies

  • Support Enginatics

    The filename downloaded to the client desktop is defined in the ‘Excel output file name’ field under Report Options . You use tokens enclosed in angle brackets (“) to define the dynamic content . For your requirement, you would use tokens such as “, “, and “ (or “ if you prefer underscores over spaces) , . If you use “, all spaces in the report name are automatically replaced with underscores .

  • Besides the downloaded file, we need to save a copy of the output to a network directory mounted on the database server every time the report runs. Where do I define this location?

  • Support Enginatics

    The location for saving a copy on the database server is defined in the ‘Additional Out. Directory on DB Server’ field, which requires Developer access , . This directory must correspond to a TNS descriptor defined in `dba_directories` . If you also need to save a copy on the application server filesystem, that is configured separately using the ‘Directory on the application server to save a copy…’ field .

  • If I save copies to an additional directory, is the naming convention for those copies the same as the file downloaded to the desktop?

  • Support Enginatics

    No, the naming convention for files saved to the additional output directories (APPS or DB server) is defined in the separate field ‘Additional Out. Filename’ , , . This field also supports the same dynamic tokens, allowing you to define a naming structure suitable for interfaces or archival, such as including a date format string (e.g., “) .

  • If I schedule a nightly incremental report that needs to overwrite the same file daily, how can I configure the filename template to support this refresh pattern?

  • Support Enginatics

    You can use the Profile option ‘Blitz Report Additional Output Filename’ or the report-level setting to define a template containing a date format string, but omitting the time component . For example, setting the template to `_` and scheduling the report hourly would ensure that the same file is overwritten multiple times a day, containing the refreshed data .

  • How many different output files are actually generated by Blitz Report during a single run?

  • Support Enginatics

    There are three potential output files that can have different names : 1) The file downloaded to the client desktop . 2) The output file stored on the concurrent processing server in `$APPLCSF/out` (which is also used as the email attachment filename for standard Oracle delivery options) . 3) An additional copy placed into a specified directory on either the application or database server .

  • You must be logged in to reply to this post.