SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Linking Data from Multiple Sources

alaina avatar
alaina
19 diapositives · 439 Views · Jan 29, 2013

Linking Data from Multiple Sources. Agenda. Linking multiple data providers Filters for Join Effects Variables for linked data providers Linking external data sources. Linking Multiple Data Providers. Why do you need MDP? What are the common fields across data providers?

Linking Data from Multiple Sources - slide 1
01 / 19Linking Data from Multiple Sources
1 / 17

Télécharger la présentation

Linking Data from Multiple Sources
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Linking Data from Multiple Sources Vanderbilt Business Objects Users Group

  2. Agenda • Linking multiple data providers • Filters for Join Effects • Variables for linked data providers • Linking external data sources Vanderbilt Business Objects Users Group

  3. Linking Multiple Data Providers • Why do you need MDP? • What are the common fields across data providers? • What is the relationship between the data providers? Vanderbilt Business Objects Users Group

  4. Linking Multiple Data Providers • Review data in both providers Vanderbilt Business Objects Users Group

  5. Linking Multiple Data Providers • Check for automatic links • Do you want all automatic links? • Purge without editing preserves links Vanderbilt Business Objects Users Group

  6. Linking Multiple Data Providers • Basic linking allows easy sectioned reports. Vanderbilt Business Objects Users Group

  7. Filters for Join Effects • How does BO relate multiple data providers? • Is this what you want? • Equijoin vs Outer Join Vanderbilt Business Objects Users Group

  8. Filters for Join Effects • Intersection of linked fields DATA PROVIDER 1 DATA PROVIDER 2 intersection Vanderbilt Business Objects Users Group

  9. Filters for Join Effects • Which meta-set do you want in your report? • Which set is the key set? Vanderbilt Business Objects Users Group

  10. Filters for Join Effects • Outer Join effect is the default • The linked dimension is treated as one large list across data providers when data are combined. Vanderbilt Business Objects Users Group

  11. Filters for Join Effects • Inner Join effect requires filter • Filter Linked dimension on unlinked but consistent dimension in key data set. Vanderbilt Business Objects Users Group

  12. Filters for Join Effects • Filter creation process Vanderbilt Business Objects Users Group

  13. Variables for Linked Data Providers • Why are fields incompatible across data providers? • How do you get non-linked data into the same table? Vanderbilt Business Objects Users Group

  14. Variables for Linked Data Providers • How to reduce objects to details of linked dimensions. • Common issues. Vanderbilt Business Objects Users Group

  15. External Data Files • What data are in external files? • Where are the external files? • Would a variable do the job? Vanderbilt Business Objects Users Group

  16. External Data Files • Store external data files on network drive Vanderbilt Business Objects Users Group

  17. External Data Files • Create an External Data File Provider Vanderbilt Business Objects Users Group

  18. External Data Files • Linking external data providers Vanderbilt Business Objects Users Group

  19. Questions and Answers Thank you for your time! Vanderbilt Business Objects Users Group