Pushdown

Use this command to copy data from a parent symbol to its leaf descendants. Using the Pushdown command, data is processed by looping through a list of accounts and executing a model to transfer data for each account in the list.

Calculate PUSHDOWN SourceParents Dimension DataArea [RestrictDimension Sources Targets]

where:

• SourceParents is a range variable, consisting of a list of parent symbols to transfer the data from.
• Dimension is the name of the dimension to perform the calculation on.
• DataArea is the name of the DataArea to perform the calculation on.

  Note: The DataArea must contain only the symbols required for the calculation.

• Sources is a range variable, consisting of a list of source symbols for the restrict dimension.
• Targets is a range variable, consisting of a list of target symbols for the restrict dimension.

Note: The number of symbols in the Targets range variable must match the number of symbols in the Sources range variable.

The following code is an example of how to set up the range variables for Sources and Targets (in the example, there are two restrict dimensions).

Example - how to set up the range variables for Sources and Targets (in the example, there are two restrict dimensions).

Set Variable rSources = 
"GrsEOY_ASC|GrsEOYIP_ASC|NetNBOY_ASC|NetNBRBOY_ASC|NetNBOYA_ASC|NetNEOY_ASC|NetNEOYIP_ASC|NetNEOYCLSSIP_ASC" 
 
Set Variable rTargets = 
"tGrsEOY_ASC|tGrsEOYIP_ASC|tNetNBOY_ASC|tNetNBRBOY_ASC|tNetNBOYA_ASC|tNetNEOY_ASC|tNetNEOYIP_ASC|tNetNEOYCLSSIP_ASC" 
For each sEntity in E_ENTITIES 
 
Set Variable sNATCUR = [[SYMBOL, ZGPNativeCurrency, $sEntity$]]

Calculate PUSHDOWN rSatCNCP ACCOUNTS dataArea CURRENCY sNATCUR sNATCUR ELEMENTS rSources rTargets

See also

• Set Variable
• UserExists