I would like to create an OLAP pivot table between the three tables in the WB attached. The Game WS has a one to one relationship with both the pitching and the play by play WS's and I have been able to create 2 relationships between them.
The relationship between the pitching and the play by play WS's is a little harder to discern. One pitcher can be involved with many plays and vise versa. But if I were to group the relief pitchers of each team together, which I will want to do, then I believe you would have a many to many relationship.
Excel has told me that a one to one relationship between the pitching and play by play would create a relationship with no unique column in either table: I tried
Play by Play (Pitching ID) with Pitching (Pitching ID)
Can this be set up as three one to one relationships?
Am I correct that grouping the relief pitchers would create a many to many?
Do the ID columns in the play by play need to be reformatted?
As always I appreciate your help.