Database Reference
In-Depth Information
Figure 18-21.
A simple example of a metadata database
The metadata database is used to track which objects exist as part of the current BI solution and how they
are interconnected.
For example, to track the existence of an object, fill the SSRSObjects table with records of all the SSRS reports
created for the solution and include the SSRS data source and SSRS Dataset objects they use as well. Make sure
to indicate which type of object a row of data refers to using the ObjectTypeId. The ObjectTypeId is used to
reference the ObjectTypes table, which includes the object type name, like “SSRS Dataset,” and the object type
description, like “A saved SQL or MDX query and its lists of SSRS reporting fields.” If the object is no longer being
used as part of the current BI solution, indicate this using the CurrentlyUsed column.
To track how solution objects are interrelated, use the relationship tables (also called
bridges
or
associative
entity tables
). For instance, if an SSRS Dataset queries a particular table, note the table's DWObjectId and the
Dataset's SSRSObjectId in the DWtoSSRSObjects table.
