Request and Workflow Process
Page 1 of 1
Request and Workflow Process
I need some advice on what would work best here.
We have a system that takes a Request and sends it down a workflow. There are a number of different workflow routes and the route can change mid-process. Also, a user can diverge some routes for additional approvals. In all, there were too many options to model a workflow in 1 wide table as an accumulating snapshot.
I have a workflow step fact table that will track the step name, who took action, the action taken, and the request that step belongs to. That answers many questions, but leaves many unanswered questions. The request has a lot of attributes that have nothing to do with the workflow that need to be reportable. So, Request is basically a factless-fact dimension table. There is a lot of reporting that can be done using request, but my issue with it is how do I handle reporting hierarchies.
Example, A request has a inital requester and gets a request manager assigned to it along the line. Would I store those employeeIDs at the Workflow Step level, or at the Request level? They don't want to see the request manager assigned change, they just want to see by Business Unit, drill down to department, final drill down to RM assigned.
I have a habit of overanalyzing, so please, suggestions would be helpful. Thanks.
We have a system that takes a Request and sends it down a workflow. There are a number of different workflow routes and the route can change mid-process. Also, a user can diverge some routes for additional approvals. In all, there were too many options to model a workflow in 1 wide table as an accumulating snapshot.
I have a workflow step fact table that will track the step name, who took action, the action taken, and the request that step belongs to. That answers many questions, but leaves many unanswered questions. The request has a lot of attributes that have nothing to do with the workflow that need to be reportable. So, Request is basically a factless-fact dimension table. There is a lot of reporting that can be done using request, but my issue with it is how do I handle reporting hierarchies.
Example, A request has a inital requester and gets a request manager assigned to it along the line. Would I store those employeeIDs at the Workflow Step level, or at the Request level? They don't want to see the request manager assigned change, they just want to see by Business Unit, drill down to department, final drill down to RM assigned.
I have a habit of overanalyzing, so please, suggestions would be helpful. Thanks.
TheNJDevil- Posts : 68
Join date : 2011-03-01
Similar topics
» ETL: process row by row with pipeline between steps or process the whole datasets in every step?
» Calculate minutes between workflow steps
» Extract Archive Process
» I request an opinion on a modeling problem
» Admission Acceptance Process
» Calculate minutes between workflow steps
» Extract Archive Process
» I request an opinion on a modeling problem
» Admission Acceptance Process
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum