In pages, you can enable sharing of drill-up and drill-down actions, between reports that are based on a dimensionally modeled data source. A drill action on an item in one report causes the same action in an associated report if the report is on the same page and contains the same item. For example, when you drill down on the item 2005 in one report, all reports in the page drill down on the same item and the data for the year 2005 appears in all reports.
This functionality is enabled using the properties of the Report Viewer portlet. By default, drill actions are disabled in a page.
This functionality is not supported for dashboards with multiple tabs. However, a single page with drill-up and drill-down actions enabled can be embedded into a dashboard as one of the tabs.
In Reporting Center, create a page that contains the Report Viewer portlet for each report that you want to add to the page.
For more detailed information, see the steps in “Create a Page”.
Configure the Report Viewer portlets to display the reports that you want to add to the page.
In the portlet properties page, click Select an entry to select the report you want to display in the portlet.
In the Advanced Properties Editor of the Report Viewer portlets, for the Drill down and drill up property, select the Communicate with other portlets on the page check box.
This property enables communication between all portlets in the page using the default channel.
For more information, click the Help button in the portlet.
If you want to set up communication between only specific portlets in the page, type the channel name in the box provided.
Only the portlets that share the same channel name can interact. By specifying the channel name, you have more control over the page.