Lumira: DataSource.getData selection with multiple members

[mitko1994]

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

[TammyPowlas]

What is your data source?

Have you seen Reiner's blogs - are you trying to iterate over something? See https://blogs.sap.com/2017/12/21/mysterious-memberlists-in-lumira-designer/

[former_member454880]

Hi,
I ran in to the same problem, what i did was instead of using Year i used date range ["2017-01-01 - 2018-01-01"] .

[mitko1994]

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.