I’m wondering what is OLAP table to be built to underline the step of the process in which the expire date of my invoice occurs.
I just simply want to understand if I can build something that tells me something like:
“the invoice becomes overdue (expire date has passed) when still being in its ‘invoice accepted’ step”
"half of my invoices are still in their “goods receipt verification” step when they become overdue
Can you help me?
Thank you very much