Skip to Content

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

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


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 21, 2019 at 08:13 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.