cancel
Showing results for 
Search instead for 
Did you mean: 

Lumira designer: Apply a filter on many datasets comming from various datasources

0 Kudos

Hello everyone

I created a report in lumira discovery, in this report I built my datasets with the calculated values, and linked my various datasets

Once it's done, I started to develop my report, but now I'm struggling with an issue about the filters

I have 2 datasets, Ds_1 and DS_2, Ds_2 is comming from my datasource Cost and Ds_1 is comming from my datasource risk (A link has been created with linked datasets in designer with my key customerID)

In my designer report, I add a filter with DS_1 as Data Source, DS_2 as target datasource and my dimension is CustomerID

but when I applied the filter, the only charts which are filtered are the one using DS_1,

is there a way to solve this trouble?

Thank you for your help

KR

Accepted Solutions (0)

Answers (1)

Answers (1)

reiner_hille-doering
Active Contributor
0 Kudos

I don't fully get what you are doing, but it is important to differentiate "dataset" and "datasource". In Discovery every chart/table has and own datasource (e.g. DS_1, DS_1), that might point to same or different datasets. Each datasource has one filterstate per dimension. If you have story or page level filters, there is a synchronization mechanism for all affected data sources. This mechanism is implemented by the STORY component. In a normal Designer app without STORY component there is no such synchronization. Of course you can achieve exactly the same behavior with scripts. E.g. if you have a dropdownbox the should filter for dimension "Country", during OnSelect you need to call DS_1.setFilter, DS_2.setFilter, ... for all datasources that you want to be affected.