Managing dates intervals

[Former Member]

Hello,

I have a set of data including defined tasks with status, locations, start and end dates.

The aim is to have the activies locations and status per date (unique or range).

I would like to filter the tasks by any day for to visualize different charts, including a day between the start and end dates.

How is it possible in SAP Lumira please??

I've searched in the forums and in the help link, and there is no information about this kind of issue.

Today, if I filter a specific day included between the start and end date, Lumira acts as if this task doesn't exist.

I hope this is clear enough.

Many thanks in advance,

Nicolas

[varunanand · Accepted solution]

Hi Nicolas,

The Lumira custom extension which you mentioned is a good example to achieve the functionality. But you would not be able to extended it to the charts available out of the box.

I can only see this happening by modifying the data at the acquisition or prepare phase. What is the data source and the size of data acquired ?

Thank you,

Varun Anand

[Former Member · Accepted solution]

Thanks for your reply Varun,

Here is an example of the data source:

Date start	Date finish	Operation
05/01/2016	08/01/2016	Brainstorm
09/01/2016	15/01/2016	Prepare
16/01/2016	19/01/2016	Design
20/01/2016	20/01/2016	Milestone 1

The expected final result would be something like this

Date	Operation
05/01/2016	Brainstorm
06/01/2016	Brainstorm
07/01/2016	Brainstorm
08/01/2016	Brainstorm
09/01/2016	Prepare
10/01/2016	Prepare
11/01/2016	Prepare
12/01/2016	Prepare
13/01/2016	Prepare
14/01/2016	Prepare
15/01/2016	Prepare
16/01/2016	Design
17/01/2016	Design
18/01/2016	Design
19/01/2016	Design
20/01/2016	Milestone 1

I've been looking in internet about the preparation phase but nothing related about it.

Do you have more information please?

If it is a data base like process (like sql), it should be possible to implement.

Regards,

Nicolas

[varunanand · Accepted solution]

Hi Nicolas,

We can use custom calculation ( like if-then-else ) to achieve this pattern. But I would prefer doing this part of the data manipulation in the back-end system itself and get the raw data into Lumira.

Again my question would be, what is the data source and how big a data set are we looking at ?

Thank you,

Varun Anand

[Former Member · Accepted solution]

Hi,

Unfortunatelly, I can't provide the full data due to data security reasons, but I can at least define the main specs.

the data source is an excel file with about 10 000 lines in 10 columns like the example above.

Later, this data will be modelized in SAP Hana.

I hope this answers your question. If not, please let me know to be more specific.

Regards,

Nicolas

[varunanand · Accepted solution]

That's the main information I needed Nicolas. I would recommend to make the changes in Excel and later transition it to SAP HANA. Especially if you plan on having a live connection from HANA to Lumira, best practice would limit data manipulation as much as possible in the front end.

Thank you,

Varun Anand

[Former Member · Accepted solution]

Thanks a lot Varun,

it's very helpful

Regards,

Nicolas