Hi!
I am trying to create a list of monthly transactions by order number that includes the date & time of the transaction and constituent info (like name & email). When done in Analytics, we can't figure out how to get the timestamp on the transaction date. Any help on this would be much appreciated!
Thanks!
Genevieve
Hi Genevieve,
Analytics doesn't support time generally across date fields (you can find Hour on a few fields in the Seats and Tickets cube). Please vote here Enhance Tessitura Analytics date fields to include time - Ideas - Ideas - Tessitura Network.
Order Hour is good for some metrics on "busyness", but I've wondered for a while about hour in the other date fields. Is it an issue of the amount of data being pulled from the warehouse into the dashboard?
Nah… well, sort of. It’s kind of weedy. Sort version is, yes, if we needed to inflate every date dimension to include a row for every distinct datatime that exists in the data warehouse so that the join between the fact table and date dimensions work. But, also no, because we'd take a different approach to meet this need: probably adding a datetime field to the fact table from which the date dimension is joined.