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 ...