Dear Customer,
The system date/time is set to UTC as it would be used globally. The reports based on CDS view they use default of today’s date which shows UTC date. However, your requirement can be achieved following the recommendation below:
1. Create a custom cube (via the “Custom CDS Views” App) which exposes fields of data type DATS/TIMS (which can be derived from a timestamp via the below mentioned functions).
a. Create calculated fields with functions:
TSTMP_TO_DATS(tstmp,tzone,clnt,on_error)
and TSTMP_TO_TIMS(tstmp,tzone,clnt,on_error)
or DATS_TIMS_TO_TSTMP(date,time,tzone,clnt,on_error)b.
b. You can also create a calculated field with session variable("System Date") - Supported by Custom CDS View
2. Afterwards you can define a custom query based on this custom cube
Please note that the above functions are not supported by Custom CDS View but since calculated fields can also be created using the free editor, you might try to have these functions in your CDS view and see if they work.
List of supported functions can be found here
Documentation on how to create a calculated field can be found here
Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.