easily filter tables based on values of another table, with query folding
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...
STATUS
DETAILS
Needs Votes