I will offer an attachment that you will find familiar as I have been trying for months to get a Relationship OLAP PT constructed from three WS's....Game, Pitching...Play by Play. No matter what I've done I can not get the PT to function with integrity. I get partial results but usually with Excel apprising me that 'new relationships must be created.'
I've noticed that when I go back and look at my three columns that the Pitching Column always goes out of order on the Play by Play WS. I've highlighted it in red in the attachment. Other than that I can not find reason why the PT always breaks down.
I was wondering if reformatting one or more of the three columns in each of the WS's in some way would render me a workable format?
Do you think that the incorrect order that the Play by Play WS displays in the Pitching column means anything?
Is merging the WS's into one big WS a viable solution?