The aim of the project was to bridge the gap between the tasks given and money spent for a given patent and to establish an agile unified reporting system. There are several key dimensions that provide insight into performance and profitability that when woven into a reporting cube, allow users to make more informed decisions than they have been able to make before.
A cube was built using SQL Server Analysis Services. There were several dimensions upon which users need to be able to pivot and rearrange the data.
Microsoft SQL Server Analysis Services, MS SQL 2008
Stay updated with tech trends,
our company news and case studies