To pull or not to pull?: Loading Distribution List to SYS07 Location Details Module (Lvl 2 18.104.22.168)
This is an exercise to create a data hub and, as a preparation, I have asked to load data in a flat list in a preset structure as per below:
Please note that there is Distribution Center? field to it, which was already set when I uploaded this assigned model. Since it is there, I have uploaded the true/false boolian values from locations.csv file as per attached:
Then this particular task is to load the rest of the information from locations.csv into SYS07Location Details Module, which was pre-set like this:
So, I have uploaded the data as per:
As I was suspecting that the "Distribution Center?" information would be pulled through from the Location Flat list, I did not import this particular field. But there is no lookup formula preset for Distribution Center values in this module.
So, my question is this:
Above made me think whether or not I need to upload this data separately from the Location Flat list. But if so, what is the point of uploading this value in the Location Flat list as we are duplicating the Distribution Center? values in two places defeating the purpose for the single place of truth, which was what User Story by the Model Builder wanted.
OR, do I need to work on the formula on SYS07 so to pull the data from the Location Flat list?
Any pointer to the right direction would be much appreciated!
The 'Distribution Center?' Boolean in the Location list is actually a subset, which can't be referenced from a module's line item. It doesn't hurt to populate the line item from your flat file, but if I remember correctly, it won't end up driving anything through the rest of the build, so either way should be fine.
So, I gather from your reply that I should be loading "Distribution Center?" values in SYS07 module rather than Location Flat list.
Do you see the intension for this training course on why they have a prepopulated the subset item "s Location Flat: Distribution Centers?" in Location Flat list when we could just be done away with it in the module?
I am only trying to make sense out of this situation... Any thoughts on this would be much appreciated.
My guess as to the intentions is just to demonstrate different ways to populate those Booleans.
Again, working from memory, but I think the Location Details module in the Supply Chain model is formula driven based on what's in the subset, so I think it's more important to have the subset populated for now, whether directly from the CSV file or imported via saved view as described by @ashish.banka.
@kotoponus You do not need to export the data from the SYS module in Step 4 into a csv file. You can create an import using Module / Saved Views too using "Connect to Anaplan Model" and selecting the same Model and the corresponding Module / Saved View. This works similar to Import using CSV however in place of CSV, the source would be Module / Saved View
I realised as I went on further at 1.3.8 Model-to-Model import that you can do that and thought this was probably what you were referring to. And I have done the activities where I import from views of models to lists. So what you are saying is:
1. Import the relevant location data into SY07 including the Distribution Center values based on Location Flat list (There are no Distribution Center values in the list by this point.)
2. Using this module or the view as a byproduct of the module to import the Distribution Center values into the Location Flat list given you have the field to import the information.