469,133 Members | 1,209 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

SQL Server BI - metadata

Within the SQL Server 2005 BI product suite, where should metadata be
held regarding database objects for reporting? What I mean is if a
user is presented with a field called "start_date" then a definition
of what exactly "start_date" means should be provided on screen to the
user.

I am hoping to be able to create a single central respository which
can be sourced by all tools - Excel, Analysis Services, Reporting
Services, SQL Server Database Engine, Crystal Reports, etc.

I guess there will need to be two levels of metadata provided:

(1) SQL Server database objects
(2) Analysis Service OLAP cube objects

Has anyone had any experience of how best to store and provide this
metadata to report users in a data warehousiong environment?

Thanks,

\M
Dec 10 '07 #1
0 1266

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Carl | last post: by
6 posts views Thread by JR | last post: by
2 posts views Thread by EP | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.