ROWREPEAT
The Essbase Report Writer ROWREPEAT command displays all applicable row members on each row of the report even if a member describing a row is the same as in the previous row.
Syntax
{ ROWREPEAT }Notes
This command returns the report to displaying members that change from one line to the next.
Default Value
The default behavior is NOROWREPEAT.
Example
The following example is based on Demo Basic.
The command { ROWREPEAT } causes the row member names Qtr1 through Qtr4 to repeat for each line showing Compact_Disc in the report where the duplications would normally be suppressed.
<PAGE Market, Accounts)
Chicago Sales
<COLUMN Scenario)
Actual Budget
<ROW Year, Product)
{ROWREPEAT}
<CHILDREN Year
<CHILDREN Audio
!
This example produces the following report:
Chicago Sales
Actual Budget
======== ========
Qtr1 Stereo 2,591 2,800
Qtr1 Compact_Disc 3,150 3,050
Qtr2 Stereo 2,476 2,700
Qtr2 Compact_Disc 3,021 3,050
Qtr3 Stereo 2,567 2,750
Qtr3 Compact_Disc 3,032 3,050
Qtr4 Stereo 3,035 3,300
Qtr4 Compact_Disc 3,974 3,950