Setting Page Breaks

Creating sections in a report allows you to then create page breaks off of those sections.

To create a section:

1.      Highlight the column you would like to use as the section.

2.      Click on the Section icon.

To create the Page Breaks:

1. Highlight the sectioned report item

2. Change Layout \ Set Page Breaks

To see the page breaks:

1. Run Report

2. View as PDF

Note: The PDF file will show a page break after all the products for each retailer listed.

In this example there is a section on Retailer and Product Line.  Use Page down to see how the report pages break after each product for a retailer.

Setting Page Breaks

Controlling page breaks in Analysis Studio is dependent on having Context Filters in a report.

Report with two context filters:

The first context filter will automatically page break based on its hierarchy.  Select an Order Method (i.e. Sales Visit) for the second context filter.

Turning page breaks on: Run \Report Options \ Display Tab \ checkmark next to Context Filter you want to break the page on and click on OK.
Page Break on Retailer Context Filter

Page Break results in PDF format:

Each page shows Revenue by Retailers for the Sales Visit – Order Method.

Creating a simple member calculation

Version 8.4 allows you to create simple calculations in dimensional data sources using the calculation icon just like you do in Analysis or Query Studio.

1. Create a crosstab report off of a dimensional data source like this one created off the Sales and Marketing cube.

2. Select the Revenue and Planned Revenue column title headers (crosstab node member)

3. Click on the calculation icon.

4. In the drop down list select: Revenue – Planned Revenue

Note: The order you select the columns determines the math order of operations.

The report with the calculation added:

Run the report to see the results: