Microsoft SQL Server 2014 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Delivering Data to Users
SSAS provides a great deal of flexibility for building scalable OLAP solutions, but how do you present the data to users? The client-side components deliver much of the functionality of SSAS, using the same code base for the dimensional calculation engine, caching, and query processing. You can use the Pivot Table Service to manage client/server connections, and this is the layer for user interfaces to access SSAS cubes through the OLE DB for OLAP interface. ADO MD provides an application-level programming interface for development of OLAP applications. Third-party tools and Microsoft Excel and other Microsoft Office products will use the Pivot Table Service and PowerPivot to access cubes.
Slices of data that are retrieved ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access