Self-Service Report Builder
SOW 3.7 — select governed fields, filters and measures, preview instantly, and export to Excel, CSV, PDF or print.
Rows returned
28
limit 100
Groups matched
28
Distinct combinations
Transactions scanned
14,312
After filters
Fields selected
6
2 dimensions · 4 measures
Restricted fields
Masked
Row-level access
Saved & standard reports
Approved starting points, including the priority report conversions. Load one, then adjust.
1 · Choose fields
Governed dimensions from the semantic model. Restricted fields require Benefits & Census Access.
Workforce
Organization
Payroll
Activity
Time
2 · Choose measures
Reusable calculations promoted into the governed semantic model.
3 · Filters
Restrict by dates, employees, events, contracts, cost centers and any other governed dimension.
No filters — the report covers all permitted rows.
4 · Preview & export
Results refresh as you build. Every column is sortable and every view is exportable.
DivisionPay TypeDistinct EmployeesHoursGross PayFully Burdened Cost
| Special Operations | Regular | 23 | 36,584 | $1,218,586 | $1,971,742 |
|---|---|---|---|---|---|
| Special Operations | Overtime | 23 | 3,695 | $187,062 | $265,691 |
| Special Operations | Special Assignment | 22 | 685 | $1,291 | $1,336 |
| Patrol District 3 | Regular | 15 | 24,384 | $792,547 | $1,305,101 |
| Patrol District 3 | Overtime | 15 | 2,464 | $119,523 | $172,538 |
| School Resources | Regular | 14 | 29,755 | $974,176 | $1,598,334 |
| School Resources | Overtime | 14 | 2,724 | $132,962 | $190,830 |
| School Resources | Special Assignment | 14 | 609 | $600 | $621 |
| Patrol District 4 | Regular | 13 | 33,901 | $927,468 | $1,528,004 |
| Patrol District 4 | Overtime | 13 | 2,781 | $114,465 | $165,547 |
| Judicial Services | Regular | 12 | 27,122 | $884,856 | $1,458,659 |
| Judicial Services | Overtime | 12 | 2,161 | $106,995 | $154,476 |
| Communications | Regular | 11 | 19,604 | $526,712 | $885,706 |
| Communications | Overtime | 11 | 1,975 | $79,960 | $117,658 |
| Patrol District 2 | Regular | 6 | 12,053 | $397,799 | $645,705 |
| Patrol District 2 | Overtime | 6 | 1,063 | $53,935 | $76,780 |
| Patrol District 1 | Regular | 6 | 17,998 | $511,990 | $896,992 |
| Patrol District 1 | Overtime | 6 | 1,424 | $61,171 | $92,322 |
| Patrol District 4 | Holiday Worked | 6 | 160 | $6,406 | $9,201 |
| School Resources | Holiday Worked | 6 | 136 | $6,810 | $9,838 |
| Patrol District 1 | Holiday Worked | 4 | 120 | $4,776 | $7,407 |
| Judicial Services | Holiday Worked | 4 | 112 | $4,637 | $6,797 |
| Communications | Holiday Worked | 2 | 32 | $1,326 | $1,952 |
| Patrol District 2 | Holiday Worked | 2 | 48 | $1,990 | $2,910 |
| Patrol District 3 | Special Assignment | 1 | 61 | $67 | $70 |
| Judicial Services | Special Assignment | 1 | 10 | $12 | $12 |
| Patrol District 3 | Holiday Worked | 1 | 24 | $923 | $1,380 |
| Special Operations | Holiday Worked | 1 | 24 | $1,040 | $1,548 |
Built over the governed payroll fact table (Oracle Payroll ADG, Kronos timecard export) joined to the approved workforce, event, contract and benefit dimensions. Restricted fields obey row-level access, and every export carries the source and refresh context.