Lumira Time Hierarchy from Analytic View Hana

[gertjan_oostrum]

Hi,

I am trying to create a Time Hierarchy in Lumira Discovery (2.1) which is using online data from HANA by using an OLAP connection.

I followed the guide chapter 6.1

https://help.sap.com/doc/businessobject_product_guides_vi01_en_lum_129_install_en_pdf/1.29.0.0/en-US...

Created an attribute view (of type Time), having the data from _SYS_BI.M_TIME_DIMENSION. Captured YEAR_INT, MONTH_INT and DAY_INT, DATE_SQL

I have created the Level Hierarchy on the 3 INT dimensions and have set the respecitve Level Types (TIMEDAYS/MONTHS/YEARS)

In the Analytic view I have left outer joined (1..n) the Time dimension with my dataset on a column which holds the date in date format.

On HANA it renders fine as in I do see the data correctly joined together.

However in Lumira I am still not able to see the dimension as a Time dimension. It just simply shows as hierarchy with Integers.....

What am I missing here ... ??

EDIT:

Just to add, I have also tried the same setup as mentioned in the document but than by using a calculation views of type Time. Same result..negative.

[sapna_jgurudutt]

Dear Customer,

Can you refer the following SAP Notes and check if it helps you:

2440578 - Lumira's support for HANA with MDC(Multitenant database container)

2341715 - HANA calculation view time hierarchy not recognized in Lumira Desktop

Thanks & Regards,

Sapna