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?