Pattern grounded in delivery · CHAPTER 04

RLS and reports

Access boundaries and reporting products for each role.

Pattern grounded in delivery

This cross-project example combines solutions delivered for several clients with similar needs. Organisation and engagement details have been generalised to show the repeatable architecture and delivery approach without disclosing client information.

AUDIENCES AND SECURITY

RLS delivers one truth within the right boundary

Permissions are driven by Entra ID groups and assignment tables. Everyone uses the same certified model but sees only the entities, projects or level of detail allowed by their role.

01

Board

Access boundary
the entire group and all legal entities
Decision view
consolidated performance, plan execution, project portfolio, production and material risks
Protection
workforce data is aggregated, with no access to individual rates or personal details
02

Project manager

Access boundary
assigned projects and teams only
Decision view
budget, cost, margin, hours, tasks, milestones, capacity and completion forecast
Protection
dynamic RLS through user-to-project assignments; no access to unrelated projects
03

Accounting

Access boundary
supported entities, ledgers and periods
Decision view
document detail, balances, movements, allocations, variances and reconciliation status
Protection
entity and responsibility RLS with OLS for sensitive workforce attributes

REPORTING PRODUCTS

Reports complete the process — they do not replace the data foundation

Four reporting products use the same semantic model and definitions. They differ in the questions answered, level of detail and access scope.

01

Board and directors

Executive cockpit

Revenue, cost, margin, actual versus budget and forecast, project portfolio, production execution and signals requiring a decision.

02

Project and portfolio owners

Project manager cockpit

Budget and actual cost, planned and completed hours, task progress, milestones, variances and estimate at completion.

03

Accounting and controlling

Finance and reconciliation

Balances, movements, source documents, allocations, management adjustments, control status and drill-through from KPI to ledger entry.

04

Operations and functional managers

Production and resource use

Production plan and actuals, material use, downtime, team capacity, availability and the impact of variances on timing and margin.

NEXT STEP

Do you have a similar mix of sources and audiences?

A practical first step may be a definition workshop, a data-flow map and reconciliation of one process — for example project performance or month-end close.

Contact ActiveCell Data