Show TOC

Generating a Link ProposalLocate this document in the navigation structure

Context

The system proposes possible links for the fields. Ideally, you can take these without the need for manual post-processing.

Procedure

  1. You have selected the required parameters and pressed Continue .

    Existing models are analyzed. The system checks in the workspace or higher level workspace (parent node in the folder structure of the workspace in administration) for existing CompositeProviders that contain the selected providers. The history of models that have been deleted in the meantime is also included in the analysis.

    The system displays a list of the ten CompositeProviders with the greatest similarity in terms of provider structure, sorted in descending order. Where CompositeProviders have the same ranking according to these criteria, they are sorted according to when they were last activated. A higher valuation indicates a greater match, meaning thhat te higher the valuation, the more suited a CompositeProvider is as a template. If you select a CompositeProvider and confirm your selection by pressing OK , the links and the link type of the matching providers in the CompositeProvider will be applied to the currently selected providers.

    The system automatically takes the links from the MultiProvider if you use InfoCubes from the MultiProviders defined in the workspace in your CompositeProvider.

  2. If the system cannot make any link proposals from the MultiProvider or existing CompositeProviders, it selects a provider. The connection type selected for InfoProviders from the BW system is Union , and all fields are linked with the CompositeProvider. InfoObjects as InfoProviders and analytic indexes are an exception to this. Connection type Inner Join is selected for these, and no automatic field links are created.
  3. For providers that have not been linked yet, you can generate a proposal. To do this, choose Generate Proposal .

    You now have various options for generating a proposal for links:

    • Analyze Existing Models :

      If only some providers were linked after the first analysis, you should run the analysis of existing models again. The system only takes the links for one model. There might be several suitable models though, in which case these links can be taken in a second run.

    • Analyze Metadata : This analysis method is particularly suitable for InfoProviders from the BW system. It analyzes InfoObjects, technical field names and descriptions.

    • Analyze Data : The data in the providers fields is compared here with the data in the CompositeProvider fields. This option is not available for union links. For providers that should be linked by Join , it is possible to combine the metadata and data analyses. Key figures cannot be compared using this method.

      Caution

      This method can take up a lot of runtime. You can monitor the progress of this analysis, or cancel it, in the dialog box that automatically appears. If the analysis run is terminated, the analysis results found so far are reused in a subsequent run. The administrator can also set a maximum runtime. To do this, parameter MAX_RUNTIME_PROPOSER must be changed in table RSDDTREXADMIN . The entry under Value represents the maximum runtime in seconds. If no entry is made here, the maximum runtime is 300 seconds. Value = 0 represents an unlimited runtime.

    Further Options:

    • Overwrite Existing Links : All existing links in the selected provider are removed from the analysis.

    • Take Over Fields as Dedicated : With this option, provider fields that no suitable CompositeProvider can be found to link with are assigned to the CompositeProvider as dedicated fields.

  4. The system then proposes and applies possible links. After each link proposal run, you can view and complete the diagnosis in the link details and in Details . You should always check these links, especially when using the data and metadata analysis.
  5. You can get the system to run the analysis again from the start. Choose Link Details and Complete Proposal .
    Caution

    With large amounts of data, this analysis can be very time consuming.

    In the Diagnosis column, the system now proposes which fields to link.