NOROWREPEAT

The Essbase Report Writer NOROWREPEAT command prevents row member names from being repeated on each line of the report if the row member name does not change on the next line. This is the default.

Syntax

{ NOROWREPEAT }

Notes

This command prevents row member names from being repeated on each line of the report if the row member name does not change on the next line. NOROWREPEAT is only used to cancel the effects of the ROWREPEAT command. The ROWREPEAT command causes all row member names to be displayed on every line of the report even if the names for some members are the same.

Default Value

Because NOROWREPEAT is the default, you need only use this command after using ROWREPEAT.

Example

The following example is based on the Demo Basic cube, available in the gallery of applications in the Essbase file catalog.

The following report is an example of the default behavior for row names not repeating. The names only print when they change.

<PAGE (Market, Accounts)
Chicago Sales

      <COLUMN (Scenario)
      Actual

<ROW (Year, Product)
{ NOROWREPEAT }
<ICHILDREN Qtr1
<ICHILDREN Audio
!
{ ROWREPEAT }
<ICHILDREN Qtr2
!

Which produces the following report:

                    Chicago Sales Actual 

Jan              Stereo                923 
                 Compact_Disc        1,120 
                   Audio             2,043 
Feb              Stereo                834 
                 Compact_Disc        1,050 
                   Audio             1,884 
Mar              Stereo                834 
                 Compact_Disc          980 
                   Audio             1,814 
  Qtr1           Stereo              2,591 
                 Compact_Disc        3,150 
                   Audio             5,741
                                   
                    Chicago Sales Actual 

Apr              Stereo                821 
Apr              Compact_Disc          985 
Apr                Audio             1,806 
May              Stereo                821 
May              Compact_Disc        1,014 
May                Audio             1,835 
Jun              Stereo                834 
Jun              Compact_Disc        1,022 
Jun                Audio             1,856 
  Qtr2           Stereo              2,476 
  Qtr2           Compact_Disc        3,021 
  Qtr2             Audio             5,497

Related Topics

ROWREPEAT