The system proposes possible links for the fields. Ideally, you can take these without the need for manual post-processing.
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.
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.
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.
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.
With large amounts of data, this analysis can be very time consuming.
In the Diagnosis column, the system now proposes which fields to link.