ROW

Determines the row dimensions for a report whose member names appear in the data rows of the report.

The member(s) in the command determine which dimensions from the Database Outline are displayed in the rows.

dimList is a list of members or dimension members that specifies the order, from left to right, in which the row headers are listed unless subsequently moved by ORDER or NAMESCOL. Each dimension may be represented only once in dimList.

Syntax

<ROW ( dimList )

Parameters

dimList: Dimension name or a comma-delimited list of dimensions.

Notes

If dimension names contain spaces or consist of numbers, they must be enclosed in double quotes.
When more than one dimension is specified the first dimension in the list appears in the leftmost row Name column, the next dimension in the list appears nested to the right of the first, and so on.
By default attribute calculation dimension members (for example, SUM, AVG) are displayed as columns. To display them in rows, you must include them in the ROW command.

Example

<ROW (Product)

creates a report with each member of Product as a row in the report.