Dimension Placement in the Report Editor

You can use the Report Editor at any time on a valid report to re-arrange the layout or change the members in each section of the report: move (pivot) one or more dimensions between the page axis, row axis and column axis; reorder the nesting of dimensions within an axis; or change the selection or order of members of one or more dimensions in the report.

To define your layout, simply drag and drop your required dimensions to the correct sections of the report. This includes moving the dimension name from one section to another or changing the order of the dimensions within a section.

In the Dimensions area, the dimensions and hierarchies with a red cross indicate that they already appear in the report. Dimensions that are not already in the report can be dragged into the layout from there. To remove a dimension from the layout, drag it to the Dimensions area.

If you add a dimension to the page axis section, it will default to the cell on the right side of the page axis that you drop it under.

To remove all dimensions from the layout, click Reset Report.

Example

In the following example you can see the effect of the order of the dimensions in an axis. This applies to the column axis also.

Account Before Product	Product Before Account
Row Axis Dimensions: Account Product.Family	Row Axis Dimensions: Product.Family Account