Metadata is “data about data” and in the BI world this means two things:
There are a number of placeholder in all parts of SQL Server to support this, from extended properties in the database engine , actions in analysis services can take you to a website describing each calculation, and integration services extensive logging capabilities.
To help make sense of your options there is a Metadata toolkit containing a whitepaper and and a number of tools:
This is all designed to work on SQL Server 2005 and should be fine with SQL Server 2008. My only word of caution is that report models are not being developed further and that the whitepaper only refers to Report Builder v1.
Anyway it’s a useful (and free) set of tools and you have the source code to hack it around to get it do what you need. e.g. compliance requirements (Sarbannes Oxley, Data Protection, Basel II etc.) or simply to make your BI project more accessible to your users and easier to maintain.
Metadata (data about data) is becoming increasingly popular not just to meet ever more stringent auditing
could this be a consideration for open source development?
I have been meaning to follow-up with you in regards to this posting. You mentioned this statement 'word of caution is that report models are not being developed further'. Is there any chance you could provide some additional information about this? Is the direction MS is going to utilize the UDM layer within SSAS or create something like this to possibly replace the Report Models. Just trying to determine where this layer will exist and what the future holds. Thanks. You can contact me directly if you want through my blog if you want to take this offline.
Report models are being developed further for Gemini, but only as a frontend for relational sources. The ability to create a model over a cube as you could in SQL Server 2005 as you could form report manager is not being further enhanced.
That's about all I know at the moment. I will update this post /re post as the details of Gemini become clearer
Thanks for the information and that is really unfortunate to hear about the lack of support against an OLAP source. The current model support and functionality with models against SSAS is not a good experience and seems like the ball was dropped. Wish this would have been enhanced or developed further to provide more support and functionality. Most people don't even know that it exists or maybe they just choose to ignore it. I can only hope that something new will come in the future for end-users to be able to use for that layer to be able to report against OLAP sources.
can I ask you to register your opinions on http//:connect.microsoft.com