March 2018
Beginner
562 pages
11h 42m
English
book
Microsoft Dynamics 365 Enterprise Edition - Financial Management - Third Edition
by Mohamed Aamer Ala El Din
Content preview from Microsoft Dynamics 365 Enterprise Edition - Financial Management - Third Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Database management
The relational database (Microsoft SQL Server) that stores all the ERP-related transactions is known as online transactional processing (OLTP). For BI reporting with a SQL Server, SSAS can store the aggregations, measures, and dimensions. This results in a higher performance in querying reports. It is also important to consider backup and restore strategies.
Reports from Microsoft Dynamics 365 for Finance and Operations are based on the SSRS approach and Financial Reporting.