Skip to Content
0
Former Member
Dec 21, 2016 at 08:54 PM

Issue to conversion function in SAP HANA

516 Views

Hi Experts,

I have 6 date fields in my table. They are in 'YYYYMMDD'. Business want it into 'MM/DD/YYYY' format in reporting. I can easily create six different calculated columns and convert date into desire format. But, I do not want to use this technique.

I want to know more about Convert Internal to external or External to internal function available into semantic layer.

I have created scalar function and it is working properly. Please check below screenshot.

When I connect same function to desire column at semantic layer.

But, it is not working in Data preview or in reporting layer. (e.g. Lumira)

So, Could you please help me. What am I doing wrong here.

Regards,

Vikram

Attachments

a1.jpg (28.4 kB)
a3.jpg (55.0 kB)
a2.jpg (41.2 kB)