Skip to Content
0
Apr 05, 2011 at 12:24 PM

Copy the movements from application A to application B with mapping

11 Views

We want to copy the movements of a source application to a target application version 7 of MS

The problem is the following:

Dimension D does not exist in the source application.

The dimension D is determined with three-dimensional source

*Source application

- Dimension A (account = account)

- Dimension B (cost center UserDefined )

- Dimension C (business area Userdefinied)

Target Application

- Dimension D (sub account) = Dimension A+ dimension B + Dimension C

How this mapping process?

After my research, there are two solutions:

Solution 1: Create a script with the following functions

  • DESTINATION_APP = XXXXX

  • = SKIP_DIM

  • = ADD_DIM DATASRC

  • CURRENCY = ADD_DIM

  • = RENAME_DIM

But I did not find the mapping function. Do you have any idea for that ?

Solution 2: use the file conversion and file transformation

But I could not make this solution work. I think that It's only possible with version NW

Question: What is the best solution?

Thanks by advance

Bastien