Symptom
This article describes how to find legal values of parameter "timezone" when use UTCTOLOCAL function in Views in Datasphere.
Environment
SAP Datasphere
Reproducing the Issue
- Open Data Builder in Datasphere.
- Create a a SQL View or a Graphical View.
- Use UTCTOLOCAL in the SQL View. For example:
SELECT UTCTOLOCAL(time,'EST') from "Time_Table" as timecolum - Use UTCTOLOCAL in the Graphical View. For example:
- Create a Calculated Column.
- Input UTCTOLOCAL(time,'EST') into "Expression".
- Use UTCTOLOCAL in the SQL View. For example:
Resolution
- Logon Datasphere HANA Database as below document:
Create a Database Analysis User to Debug Database Issues - Open a SQL console and run below SQL to see all the timezones:
SELECT TIMEZONE_NAME FROM SYS.TIMEZONES WHERE TIMEZONE_DATASET = 'platform' - The names of all the time zones will be shown in the result. Choose one and use it for parameter "timezone".
For example, UTCTOLOCAL(TIMESTAMP,'PST8PDT') for PST time.
See Also
Keywords
KBA , DS-MD-VIW , Views , HAN-DB , SAP HANA Database , Problem
Product
SAP Datasphere 1.0