Requirements for using multiple information objects
In
“Selecting a data source” in
Getting started, you learned how to select an information object, a data object, or a data set that is defined in a template to retrieve a particular set of data to use in your report. The data fields you insert in a table in a report design typically come from a single information object or a single data set.
For usability and performance reasons, a data administrator can organize data in a suite of information objects rather than in a single information object. For example, rather than include all customer data and order data in a single information object, a data administrator can organize data in two information objects; one information object retrieves customer data, and another information object retrieves order data. To create a report that displays order data for every customer, you would use data from both information objects.
You can use data from two or more information objects if the following requirements are met:
You have been assigned an advanced user role.
You have access to multiple information objects that can be combined.
In addition, you should have knowledge of the following:
The principles of combining, or joining, database tables. To use data from two or more information objects, you join information objects in a similar manner.
The structure and the relationship among the information objects whose data you want to join.
You can join information objects only. You cannot join data sets in a template, or those in a data object.