Having a large amount of data at your disposal for creating a Data Source necessitates a great effort in creating a good structure of data with the necessary relationships between its elements.
Here are some of the tools, provided by BIP 11g Data Model Editor to design links between elements in your Data Model structure.
You will see how the structure of the Data Model changes, after different data connections (links) are created.
As shown in the following screenshot, the Data Sets added are:
Independent: An HTTP type Data Set
trend: An Oracle BI Analysis type Data Set
Sales: A XML file type Data Set
countries: A Microsoft Excel file type Data Set
reader, library, and book: SQL Query type Data Sets
No links between the inserted Data Sets are created at this moment.