The DUPLICATE command is useful either of the following cases:

• in a multi-section report when the same row name appears more than once in each section.

• when the row must be captured (without printing) once at the top of each section for calculation purposes, and included again later in the section for output.

Syntax

<DUPLICATE mbrRange

Parameters

mbrRange

A single member name or selection command.

• Single member: A member already selected for the dimension can be selected again.

• Selection command: <DUPLICATE applies to all members selected by mbrRange. For example, <CHILDREN Accounts.

Notes

• If the DUPLICATE command is not used, by default the data extraction operation ignores duplicates in a group of members in the same dimension up to the point where a "!" is encountered.

• <DUPLICATE is not restricted to row dimensions. It can also be used to allow a repeat of a column or page dimension member.

Example

The following example is based on Demo Basic.

<PAGE (Market)
East 
            <COLUMN (Scenario, Year)
                Budget  Actual  
                 Jan     Jan
                                 
{ ORDER 2,0,1,3,4 WIDTH 12 0 1 NOINDENTGEN AFTER "%" 4 
  SKIPONDIM Product LMARGIN 10
}
<ROW (Product, Accounts)

{ CALC ROW "Sales" OFF }
{ CALC COL "Actual~% Sales" = 2 % "Sales" 2 }

<ICHILDREN Visual 

{ SAVEROW }   Sales
   Payroll
   Marketing
   Profit
   
<DUPLICATE  Sales
     !
         

This example produces the following report:

 
                                            East 
            Budget                           Actual    Actual 
               Jan                              Jan   % Sales 
          ========                         ========  ======== 
             1,200 Television  Payroll        1,236       25%
               440             Marketing        365        9%
             1,240             Profit         1,295       26%
             4,800             Sales          5,244      100%
                         
             1,030 VCR         Payroll        1,044       25%
               150             Marketing        156        4%
             1,466             Profit         1,417       35%
             4,200             Sales          4,311      100%
                         
             1,195 Camera      Payroll        1,167       42%
               300             Marketing        288       11%
               528             Profit           400       19%
             2,850             Sales          2,656      100%
                         
             3,425 Visual      Payroll        3,447       29%
               890             Marketing        809        8%
             3,234             Profit         3,112       27%
            11,850             Sales         12,211      100%