Home › Discussions › Questions & Answers › Dynamic File Naming and Output Directory Configuration
Dynamic File Naming and Output Directory Configuration
Customer · · 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
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?
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?
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?
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?
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.
Sign in with LinkedIn or Google to take part.