Hi, I have a question regarding modeling. I have 1 fact table Expense pointing to a couple of dimensions (Customer, Cost center, Report...) Because our users are used to be able to see facts per Customer, Cost Center, Report they're all directly linked to the Fact table Report has it's own separate fact table Called Report History. Now, we'd like to filter Report History by a Customer, can this be done? Note that for all Report History, the Report ID will be the same for each Expense.

Hello Hans, You may overcome this by declaring edge in data model as many to many edge (double sided arrow). Simple rule is that attribute will be usable for breakdowns of metric if there is oriented path from them to the facts. Double-sided arrow will help. You can create double sided arrow by dragging relation from Approver to Expense in LDM modeler. See more in an article about many-to-many relations in the GD Platform documentation: https://help.gooddata.com/doc/enterprise/en/data-integration/data-modeling-in-gooddata/many-to-many-in-logical-data-models/ Please give this a try and let me know if it helps.

Hi Moises, for Approver yes I understand that can be done. But can it doesn't work for Report History, I can't filter it by Customer.

Hi Hans, I would like to recommend that you review the following documentation - Explicit lifting is a feature of GoodData’s Extensible Analytics Engine that grants you greater flexibility in aggregating metrics in reports. More details, on this can be found here: https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/explicit-lifting/ If the above doesn’t help and you’re still unable to filter it by Customer, it would seem that the issue is caused by limitations in your model and you might need to re-work your model accordingly.