Reference data management — using PowerTable as the 'single source of truth' for planning dimensions

Started by Omar Hassan · 1 year, 5 months ago · 3 replies · 1 view

Omar Hassan Participant

1 year, 5 months ago

We have multiple planning dimensions (cost centres, departments, legal entities, product categories) that currently live in spreadsheets and get out of sync with our ERP. I want PowerTable to become the authoritative source for these dimensions that feeds into both planning and the semantic model. Is this the right architecture?

3 Replies

Sort

Marcus Delacroix

Senior BI Architect · Peak Logistics Europe · 1 year, 5 months ago

One consideration: for dimensions that already exist in your ERP, you need to decide whether ERP is the master or PowerTable is the master. Most clients choose ERP as master and use PowerTable to add forward-looking dimensions (e.g., planned cost centres for next year) that don't exist in the ERP yet.

Up

0

Raj Subramaniam

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

This is one of the canonical PowerTable use cases. PowerTable maintains the dimension tables as governed SQL tables. The semantic model reads from those tables via a connection to the Fabric SQL database. When a new cost centre is added in PowerTable, it appears automatically in planning and reporting without any manual sync.

Up

0

David Thornton

Director of Enterprise Analytics · Stellar Manufacturing · 1 year, 5 months ago

We deployed this for our legal entity dimension. Finance now adds/modifies legal entities in a PowerTable app with an approval workflow (two-person approval for new entity creation). The approved entity immediately appears in the semantic model at the next refresh. Zero spreadsheets, zero manual sync.

Up

0