Forum Discussion
Filtering multiple Fields over multiple Tables
Hello community! I have a problem, which is so specific that I didn't even know what to search for. I have two tables which I am using in one page of my report, both tables have a column "Project" ...
Got this solution from another forum:
Just set the relationships one way from DIM table to FACT table and there is no ambiguity.
amitchandak
I updated the post to include a structural scheme and point out that the fact tables contain wildly different data.
I see no way around having to use these tables and relating them somehow.
Thank you for your help!