Forum Discussion
Combing graphs from 2 datasets on the same tab
So I am sure what I am trying to do has been done before. I am half way there and feel like I am just missing a small piece. I am graphing revenue and hours on the same tab but the data is coming fro...
PaulDBrown
Community Champion
Community ChampionAnonymous
The general consensus is to avoid many-to-many relationships where possible (it can wreak havoc in calculations...)
Can you not create lookup/dim tables as bridge tables between the different fact tables by linking common fields (and removing duplicate values to enable one-to many relationships)?
If you can provide sample fact tables with dummy data/values I will happily give it a try
The general consensus is to avoid many-to-many relationships where possible (it can wreak havoc in calculations...)
Can you not create lookup/dim tables as bridge tables between the different fact tables by linking common fields (and removing duplicate values to enable one-to many relationships)?
If you can provide sample fact tables with dummy data/values I will happily give it a try
I created a 2 bridge tables, my company and yard tables, that are many to one with just the company and yards listed in the bridge tables, but I need to link 3 tables to them and it will not let me do more than 2. When I try to make the relationship active I get this error. And what makes no sense to me is that the Yardname table and the Calendar table are not linked at all in any way. There is no way to link them.