Skip to Content
0

Issue to conversion function in SAP HANA

Dec 21, 2016 at 08:54 PM

179

avatar image

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

a1.jpg (28.4 kB)
a3.jpg (55.0 kB)
a2.jpg (41.2 kB)
10 |10000 characters needed characters left characters exceeded

Hi Vikram

I have similar requirement, Could you please help to create this scalar functions & did you found solution ?

Thank you.

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Jan 30, 2017 at 10:20 AM
0

As written down in the offical Documentation (Convert Attribute Values to Required Formats) - see the quoted "Notes" block - that kind of conversion function is not supported in SAP Analytic Client tools (e.g. Lumira, Data Preview in HANA Tools ...). You have to apply the conversion logic by yourself on the consumer side. One option would be to determine the function names from the view mentioned in the documentation and call it manually on the consumer side for the data.

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded