Choose Categories

When you open a new report, the categories from the first two dimensions on the dimension line appear as the rows and columns. To explore the categories from other dimensions, choose categories to replace the current categories or add nested categories to the report.

A category is a set aspect of your business, represented by a row or column in a crosstab. Your PowerPlay administrator organizes categories into the dimensions of a cube. Each dimension appears as a folder in the dimension viewer, and on the dimension line of your report. For example, the dimensions in a cube may include Years, Locations, Products, and Channels. The intersection of all the categories on the dimension line are calculated to give you the values for your report.

Categories appear as hyperlinks in the report. When you click a category, its child categories replace the categories in the report. When you click a summary category, the parent categories replace the child categories in the report.

You can also add any calculated categories that your PowerPlay Web administrator may have defined in a cube so you can analyze specific combinations of data.

You can choose categories using drag-and-drop or using the dimension viewer toolbar. If you use Netscape as your Web browser, you must use the dimension viewer toolbar to switch categories.

Steps Using Drag and Drop

1. In the dimension viewer, expand the dimensions to locate the category you want to show in the display.
2. Click the category, and then drag it to the column heading area or the row heading area.

Steps Using Right-clicking

1. Right-click the category in the dimension viewer.
2. Click either Replace Rows or Replace Columns.

Steps Using the Dimension Line

1. Click the dimension in the dimension line.
2. Click the category you want to show in the display.

Steps Using the Dimension Viewer Toolbar

1. If the dimension viewer toolbar does not appear under the dimension viewer, right-click the area under the dimension viewer and click Show Toolbar.
2. In the dimension viewer, expand and then click the category that you want to appear as a row or column on your crosstab.
3. In the dimension viewer toolbar, choose where to add the category you selected to the crosstab.
   • To add the category as the nested top level in the columns, click the Insert Before the Columns button .
   • To add the category as the nested sublevel in the columns, click the Insert After the Columns button .
   • To replace the category in the columns, click the Replace Columns button .
   • To add the category as the nested top level in the rows, click the Insert Before the Rows button .
   • To add the category as the nested sublevel in the rows, click the Insert After the Rows button .
   • To replace the category in the rows, click the Replace Rows button .