on 07-01-2016 10:09 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
Nicolas,
I searched for this on Idea Place
When I did a search, 20 ideas returned
This one Date Range option on Input Control : View Idea closely fits your question; the idea is under review. I recommend voting for it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nicolas - I am not aware of such scripting capabilities, unless you do something with the Lumira SDK - since I am a business analyst, this isn't something I personally would do.
But quickly reviewing the developer guides for Lumira - at SAP Lumira 1.31 – SAP Help Portal Page - I am not sure what you are asking is possible. Look at the developer guides in the SAP Help.
thanks again Tammy,
I know it is possible with the SDK because we can already do Gantts charts thanks to the extension "timeline chart" (see lumira-extension-viz/Scrollable_Timeline_Chart at master · SAP/lumira-extension-viz · GitHub)
As developper, I would be able to do it, but if there is any easier solution, it would be welcome.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.