Linking Business Intelligence Reports
 

There are occassions when it is very useful to be able to view more than one BI report simultaneously and have the selection criteria linked - so that the selction in one report is automatically applied to the other report.

 To achieve this first add a second report into a space on the Excel workbook - selecting the appropriate cube:

 .
Then configure this report's layout as required - use the drop down report layout option to select this report layout:
.
.
Now you can link the reports by reference to selection criteria that exist in both reports:
.
.
Click apply.

In this example changing Acct Mgr or SOP Transaction Type in one report will automatically apply the selection to the other report.  If you wish it is possible to link reports that use different cubes.  It is also possible to link more than 2 reports.