Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics & AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
DYNAMIC OUTPUT FILE NAMES USING DATE EXPRESSION WITH USER TIMEZONE
Yash_
Rank 1 - Community Starter
Description
When generating file names dynamically using date expressions (https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG220), like Employee_%y%m%d%H%M%S.xls by default it takes UTC time zone.
Example when an interface is ran at 2019-10-21 5:13:27 PM PST, the output file name is Employee_20191022001327.xls (which is in UTC time zone.) rather than Employee_20191021051327.xls
Use Case and Business Need
Current work around is to use bursting query. But it would be much easier if the user time zone(which is defined under BI Time zone under 'My Account') is considered rather than default UTC while using date expressions.
Original Idea Number: 8938f84612
1