Linking Data from Multiple Sources

Vanderbilt Business Objects Users Group 1

Agenda

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

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 3

Linking Multiple Data Providers

• Review data in both providers Vanderbilt Business Objects Users Group 4

Linking Multiple Data Providers

• • • Check for automatic links Do you want all automatic links?

Purge without editing preserves links Vanderbilt Business Objects Users Group 5

Linking Multiple Data Providers

• Basic linking allows easy sectioned reports.

Vanderbilt Business Objects Users Group 6

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 7

Filters for Join Effects

• Intersection of linked fields DATA PROVIDER 1

intersection

DATA PROVIDER 2 Vanderbilt Business Objects Users Group 8

Filters for Join Effects

• Which meta-set do you want in your report?

• Which set is the key set?

Vanderbilt Business Objects Users Group 9

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 10

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 11

Filters for Join Effects

• Filter creation process Vanderbilt Business Objects Users Group 12

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 13

Variables for Linked Data Providers

• How to reduce objects to details of linked dimensions.

• Common issues.

Vanderbilt Business Objects Users Group 14

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 15

External Data Files

• Store external data files on network drive Vanderbilt Business Objects Users Group 16

External Data Files

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

External Data Files

• Linking external data providers Vanderbilt Business Objects Users Group 18

Questions and Answers

Thank you for your time!

Vanderbilt Business Objects Users Group 19