Add and Reorder Measures

When you open a cube in PowerPlay Web, the measures defined for your cube appear in the order defined in Transformer. You can change this order in your report. You can also add and reorder multiple measures to the report.

You can reorder measures in your crosstab using drag-and-drop. PowerPlay maintains this order in any layout view. Only the top-level measures in the Measure dimension can be reordered.

When you save or close your cube, the new order is lost. To retain this order for future use, you must save your report (if you are using the portal), export it in .pdf or .csv format, or prepare a bookmark for it .

To reorder measures, you must be using Internet Explorer as your Web browser.

Steps

1. In the dimension viewer, right-click the Measures folder, and then click either Replace Rows or Replace Columns.

The measures are shown in the rows or columns.

2. In the crosstab, click a measure that you want to move within the list.

Tip: You can also click a measure in the dimension viewer.

3. Drag the measure to the highlighted area that appears between two other measures in the list.

Tip: If you are dragging from the dimension viewer a measure that is hidden in the report, the measure becomes visible.

4. Repeat steps 2 to 3 until all the measures appear in the PowerPlay Web display in the order that you want.

Tips

• You can create this custom ordering whether your measures appear as rows or as columns.
• A cube may contain precalculated categories that were inserted when the cube was created. To hide these categories, click the Display Options button on the PowerPlay Web toolbar, click Options, and then, in the Hide Calculated Categories Defined in the Cube check box, click Apply.