DUPLICATE

Enables a member name to occur more than once in a dimension group selection.

This 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%