Siebel Business Analytics Server Administration Guide > Administration Tool Utilities and Expression Builder > Utilities and Wizards >

Extracting Analytics Metadata Using Dependency Tracking

The Dependency Tracking utility allows you to extract analytics metadata to a flat file so that it can be loaded into Excel and RDBMS. You can query the resulting file to answer questions such as "if I delete physical column X, what logical columns will be affected?" or "How many places in the business model refer to the physical table W_SRVREQ_F". Then you can establish dependency relationships among elements in the repository.

CAUTION:  Excel only allows data sets of 65,536 rows. It is very easy to exceed this in a repository such as SiebelAnalytics.rpd. Therefore, you may wish to run dependency tracking on a subset of the repository by extracting out relevant business models into a new project.

Dependency Tracking creates a comma-separated values file, a tab-separated values file, or an XML file that shows the connections between the presentation and physical layers in the current repository. This file can be imported into a repository as a physical layer (for example, using Import from XML).

NOTE:  This file excludes any information about repository variables.

To use dependency tracking to extract analytics metadata

1. From the Tools menu, choose Utilities.
2. In the Utilities dialog box, choose Dependency Tracking and click Execute.
3. In the Save As dialog box, type a file name.
4. From the Save as type drop-down list, select the type of file.
5. Click Save.

When executed, it shows the Save As dialog (exactly same behavior as Repository Documentation).