Скачать или смотреть Dynamics 365 AX Power BI Project Module Sales and drill through to Timecards and Fees

In this example we show how to drill through from Project module summary sales page to Timecard and Fee detail by project page. As you could expect the core 'functionality' is in SQL scripts and we are reviewing them in details. Similar scripts could be used in 'traditional' reporting tools, such as Crystal, Excel, Access or SSRS
Steps
1. Script: Summary Project Accounting Invoices by Customer
2. Detail: Timesheets and Fees by Project. You can add similar by Items, etc and add additional detail pages. Or if you like all-in-one, you can unionize all PA associated expenses and show them on one page - out of scope here
3. Summary visualizations: Map - PA invoicing data by customer address; Summary table
4. Detail table with drill-up to summary and drill-through back to detail
Narrator Andrew Karasev help@efaru.com 331 330 6879