How acs-buy/fabric-opci-ec works
This is a Microsoft Fabric/Power BI OPCI audit-and-client solution. Reviewers use a mission-conduct screen to manage client files, scope, evidence, audit questions, accounting entries, conclusions and approvals; clients receive eight pages of reporting on reviewed data. Report buttons dispatch to separate client and reviewer function sets, which call database procedures; the functions also support spreadsheet exchange and evidence registration in the lakehouse. The README documents the product capabilities; the sampled function excerpts support the function-to-database and evidence-store links. The semantic-model path is identified in a setup script, but its implementation was not sampled.
Main entry points: Conduite de mission.Report Mission report · fn_ecran_client.UserDataFunction/function_app.py Client actions · fn_ecran_revision.UserDataFunction/function_app.py Review actions · DossierOPCI.SQLDatabase OPCI database
Components 10
User experience
- Mission report
fabric/Conduite de mission.Report
Mission operations
- Client actions
fabric/fn_ecran_client.UserDataFunction/function_app.py - Review actions
fabric/fn_ecran_revision.UserDataFunction/function_app.py
Data platform
- OPCI database
fabric/DossierOPCI.SQLDatabase - Semantic model
fabric/conduite_de_mission.SemanticModel
File exchange
- Evidence lakehouse
fabric/Coffre.Lakehouse
Other components
- Reviewer
- Client
- Excel workbooks
- SharePoint files
Connections 13
- Reviewer → Mission report: uses
- Client → Mission report: views
- Mission report → Client actions: dispatches client actions
- Mission report → Review actions: dispatches review actions
- Client actions → OPCI database: executes procedures
- Review actions → OPCI database: executes procedures
- OPCI database → Semantic model: supplies queried data
- Semantic model → Mission report: feeds report visuals
- Client actions → Evidence lakehouse: registers evidence
- Review actions → Evidence lakehouse: stores exports
- Excel workbooks → Client actions: imports workbook data
- Excel workbooks → Review actions: imports and exports
- SharePoint files → Evidence lakehouse: provides evidence files