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:
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.