O'Reilly logo

Professional Microsoft® SQL Server® Analysis Services 2008 with MDX by Denny Guang-Yeu Lee, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Sivakumar Harinath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

17.2. ProClarity

ProClarity, a suite of client tools and a server helps end users to analyze data from SSAS. ProClarity was recently acquired by Microsoft and integrated into the Microsoft product suite. It now forms the foundation for Microsoft Performance Point Server 2007.

ProClarity consists of several components: ProClarity Analytical Server, ProClarity Desktop client, and a Web component to integrate with Microsoft Office SharePoint Server. In addition, ProClarity also helps in expediting the creation of Microsoft Reporting Services reports. The ProClarity Analytical Server helps you to store your organization's business logic and metadata about an SSAS cube. Typically, you will want information such as custom calculations, named sets, and annotations that can all be stored on your ProClarity Analytical Server. Using your ProClarity desktop client you can connect to your SSAS cube using the ProClarity Analytical Server. The desktop client also helps in directly connecting to your cube and analyzing data. ProClarity provides you with several ways of analyzing the data so that you can interpret the data efficiently. In this section you learn to use the ProClarity desktop applications to connect to your SSAS cube and analyze your data.

17.2.1. The Chart and Grid Views

The following steps show you how to use ProClarity to analyze the AdventureWorks cube in the Chart and Grid views:

  1. Launch the ProClarity desktop application from Start All Programs Proclarity Proclarity Desktop ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required