It is possible to force the output of a report to be in a tabular format that resembles a relational database query. The Report Writer commands to achieve this format are as follows:
{ROWREPEAT} command—Causes the full list of member names to be output on each row of the report, even when there are nested groups. In the following example, Ohio is repeated on each row:
Actual Sales Jan Feb Mar Ohio 100-10 130 121 134 Ohio 100-20 118 104 123 Ohio 100-30 77 65 81
{SUPCOLHEADING} command—Adding this command to the report suppresses the column headings in the report output.
Actual Sales Ohio 100-10 130 121 134 Ohio 100-20 118 104 123 Ohio 100-30 77 65 81
{SUPHEADING} command—Adding this command also suppresses the page headings in the report output. As shown in the following example:
Ohio 100-10 130 121 134 Ohio 100-20 118 104 123 Ohio 100-30 77 65 81
Also, all of the dimensions (or all but one) need to be included in the <ROW command in the report, to ensure that the data is returned in a fully normalized form.