Sql server Analysis services

SQL Server Analysis Service (SSAS) provides a way to centralize all of our business logic, calculations, business definitions, KPIs, incorporate time and financial intelligence, and utilize data mining capabilities. The SSAS engine can pre-aggregate the results and build aggregations based on usage to provide for quick data retrieval and results. When detailed data from the relational databases is loaded into a multidimensional OLAP database, summarized values are pre-calculated. Because summary values are stored in the database, reports and analytical queries execute quickly. Complex calculations can be created and then stored in the OLAP databases. This makes information access easier, because report and query don’t have to repeatedly create calculations, everyone in the organization will be able to use the exact same calculation formula.