Change the Report Filters and Settings

Depending on how the report was created, you may be able to choose what information you see when you open the report. For example, the report author has included prompts to let you choose years and products for the report. When you open the report, the Modify Report page appears where you can specify the years and products you want to see in the report. After you make your selections, the report appears with the information you selected.

If you want to change your selections, you can return to the Modify Report page, make your changes, and view the report again. Each time you change the settings, the report is refreshed and the new information is shown. The Modify Report page is only available if the report author has included prompts in the report.

The filters and settings from which you can select are set by the report author. You may not have access to all of the filters and settings described.

• dimensions and filters

Dimensions are a broad grouping of descriptive data about a major aspect of a business, such as products, dates, or markets. Dimensions are represented by the rows and columns in a report. Each dimension appears on the dimension line of the Modify Report page, and you can select the dimensions you want to see in the report. For example, selecting Camping Equipment from the Products menu narrows the scope of the report to the information for that product.

Choose dimensions to change the information in your report. If you choose a dimension associated with the rows or columns in the report, you can drill down and drill up by selecting other categories in the folder.

You can also choose dimensions to filter information in the report. If you choose a dimension that is not associated with the rows or columns in the report, the data in the report changes to reflect the new filter.

The dimension line is shown in the following illustration. The report author settings determine how the dimensions appear in the dimension line.

• row and column content

You can swap the categories that currently appear in one area, such as the column area, with those in another area, such as the row area. For example, you may want products, which appear in the row area, to appear in the column area instead. Swapping the rows and columns allows you to change the perspective of the report or make the report fit better in the display.

• zero suppression

You can suppress unnecessary information such as zeros, missing values that appear as 'na' or zeros, and the result of dividing by zero. For example, if a row contains all zeros, you may want to suppress that row. You can do this for rows, columns, or both. Zero suppression only applies to the first measure.

• short headings

Headings apply to the category names used in the cube from which the report was created. You can select whether you want to view the long or short headings in your report.

• currency and currency format

You can set the currency that is used in the report, and how the currency is formatted, if the cube was built with that information. The settings you choose will be used in the report, even if the report was created using another currency.

Steps

1. From the PowerPlay Web Viewer toolbar, click the Change Report Settings button .

Tip: The Modify Report page also appears when you first open the report from the PowerPlay Web Table of Contents or from the portal.

2. Select the information you want in the report, and click OK.

Tip: To remove all filters from all dimensions, click the Reset Dimensions button on the dimension line.