Order fee by production season

Out of curiosity I attempted to setup something similar to what you were describing... with similar results. I'm guessing you are using the Finance cube because I did not see any fee data accessible in the seats and tickets cube. I did a bit of digging into where the data is being pulled from, and (this is just my assumption, I could be totally wrong on this), but the fee data you are seeing is probably pulled directly from the payment transaction data in your database. When a fee is paid, to my knowledge, the transaction only records the fee # and order #, it does not make any other associations to the performance and lineitem (those associations are stored in another table). So if you have an order with products from different production seasons but they all trigger the same fee, when the system records the payment, it will record all those fees under the same payment transaction. So then, when that data is imported to the analytics cubes, it has no frame of reference to tell which performance or production season that fee transaction is associated with.

Again, this is all just speculation on my part, so take this information with a grain of salt. That being said, there is the fees by performance report that comes standard in Tessitura, and you can run it by season and then choose to group the results by Production season. Of course, its just text and numbers and you can't output the data into a neat graphic like you can in analytics, so I still think what you are trying to do is pretty neat, and might still do some research to see if its possible.