Forum Discussion
How to avoid loading dimensions that not exist in the fact table
Hi Anonymous ,
According to my understand, you want to keep rows in Dimension table matched from Fact table.
You could select Dimension table --> use Merge-->Right Outer-->Remove unnecessary columns as shown below:
If the data is continuous, you could add the whole column in Fact table as new Query ,then use it to create a parameter to filter the column in Dimension like this:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to my understand, you want to keep rows in Dimension table matched from Fact table.
You could select Dimension table --> use Merge-->Right Outer-->Remove unnecessary columns as shown below:
If the data is continuous, you could add the whole column in Fact table as new Query ,then use it to create a parameter to filter the column in Dimension like this:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Looks good, I will test that!