Skip to Content
0
Jun 16, 2018 at 06:19 PM

Lumira Time Hierarchy from Analytic View Hana

169 Views Last edit Jun 18, 2018 at 09:04 AM 4 rev

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/lum_129_install_en.pdf

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.

Attachments

time-colums.jpg (69.0 kB)
time-hierarchy.jpg (85.9 kB)
lumira.jpg (8.0 kB)