• Replies 3 replies
  • Subscribers 960 subscribers
  • Views 185 views
  • Users 0 members are here
Related

Point In Time Reporting

Former Member
Former Member $organization

Hello everyone!

We have recently stumbled upon an 'inconsistency' in Analytics as it relates to sales reporting and how we match that to our financial reporting. 

As we try to dig in to something like "weekly" or "daily" sales we have come across totals that vary based on the day we pull them. For example:

  • A dashboard that is refreshed on Sunday evening states that we have $100 in total sales (with no date filter).
  • I go back in the following day (after a refresh), add ORDER DATE as a filter and see that total sales for that point in time are now $90, although overall sales have gone up.

This has made it difficult to assure Board & VP's (with confidence) that our numbers are accurate. My questions are two-fold:

  • Has anyone else noticed this?
  • How have you handled managing / explaining this upwards?

I think part of our issue is that the Tessitura database is a very fluid thing - especially as it relates to the order-date. Changes / adjustments made to orders (exchanges, returns, etc) will change how past days get reported on. Order Date isn't like a batch report date (or transaction date), which have a definitive end. 

Thanks in advance for any & all feedback!

Parents
  • $organization

    Yes, "As Of" reporting is difficult with Tessitura.  The Finance eCube is probably the only one that is well set up for this.  Because transaction history is always added when adjustments are made.  In the other eCubes values that you have seen in the past are open to later amendments.  Returns, Exchanges, and so forth.  This will typically subside after the performance date.  But, give it a few days.

Reply
  • $organization

    Yes, "As Of" reporting is difficult with Tessitura.  The Finance eCube is probably the only one that is well set up for this.  Because transaction history is always added when adjustments are made.  In the other eCubes values that you have seen in the past are open to later amendments.  Returns, Exchanges, and so forth.  This will typically subside after the performance date.  But, give it a few days.

Children
No Data