Hello! Is explicit lifting something you can build into the whole dataset or is it just for Custom Metrics built using MAQL? There are cases I need to use fields from the dataset using the opposite direction of the relation and I’m looking for a more general solution.

Hi Hanna, Your assumption about the Explicit Lifting is quite correct. It is feature tied to the MAQL, concretely to the BY clause that allows you to lock aggregation on a certain level. Unfortunately, it cannot be applied on a dataset level. However, you can create one or multiple bridge datasets and work with many-to-many relationships in your model. Please check the article below for more details. Many-to-Many modeling

Thanks! will check it