Problems with new style of date hirarchy

[Former Member]

Hello,

is there a possibility to get the date hirarchie in the "old" style?

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

[TammyPowlas]

Hi Sascha - what is your data source? BEx query?

[Former Member]

Hi Tammy,

my datasource is a SAP Universe.

Greets,

Sascha

[former_member4998]

Hi,

We have option to create custom hierarchy in discovery.

dsicovery-custome-hierarchy.png

And also we can able to sort using options is discovery and designer. Please find the below screen shots.

designer-sort.png discovery-sort.png

Thanks,

Sreeni

[Former Member]

Hello,

thank you for the quick answer, but it is not the solution for my Problem.

If I'am creating a date hirarchie now it's allways like 2018/Q1/1/15 (For day). The old style was 15 (For day).

If you are now sort by day, it will be this way:

2018/Q1/1/1

2018/Q1/1/11

2018/Q1/1/12

2018/Q1/1/...

2018/Q1/1/19

2018/Q1/1/2

2018/Q1/1/21

2018/Q1/1/...

2018/Q1/1/29

2018/Q1/1/3

2018/Q1/1/31

2018/Q1/1/4

2018/Q1/1/5

2018/Q1/1/6

2018/Q1/1/7

2018/Q1/1/8

2018/Q1/1/9

As you can see the 2nd of January is after the 19th. This is not right.

Greetings,

Sascha