Analysis Services – MDX
Analysis Services data cube structure with complex criteria to query conflicting records due to different data sources, formats and categorisation.
Task
Bring together millions of financial transactions into a one-stop-shop
Key Requirement: Bring together millions of financial transactions into a one-stop-shop using understandable business rules to categorise and enable slicing and dicing for self-service BI.
Delivered: SSAS cubes queried with MDX programming.
Finance and contract managers were struggling with different totals on critical reports, depending on complex criteria which could query conflicting records due to different data sources, formats and categorisation. We designed an Analysis Services data cube structure and fed it using controlled data preparation and cleansing processes, which enabled everyone to check their own queries whilst confident they would always reconcile.
- SSAS – SQL Server Analysis Services
- MDX – Multi-Dimensional Expressions
- Visual Studio package design
- Installation of SQL Servers
- Integration of end solution data processes