Bookshelf Home | Contents | Index | PDF |
Siebel Business Analytics Server Administration Guide > Administration Tool Utilities and Expression Builder > Utilities and Wizards > Extracting Analytics Metadata Using Dependency TrackingThe 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
When executed, it shows the Save As dialog (exactly same behavior as Repository Documentation). |
Siebel Business Analytics Server Administration Guide |