Skip to Content

Lumira: DataSource.getData selection with multiple members

Hello Experts,

I'm working with Lumira Designer and am trying to get a value from a DataSource that is based on multi-member selection for a particular dimension. I have not seen any examples of it so I'm wondering if it's even possible. For example I want to get Net Sales for years 2017, and 2018. I've tried the selection: {"0CALYEAR":["2017,""2018"]} without success. If someone can shed some light on the matter, I will greatly appreciate it

Thanks,

Dimitar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 23 at 09:27 AM

    Yes, I've seen it! I'm not iterating over anything. I just want to have a selection for a Measure(eg Net Sales) that uses multiple members for a dimension(in this case 0CALYEAR: 2017 and 2018). I see that the value part of the key-value pair in the JSON has to be Member which makes me think the API is designed to work with a single member only. I guess the workaround would be to set a filter as an inputString on the data source and call DS.getData(Measure,{}). That way you will simulate your selection using a filter and you will retrieve all data available in the data source for Measure after applying the filter.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08 at 09:54 PM

    Hi, I wanted to get a value that should be of the Cost generated in Berkeley in 2017/Q1 , i can get only one value at a time as i can select one data cell so i used another line and wrote the same function with Cost from Berkeley in 2017/Q2 and subtracted each other to find the difference. It was not letting me select values under multiple dates as it was like i was virtually selecting a cell.

    var Cost_val_now = DS_2.getData("DS:2,MEAS:id_44", {"DS:2,DIM:id_106":"Berkeley","DS:2,DIM:id_128":"2017/Q1"});

    var Cost_val_prev = DS_2.getData("DS:2,MEAS:id_44",{"DS:2,DIM:id_106":"Berkeley","DS:2,DIM:id_128":"2017/Q2"});

    var Cost_Diff = ((Cost_val_now.value) - (Cost_val_prev.value));

    I got some idea from here.
    https://blogs.sap.com/2017/12/21/mysterious-memberlists-in-lumira-designer/

    Add comment
    10|10000 characters needed characters exceeded