By using the Data sources window, you can create multiple data source within a single report. When a report contains multiple data sources, both report elements and tool windows can behave differently than when only a single data source is available.
Changes to Report elements
When creating a new report element that is based on a data source, such as a grid/chart/kpi's/etc., you will be prompted to specify the data source the element will display the results for. The prompt will look like this:
An element that has been linked to a source can not be reassigned to another source. If you want to do this, you will need to create a new element.
Changes to Tool windows
Some tool windows, such as Filters/Dimensions/Conditional appearances/etc., display information related to a single data source. When a report contains multiple data sources, these windows must have a mechanism to tell them which data source information is to be displayed, and also communicate back to the user which data source is being used in the window. This is done with the data source drop-down box which is added the tool window as shown below.
The data source drop-down box shows the name of the data source for which the information is being displayed. To base the information on another data source, press the down arrow and select the data source you wish to use from the list.
DataWarehouse Explorer tries to make the information in the tool windows adapt to what you are doing at the moment. It does this by using the concept of a "current" data source. Setting the current data source will cause all tool windows (that are bound to a data source) to use that data source as the source of information. You can set the current data source by clicking on a report element. The current data source will then be set to the data source the report element is based on. For example, if you click on a grid, the Filters/Dimensions/Conditional appearances window will all show the information that is relevant for the source the grid is based on. You can also set the current data source by clicking on a data source in the data sources window. Creating a new data source will also set the new source as the current.