Forum Discussion
Managing Relationship Help
I have 4 different data sources. Master Data (describes each part number and gives details on many metrics), Master Date (allows me to get all data in week-to-week formats), Trailing 6-Months of Bookings, and Forecast History.
My file is designated for looking at Forecast Attainment.
How would I connect all of these so a chart showing Bookings vs. Forecast by Date could be sliced using Master Data?
4 Replies
Hey Nickhamilton, really difficult to visualize without sample data, but I will assume your Trailing 6-Months of Bookings have part number or key for all transactional days(Master Date), same assumption for your Forecast History, if that is the case, a simple star schema model will do the trick, your Trailing 6-Months of Bookings as "fact", relationship with Master Data via part number or key, Master Date on date or transactional date and Forecast History on just part number
Bookings, Forecast, and Master Data all have Material and Material Descriptions that I've tried using as the connector. Master Date, Forecast, and Bookings all have the same date formats as well. I just can't get the connections to mesh correctly. Right now, I am forced to use 2 slices for each metric I want to have my graph represent.