Share the Dimension Line
A shared dimension line is useful for simultaneously exploring related information in more than one report. When you have more than one report open, and the reports share a dimension line, all changes to dimensions in one report automatically appear in the other report.
For example, you create two reports based on the same data source to help you analyze the sales performance of your product line. One report shows trends in products for 2005 and 2006, and the other shows revenue for each customer type in each location. When you drill down on 2006 to show revenue by quarter, the other report is filtered to show data for the same time period.
You can use different measures in each report. If you change the measure in one report, the other reports is not affected.
By default, all reports created from the same data source share the dimension line. If you want to drill down and filter in one report without affecting other open reports, change the default preference for sharing a dimension line.
Procedure
- Open the reports you want to work with.
- From the Window menu, select a tile option to view all reports.
- From the File menu, ensure that Shared Dimensions is selected.
- Use exploration options such as drill down or filtering in one report.