Hi guys! Greetings from South Wales.
I’m trying to answer what feels like it should be a pretty straight-forward question in Analytics- number of tickets sold and amount paid for them via the website in any given month. My concern around this though is the difference between the order date and transaction date, and the unavailability of the ticket paid count criteria in the Finance cube.
Our monthly revenue always come out different when the month is defined by order date rather than transaction date. And I get why- since additional products are often sold in existing orders offline by ticket office over future months. So in this instance I’d rather define the month by the transaction date- but then this is only available in the Finance cube, where I can’t use the ticket paid count criteria. Getting the number of tickets sold from Seats and Tickets cube, with the month defined by order date, and the revenue from Finance cube, with the month defined by transaction date, doesn’t feel right since they’re looking at different sets of transactions. For one it’s going to give a misleading impression of the average price paid.
Does anybody know another way around this? Perhaps I’m missing something obvious?
Many thanks!
Lawrence.
Wales Millennium Centre.
Sorry I didn't answer at the time, but I'm afraid the answer is that there simply isn't any kind of substitute for Transaction Date in the Seats and Tickets Cube. There's talk about that changing in some future version?