Use this cube to report on the status changes of your clients over time. A client's many statuses can be organized with the field client status sequence and detailed by effective date, creation date, or revision date. Additionally, you can draw on fields from the following dimensions to complete your report:
Client, Client Name, Employee Creation, Employee Creation Name, Employee Update, Employee Update Name.
Fields
- Client Status Sequence: order of statuses in a client's status history
- Client Status Reason: the status code and description.
- Client Status Historical: all a Client's statuses excluding the current status.
Status dates - effective, creation, revision:
- Status Effective Year
- Status Effective Month
- Status Effective Day
- Status Effective Time
- Status Effective End Year
- Status Effective End Month
- Status Effective End Day
- Status Effective End Time
- Status Creation Year
- Status Creation Month
- Status Creation Day
- Status Revision Year
- Status Revision Month
- Status Revision Day
Measures
No measures for client status
Comments
0 comments
Article is closed for comments.