<DUPLICATE

Command

The DUPLICATE command allows a member name to occur more than once in a dimension group selection.

Syntax

<DUPLICATE mbrRange

mbrRange Specifies 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.

Description

This command is useful either (a) in a multi-section report when the same row name appears more than once in each section or (b) 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.

Example

The following example is based on Sample Demo.

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

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.

See Also

PAGE
COLUMN
ROW