Dynamic File Naming and Output Directory Configuration

Customer August 4, 2022 at 1:02 pm

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?

Viewing 8 reply threads

Author
Replies
- Support August 6, 2022 at 4:41 am
  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 .
- Customer August 8, 2022 at 6:36 am
  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 August 9, 2022 at 10:27 am
  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 .
- Customer August 10, 2022 at 5:38 pm
  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 August 11, 2022 at 1:47 pm
  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., “) .
- Customer August 13, 2022 at 2:00 am
  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 August 13, 2022 at 3:25 pm
  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 .
- Customer August 15, 2022 at 9:10 pm
  How many different output files are actually generated by Blitz Report during a single run?
- Support August 17, 2022 at 7:56 am
  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 .
Author
Replies