on 01-03-2018 9:35 AM
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
Hello Tammy,
why do you get the "old" style of the hierarchical elements? I just get it like Santhosh, but I need it in the same way like you got it.
I get for day: 2018/Q1/2/22
I want for day: 22
Also I have a problem with sorting the values numeric, Lumira is now sorting alphabetic.
I'm using Lumira Discovery 2.1 SP01.
Greetings,
Sascha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Santosh,
My comments w.r.t your points
Hope that clarifies.
Regards,
Ashutosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Santhosh,
If you just need month (not even year) then you can choose to split the date without creating a hierarchy.
However, if you need month along with year but no quarter, there is no straight forward way. A workaround could be to use following formula to create a derived dimension
if (SubString({Month}, 9) = "1") then Concatenate("Jan ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "2") then Concatenate("Feb ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "3") then Concatenate("Mar ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "4") then Concatenate("Apr ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "5") then Concatenate("May ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "6") then Concatenate("Jun ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "7") then Concatenate("Jul ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "8") then Concatenate("Aug ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "9") then Concatenate("Sep ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "10") then Concatenate("Oct ", SubString({Month}, 1, 4)) else if (SubString({Month}, 9) = "11") then Concatenate("Nov ", SubString({Month}, 1, 4)) else Concatenate("Dec ", SubString({Month}, 1, 4))
Regards,
Ashutosh
Hi Tammy,
Did you get chance to look into my reply?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
my data source is excel file with xlsx extension
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.