Process Modeling - Is this a fact or a dimension?
This is a question I see a lot on forums (and also get asked) and it's generally based on confusion around events and processes (such as an incident, a bank application process etc).
Let's remember what the difference is between a fact and a dimension.
A fact table stores a business process. A fact is therefore an event or an occurence of something in that business process - whether that fact is a sales transaction, a daily snapshot amount, or a process step. A dimension provides the context around that fact e.g. location, product etc.
Read more...Tags: management, process