Skip to Content
0
Jan 03, 2018 at 09:35 AM

SAP Lumira 2.1 Discovery doesn't create Date hierarchy values correctly?

1016 Views Last edit Jan 03, 2018 at 09:38 AM 2 rev

I recently installed SAP Lumira 2.1 Discovery and have Order Date as column and it has date in YYYY-MM-DD format.

1) When I create "Date Time" objects on Order Date, it creates 4 new dimension objects with Order Date_Day, _Month, _Quarter, _Year and all values look correct

2) I also tried creating custom hierarchies using newly created objects Order Date_Year, Order Date_Quarter, Order Date_Month but they are not shown in the list of objects to create a hierarchy on my own. This is so strange??

3) When I create Order Date -> Hierarchies -> Date/Time, a new hierarchy is created with name Time_Order Date and it has 4 objects : Year, Quarter, Month, Day but Month and Day objects have incorrect values in format: YYYY/Q1/1. They are showing Quarter values instead of Month / Day. Year and Quarter objects show right values.

Attached screenshots. Hierachy Created as below

Hierachy Values are as below

Attachments