Does Business Objects tools such as Lumira and Analysis for Office recognize Hana Live dates? In my environment, it does not. Lumira does not convert the Hana dates to dates, it sees it as text, and the conversion tool will not convert the dates to Date type either. I tried the various formulas mentioned on the internet, but with no success. Neither does Analysis for Office recognize dates from Hana.
Is there something wrong with my installation, or is this the way it is? If this is the way it is, what is the best way of dealing with dates?
I am not sure if there is a better way to deal with this issue, but I found 2 methods that will deliver date columns in a recognizable way to AO and Lumira. The first is to join your table with a calendar view such as FiscalCalendar, and to use the Date_E column as the date output. If you have one date to output, this method can work, but if you have many date fields to output, then the next method will be the better way to do it.
The second method is to create a new calculated column of Date type, and use the formula “date(leftstr(<Date Field>,4)+ '/' + midstr(<Date Field>,5,2)+'/'+ rightstr(<Date Field>,2))” to create a formatted Date field. Now AO and Lumira will recognize it as dates. I hope SAP figures out a way for AO and Lumira to automatically recognize dates in the future.