Chapter 11. Retrieving Data from Analysis Services
In this chapter, you will learn how to:
Create a perspective and access a cube using a perspective.
Create MDX queries.
Create an Excel 2007 PivotTable report using data from Analysis Services.
Use an Excel 2007 PivotTable report to execute actions, view KPIs, and drill to detail.
Create a SQL Server Reporting Services report using data from Analysis Services.
Your cube contains many dimensions and measures from several subject areas: sales, finance, production, and inventory. It can serve as a source of information for multiple workgroups or departments across your organization. Although this centralization is beneficial for users, application developers, and IT administrators, it might be difficult ...
Get Microsoft® SQL Server® 2008 Analysis Services Step by Step 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.
