No matching data found on selection in Lumira Designer

[former_member610524]

Hello everyone,

I will try to be assertive on this one.

1) I have a dimension called IdentificadorRubrica that filters a data source with the values (P1, P2, P3, P4, P5).

2) That dimension fills an array called dimRubrica using getMembers() method.

3) That data source returns data from year 2015 until 2018.

4) Values P2 and P4 coming from IdentificadorRubrica don't exist in the database for 2017, but do exist in all the remaining years.

5) When i try to fill a barchart using setDataSelection() and passing all the metrics and dimensions needed (year, month, IdentificadorRubrica:dimRubrica, and so on, if i select the year 2017, i get the following warning:

No matching data found on selection....P2, P4....

Is there a way for me to avoid this error and get only the subset data that exists for those selected dimensions without changing the dimRubrica array? Because this array will always be filled with all the DISTINCT values (all possible values that are returned by that data source).

I've tried to activate the option Members for Filtering -> Only Values with Posted Data in that data source's Initial View and for all the dimensions present there (including IdentificadorRubrica, of course), but it didn't work.

Thank you in advance. Cheers,

BO version: 4.2 SP5 Patch 6

Lumira Designer version: 2.2 SP0 Patch 1

JAmorim

[former_member610524]

Hi all,

I've just reached a solution for this one.

1) Created a function that fills and returns dimParcelas array dynamically;

2) In the beginning of that function i also filter the query (by selected year) returned by the data source. This filter ensures that the array will be filled only with the distinct available values for each IdentificadorRubrica, for the selected year;

3) In the end of that function i clear the filter.

Thank you anyway,

Cheers