Create Page Layers

When working with dimensional data, you can create page layers in a report to show values for each member on a separate page. For example, your report contains payroll information for the entire company. You want to view values for each department on a separate page.

After you create page layers, a caption appears in the header to indicate the contents of each page. You can navigate between the different pages using links below the report.

Creating page layers is similar to using context filters. However, with context filters, values are filtered according to the member you add to the Context filter area. With page layers, the report is split into a separate page for each child of the member you add to the Page layers area.

When you produce reports in Excel 2007 format, you can configure IBM® Cognos® Business Intelligence to dynamically name the Excel worksheet tabs, based on the data items that are used to break pages. For example, you specify to break pages by Product line. In Excel 2007 output, the five worksheet tabs that are generated are named Camping Equipment, Mountaineering Equipment, Personal Accessories, Outdoor Protection, and Golf Equipment. To dynamically name Excel worksheet tabs, ask your administrator to add the RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE advanced setting to the report service. For more information, see the IBM Cognos Business Intelligence Administration and Security Guide.

Procedure

In the source tree, select or search for one or more items on which to filter.
Drag the item into the Page layers section of the overview area.
The crosstab shows the results for the children of the selected item on separate pages, and a list appears under Page layers.

Tip: To navigate between pages, click Page down and Page up below the report.
To replace the page breaks with items from the same dimension, select an item from the list. To delete the page breaks, from the list, click Delete. To delete all the page breaks, right-click the Page layers area and click Delete All.