data import

how to import data from one module to another module when dimensions are not match.

 

Answers

  • @saurabh_kumar_kunwar 

    It depends on the case. Please share your aim.

    Some solutions:

    • If there are less dimensions in the target module you have to setup such a view that the values are taken from top level only for this dimension (Select Levels to Show setting)
    • If there is a new dimension in the target than you have to add list-formatted (or text-formatted for item code) line item which will be used as mapping property.
    • You also can create a transactional module with the exact dimensions as in the target, but with data aggregated from the source module (using mapping properties for aggregations). After setting up all the formulas for this module it can be used as your import source