There have been a few blog entries about the ability to add your own custom reports to SQL Management Studio in SP2, for example:
All very database-engine orientated, but it’s worth pointing out that you can do exactly the same thing when you’re connected to Analysis Services. Just right-click on an object and choose ‘Reports’. The built-in reports are very basic but I think there’s scope there for creating some really useful ones: for example, it would be cool to be able to visualise the attribute relationships on a dimension (creating diagrams rather like the ones Mosha has on his post here) or the aggregation designs stored on a measure group. If only I had the time…
Right on, Chris. That would be a good stopgap until they get this in BIDS:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=236452
I guess you\’d need to write a CRI (CustomReportItem) which renders to an image and lives in an SSRS report. Let me know when you get that done 😉
–furmangg