Forum Discussion
Relationship Three Tables
I have three tables, Sales; Forecasr and Date (autocreated, used for all tables in the file), see below sample data I can create a relationship between Sales-Date and Forecast-Date but I also ...
Hi Anonymous
I added a dimension table for Company and made the appropriate 1:* relationships.
Let me know if you have any questions.
Hi some_bih
- Date table is generated from Min Sales date -> Max forecast + 120days (All dates should be covered)
- Granulartiy is same, individual dates
- All dates in date table is unique
- I have a 1-Many relationship for both Date-Sales and Date-Forecast
- Whats wrong with date table?
- What could be the issue of combining Sales-Forecast?
Hi Anonymous share file (dropbox, g drive... )