on 08 Jan 2018 23:57:52
Currently it's not easy to remove dimension table records with the Query Editor that are not related to the main fact table.
Let's say you have a Product_ID in the fact table, and the fact table (sales) only contains records for the last two years. I'm missing an easy way of removing the records in the Product table (that are related to the fact table via Product_ID) that are not related to the fact table.
When I set up a solution with a merge, I can not make the query fold to sql anymore. The new feature should be easy to use, plus use query folding to get the desired result.
- Comments (1)
RE: easily filter tables based on values of another table, with query folding
To clarify the example I gave : the product (dimension) records that aren't related to the sales (fact) records, are products that haven't been sold in the last two years, because the sales table was loaded with only records from the last two years.