About LeeFung

LeeFung · 03-05-2024

IsSAP BODS dying? SAP has partnerd with Syniti for data migrations,. Where does SAP BODS belong in SAP's new groups of products?

LeeFung · 02-21-2023

I am using BODS with a HANA HDB data store. For UTC to Local , or local to UTC datetime value conversion, shall I use a generic BODS function, or call a function from the HDB? ALSO I needed to make sure that the DST periods are set correctly, which I...

LeeFung · 02-17-2023

Regarding local to UTC time conversion : the function in BODS seems like this: local_to_utc(‘2014.02.01 00:00:00’, ‘UTC+08:30’) = ‘2014.01.31 15:30:00’My question is regarding the time of the year when DST switch happens, and the day has 25 hours.....

LeeFung · 02-16-2023

Hi gurus, how can I set BODS job to read a folder on Linux, and store all file names in a variable, and send an email including all the file names? Thanks!!!

LeeFung · 02-01-2023

I need to set up an email alert for a job that runs every 20 minutes . Depending on status of job (fail/success/ warning) , the email will be different. First it looks like I need to use Try/Catch to set up the logic; second, the email part needs a s...

LeeFung · 03-06-2024

At least you SAP guys , when posting, could use a more professional-looking handle... to make the content more credible.

LeeFung · 02-25-2023

Thanks !It's a pity the BODS utc_to_local() function does not take care of DST! am I right?

LeeFung · 02-25-2023

I am having some challenge calling the HDB function UTCTOLOCAL from within BODS... BODS simply can't find the function in the datastore.... any tutorial I can go through? joseph_muiruri yoganandamuthaiah

LeeFung · 02-24-2023

Thanks Yogananda... what functions from HDB shall I call? I am not sure if from BODS sufficient privileges are given to call functions from HDB...

LeeFung · 02-16-2023

I was more asking if a job fails, send email; if it succeeds send a different email ... how to set it up?

User Statistics

User Activity

Where does SAP BODS belong in SAP's new groups of products?

UTC to local time conversion with DST

SAP BODS : local time to UTC conversion

SAP BODS: read a list of files on Linux and store file names in a variable, and send email

EMAIL ON BODS job per status

Re: Statement of Direction - SAP Data Services and SAP Information Steward, as of November 2023

Re: UTC to local time conversion with DST

Re: UTC to local time conversion with DST

Re: UTC to local time conversion with DST

Re: EMAIL ON BODS job per status