Steve,
You are spot on with the seats changing by month. Some seats are broken and not sold.
So I have my new fact table and all relates to it but for one item. This is causing the cartesian product. I was wondering however if the Calc is my answer. On one of the pulls for a number, rather than a fact table it was in a calculated member and reads as follows: CLNG([SM ROUTE].[ROUTE].CURRENTMEMBER.PROPERTIES("MILES TRAVELED")).
Should I be looking to solve the issue in the calculations or just the design?
Thanks again for taking the time to help a new guy walk through this.
Doug