1 / 19

Linking Data from Multiple Sources

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?

alaina
Download Presentation

Linking Data from Multiple Sources

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related