Numbered List in Data Hub to General List in Spoke Model

Dear Members,

I am trying to import from from a Numbered List in Data Hub to a General List in Spoke Model.

In the Import Mapping settings pop up, it does not map any members automatically and the only option available to do is manually. Has anyone faced this issue?

Is there a way to make this mapping automated?

Thank you.

Accepted answers

All comments

ChrisAHeathcote

@CommunityMember118093

Use the list code to map your numbered list in hub to the spoke model.

If you have no code then create a process where you able to concatenate properties in the hub so this can be exported to the spoke model when you create the target list.

When working with numbered lists always map the code as this is the only way to uniquely identify each list item.

jackcplanning

I'd recommend using a properties module in the data hub to set up the export. It's not recommended to do a list to list import between models.

Create a module with the numbered list as a dimension, set up line items for the code & name, save a view with the relevant data/line items. Then import it into the spoke model list.

CommunityMember118093

@jackcplanning That is how I am doing. I am importing from a module view where Product and Profit Center are numbered lists, into a module in Spoke model where these 2 dims are General Lists. When I am try to map these, I get the system generated identifiers for those 2 lists which does not match with any members in the General List (in spoke model). Is there a way to handle this?

jackcplanning

It looks like it's trying to map on the numbered list name (which is a unique number generated by Anaplan). You will want to use a code instead. Add two line items in the source module (profit_center code & product code) with the code. It should then map to the target list. Let me know if that helps.

SRoberts

In the data hub, create a saved module view of the data you want to export. Create a line item for each numbered list dimension and use it to display the list item's code (preferably by linking to your system modules). Then when you import into the spoke model, in your case you'll map to the two new line items and ignore the numbered list dimensions.

Here is an example of a similar import I created. In my case, the F2 Fund dimension is numbered so I created a code (text formatted) line item that displays the fund code and mapped to that. Major Account L2 is NOT numbered so I did not need to create an additional line item:

(Disclaimer, The City of Tallahassee is a public entity and all data is public information. This screenshot does not display any private or propriatery information)

alexpavel

@CommunityMember118093 Usually these kinds of lists (dimensions) like ProductCenters and Products have assigned also the Codes in the legacy systems.

When transferring data from DataHub to spoke models I would use the ProfitCenter Code and Product Code instead of the internal numbered lists Names ( as @ChrisAHeathcote suggested)

If also in the target models these lists are also numbered lists - then you will have a lot of pains... 🙂

Hope it helps

Alex

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…