Report Portal

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

 

2007-2015 VidasSoft Systems Inc.