Departmental budget ownership — 40 department heads, one CFO view

Started by François Leblond · 1 year, 1 month ago · 3 replies · 2 views

François Leblond Participant

1 year, 1 month ago

We have 40 department heads who each need to submit their own budget. I don't want them to see each other's numbers. I also want a CFO view that aggregates everything. How do I structure this in Fabric Plan?

3 Replies

Sort

Ayesha Okonkwo

Corporate Finance Manager · Meridian Bank · 1 year, 5 months ago

For the submission workflow — do you have a way to signal when a department has finalised their budget? We use a status column in PowerTable to track 'Draft', 'Submitted', and 'Approved' per department.

Up

0

Raj Subramaniam

Microsoft Fabric Consultant · CloudBridge Solutions · 1 year, 4 months ago

Model each department as an entity in your semantic model with a Department dimension. Apply RLS using user identity so each head only sees their own department's rows. The CFO role bypasses RLS and sees the full model.

Up

0

Priya Ramaswamy

Head of Financial Planning & Analysis · Nexa Retail Group · 1 year, 4 months ago

We have 35 cost centre owners with exactly this setup. Each owner submits their opex and capex budgets in their own Planning sheet view. The consolidation is automatic via the semantic model roll-up.

Up

0