Driver Detector Logitech

Analysis Services Report Pack

before yesterday, my client asked me if it was possible to have a "map" of its base OLAP we're building. By mapping he heard a minimum get a listing of all measurements, dimensions and existing levels. My first reaction was to check if BIDS Helper had no such feature in a hidden corner. Move along nothing to see very interesting on that side!

Then I rushed to Google to see if there was not a SQL Server Report Pack as one who had appeared for SQL Server 2005 Analysis Services but focused. Nor is there live in Redmond. By

cons digging a bit I came across the excellent company blog

Capstone

and superb Metadata Analysis Services 2008 Report Pack

.

An overview of rendering Reporting Services reports available:

And to please my friend Francis

, there is even info on Data Mining: To install the package you need to create a linked server in SQL Server is the SQL script has to match with the configuration of your machine:

master.dbo.sp_addlinkedserver EXEC @ server = N'SSAS_METADATA ', @ srvproduct N'SSAS =', @ provider = N'MSOLAP ' @ Datasrc N'localhost = '= @ provstr N'Provider MSOLAP.4 =', @ catalog = N'Adventure 2008R2 Works DW 'EXEC @ master.dbo.sp_addlinkedsrvlogin rmtsrvname N'SSAS_METADATA =' = @ useself N'False ', @ locallogin = NULL, @ rmtuser = NULL, @ rmtpassword = NULL

Then deploy Reporting Services reports.

Let me repost the entire solution

Dan Meyers here ; version in which I corrected the drive connections via a connection to the linked server.

Besides responding to specific need of my client, I tell myself that these reports could very well find their place in the technical documentation to achieve project completion.