Data Client tools Excel, Reporting Services, Microsoft Reporting Services Power View, Excel, Reporting access PerformancePoint, and other third-party Services, PerformancePoint, and other and client tools. client tools. / storage Reporting Services Power View supported in future SQL Server versions. Data Programmability XMLA, ASSL, ADOMD.NET, MSOLAP, XMLA, ASSL, ADOMD.NET, MSOLAP, AMO, access AMO, Windows PowerShell for AMO. PowerShell for AMO. Available but less intuitive / and Developed for use with multidimensional for use with tabular models. storage models. Security Security Dimension member and cell-level Row-level security. / security. Dynamic Security. Dynamic Security. - Fewer capabilities. - More capabilities.
Data access and storage Client tools / Excel, Reporting Services, Microsoft PerformancePoint, and other third-party client tools. Reporting Services Power View supported in future SQL Server versions. Reporting Services Power View, Excel, Reporting Services, PerformancePoint, and other client tools. Data access and storage Programmability / XMLA, ASSL, ADOMD.NET, MSOLAP, AMO, Windows PowerShell for AMO. Developed for use with multidimensional models. XMLA, ASSL, ADOMD.NET, MSOLAP, AMO, PowerShell for AMO. Available but less intuitive for use with tabular models. Security Security / Dimension member and cell-level security. Dynamic Security. Row-level security. Dynamic Security. - Fewer capabilities. - More capabilities.