SQL Server Analysis Services (SSAS)
Within the SSAS capabilities, tabular and multidimensional solutions are built using SQL Server Data Tools and are intended for corporate BI projects that run on a standalone Analysis Services instance. Both solutions yield high performance analytical databases that integrate easily with Excel, Reporting Services reports, and other BI applications. Both solutions result in standalone databases that can be used by any client application that supports Analysis Services:
Multidimensional and data mining solutions use OLAP modeling constructs (cubes and dimensions) and MOLAP, ROLAP, or HOLAP storage that uses disk ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
