Import from module with greater dimensionality

Contributor

Import from module with greater dimensionality

Hi,

 

I'm attempting to import data from a module in another Model (monthly employment costs per employee) which has greater dimensionality than my current module (The source has a Currency List & also Versions which the current Model does not have)

 

Is there a way to SELECT a Currency List & Version item to import or do you have to create dummy lists in the current model and then map 1-1 (e.g. Fake Currency.AUD and map to the Currency.AUD in the target)

 

Thanks

 

Mark

 

Message 1 of 5
4 REPLIES 4
Community Boss

Re: Import from module with greater dimensionality

First, create a view in the source module of what you are wanting to export, excluding an parent level data, filtering on the data needed (Actual and AUD) and save it. On the target module, import the data from the view you just saved.

Hope this helps,

Rob
Message 2 of 5
Contributor

Re: Import from module with greater dimensionality

Nice! Yes that should well

 

Thanks Rob!!

Message 3 of 5
Community Boss

Re: Import from module with greater dimensionality

@MarkT83 

One other thing to know; it is possible in the target mapping to select a fixed item when there is no source dimension to map.  You can make this fixed, or have the import prompt the user to select a member of the target dimension

David

Message 4 of 5
Highlighted
Contributor

Re: Import from module with greater dimensionality

Thanks David!

Message 5 of 5