Show TOC

Syntax documentation*DESTINATION_APP Locate this document in the navigation structure

Allowed uses: By Commit, MDX, SQL

*DESTINATION_APP = {app name}

*SKIP_DIM= {dimension name}[,{dimension name},…]

*ADD_DIM {dimension name}={value}[,{dimension name}={value},…]

*RENAME_DIM {dimension name}={value}[,{dimension name}={value},…]

Allows you to write the results of calculations to a different application. Dimensions can be added, removed, or renamed to conform with the destination application.

Example Example

When some data is entered into a divisional application, some of the data may need to also be posted into a central application that consolidates the results of different divisional applications.

*DESTINATION_APP = CentralApplication

End of the example.

In many cases, the destination application shares only some of the dimensions of the original application. In this case the missing dimensions can be dropped from the original records with the instruction:

*SKIP_DIM= {dimension name}[,{dimension name},…]

Multiple dimension names can be supplied to the instruction separated by commas, or multiple SKIP_DIM instructions can be entered in separate lines.

If the destination application has dimensions that do not exist in the original application, these can be added to the passed records, using the instruction:

*ADD_DIM {dimension name}={value}[,{dimension name}={value},…]

Multiple dimension names and values can be supplied to the instruction separated by commas, or multiple ADD_DIM instructions can be entered on separate lines.

In addition to the instructions ADD_DIM and SKIP_DIM, the keyword RENAME_DIM can be used, to change name of one or more dimensions. The syntax is:

*RENAME_DIM {dimension name}={value}[,{dimension name}={value},…]

This instruction can be used when data is to be written into an application where a dimension is named with a different ID.

Multiple dimension names and values can be supplied to the instruction separated by commas, or multiple RENAME_DIM instructions can be entered on separate lines.

Example Example

*RENAME_DIM ACCOUNT_FLASH= ACCOUNT_MAIN

End of the example.

Example Example

Here is a more complete example:

*DESTINATION_APP = CentralApplication

*SKIP_DIM= PRODUCT,MARKET

*ADD_DIM DATASRC=INPUT

*ADD_DIM CURRENCY=LC

*RENAME_DIM ACCOUNTPM=ACCOUNTMAIN

End of the example.

In this example some calculated values are transferred into a central application that is not detailed by product and market, but contains two extra dimensions (datasrc and currency). For these two dimensions the members input and lc are used. The chart of account is defined in dimension accountmain.